Issue 99269 - Sort range with hidden rows shows unexpectected result
Summary: Sort range with hidden rows shows unexpectected result
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO300m9
Hardware: PC Windows, all
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-02-16 16:18 UTC by pachecovieira
Modified: 2013-12-19 08:49 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Sampld document with comments (14.49 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-02-16 17:54 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pachecovieira 2009-02-16 16:18:53 UTC
Sort table with hidden columns

In calc I have the table

	A	B
9	5	11
10	4	10
11	3	11
12	2	10

I hide the line 10

	A	B
9	5	11
11	3	11
12	2	10

I sort the table and I have.

	A	B
9	2	10
11	4	10
12	5	11

I think that the result had to be

	A	B
9	2	10
11	3	11
12	5	11

Comment 1 Rainer Bielefeld 2009-02-16 17:42:34 UTC
Really great idea to type all that here instead of attaching a sample document ;-)

And BTW, it seems we are talking about "sort rows"?

I checked with "Ooo 3.0.1 (DE) Multilingual version German UI WIN XP: [OOO300m15
(Build 9379)]" and can confirm the reported effect. Hidden Line ten will be
included into the sort operation, and the contents of old line 10 will be moved
to line 11.

Bug a or feature? Some functions completely ignore hidden rows, for example
cursor movement with the arrow keys. Other ones will be done for hidden rows if
they are in a selected range, for example background colour. And sort will not
work for a range containing hidden rows.

I see some problems concerning this inconsistency: if line 10 has been hidden by
a standard filter, it is impossible to sort a range containing that hidden row.
 But sort operation will be possible if the line has been hidden with the hide

I think this is one for the user experience team.
Comment 2 Rainer Bielefeld 2009-02-16 17:54:27 UTC
Created attachment 60203 [details]
Sampld document with comments
Comment 3 Edwin Sharp 2013-12-19 08:49:54 UTC
Excel 2010 doesn't expose the hidden row when sorting.
AOO410m1(Build:9750)  -  Rev. 1551017
Win 7