Issue 99269 - Sort range with hidden rows shows unexpectected result
Summary: Sort range with hidden rows shows unexpectected result
Status: CONFIRMED
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:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
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: ---

Attachments
Sampld document with comments (14.49 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-02-16 17:54 UTC, Rainer Bielefeld 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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

MPV
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
function.

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
Rev.1551017
Win 7