Apache OpenOffice (AOO) Bugzilla – Issue 113890
[Meta] Hidden rows are treated as visible.
Last modified: 2014-04-04 18:23:39 UTC
This is related to issue 113742. However, I consider this issue as the cause of 113742 and therefore not a duplicate. There is a problem in OpenOffice.org Calc: it operates on hidden rows/columns as if they were not hidden. I expect hidden rows not to be affect when hidden, for instance, when filtered. If you navigate using the arrow keys you'll skip hidden rows/columns, this is the only thing that works okay, but: - If you use Shift+Arrow keys to select a range of cells, the selection would include the hidden cells too, one keystroke for each hidden cell. -- hidden cells should be excluded from the selection. - If you select a range of cells and pull down the bottom-right corner to fill with sequential values, hidden rows are modified -- then shouldn't be affected. - If you have a range with autofilter, filter some rows and attempt to delete only the rows that pass the filter, you will delete hidden rows in between -- they shouldn't be deleted.
Created attachment 71113 [details] This spreadsheet shows the expected result when working with hidden cells, and the (bad) results obtained.
Created attachment 71114 [details] Two cases where hidden rows are ignored properly.
Problem depicted in attachment 71113 [details] is confirmed with AOO410m1(Build:9750) - Rev. 1539999 2013-11-09_04:08:11 - Rev. 1540252 Debian
Version has been modified erroneous, so back to most early version I think all this is already known, and definitively not limited to Linux. I will check later for DUPs and so on
Here are several issues mixed, and for example not considering that for several cases results for treatment of cells hidden by filter differ from results for cells hidden via row heading-hide. We need to distinguish these different cases carefully. Additionally we already (might) have some reports for particular cases. So I modify this one to a Task bug. We will have to submit separate Bug reports for each particular case.
Related: "Issue 108087 - Find may not find hits in rows hidden by filter"