Issue 113890 - [Meta] Hidden rows are treated as visible.
Summary: [Meta] Hidden rows are treated as visible.
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on: 108087
  Show dependency tree
Reported: 2010-08-14 20:42 UTC by th3pr0ph3t
Modified: 2014-04-04 18:23 UTC (History)
3 users (show)

See Also:
Issue Type: TASK
Latest Confirmation in: ---
Developer Difficulty: ---

This spreadsheet shows the expected result when working with hidden cells, and the (bad) results obtained. (9.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-14 20:43 UTC, th3pr0ph3t
no flags Details
Two cases where hidden rows are ignored properly. (16.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-14 21:03 UTC, th3pr0ph3t
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description th3pr0ph3t 2010-08-14 20:42:46 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 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.
Comment 1 th3pr0ph3t 2010-08-14 20:43:58 UTC
Created attachment 71113 [details]
This spreadsheet shows the expected result when working with hidden cells, and the (bad) results obtained.
Comment 2 th3pr0ph3t 2010-08-14 21:03:45 UTC
Created attachment 71114 [details]
Two cases where hidden rows are ignored properly.
Comment 3 Edwin Sharp 2013-11-17 18:12:11 UTC
Problem depicted in attachment 71113 [details] is confirmed with

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Comment 4 Rainer Bielefeld 2014-03-25 05:42:29 UTC
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
Comment 5 Rainer Bielefeld 2014-04-04 18:22:42 UTC
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.
Comment 6 Rainer Bielefeld 2014-04-04 18:23:39 UTC
Related: "Issue 108087 - Find may not find hits in rows hidden by filter"