Red Hat Bugzilla – Bug 146758
Cannot unhide rows in calc
Last modified: 2007-11-30 17:10:59 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.3) Gecko/20041020
Description of problem:
If you hide a row in calc, you cannot later show the hidden row. Columns work fine, this problem is only with rows.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1.highlight row #5 in an empty calc spreadsheet
2.In the pulldown menus: (Format -> Rows -> Hide) row #5 is now hidden
3.highlight rows #4 and #6
4.In the pulldown menus: (Format -> Rows -> Show) row #5 remains hidden
Actual Results: Row # 5 is not shown
Expected Results: Row #5 should be shown
You can repeat the above steps for a colummn to see how it should work. I mark this as a "loss of data" bug because I have data that I cannot access in my spreadsheets, hidden behind un-show-able rows!!!
It happens here, too.
See also http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=289013
Temporary workaround: Copy the row previous and the row following to the
clipboard, then paste back in somewhere else. The hidden rows were copied/pasted
along with the two visible ones.
I couldn't find anything in the OOo bugtracker but didn't think it appropriate
to file something there as I'm not running their latest version (1.1.4 as of
today, compared to my openoffice.org-1.1.3-2.5.fc3)
Thanks for the workaround Adam! At least I can get to the data now.
I'm pretty sure this bug is due to some RH patch, I tried an official OOo
release a few months ago (1.1.3 as I recall) and I do not remember seeing this
Technically yes it is a Red Hat patch, I patched the Novell patch for this in
our 1.1.2 version, but it seems to have broken again even though the patch has
It's fixed on 1.3 branch of ooo-build.
will be fixed in next update (1.1.3-7)
looks good in 1.1.3-9