Issue 114191 - toolbar sort range incorrect with more than one heading row
Summary: toolbar sort range incorrect with more than one heading row
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-08-30 04:10 UTC by Joe Smith
Modified: 2013-07-10 12:19 UTC (History)
2 users (show)

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

Sample document showing problem (116.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-30 04:10 UTC, Joe Smith
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Joe Smith 2010-08-30 04:10:23 UTC
Clicking on the toolbar sort buttons should automatically select a reasonable
range of cells to sort, excluding any heading row above the data.

The automatic selection works when there is a single row of text headings at the
top of the data cells, but it fails rather badly when more than one row is
present. The text rows under the first are sorted with data cells and the result
is scrambled.

See the attached document for an example.

I believe Excel handles this situation as expected, but I have not actually
tested it.
Comment 1 Joe Smith 2010-08-30 04:10:58 UTC
Created attachment 71468 [details]
Sample document showing problem
Comment 2 Edwin Sharp 2013-07-10 12:19:50 UTC
Sort fails in Rev. 1499347 Win 7. Even when A4:B13 are highlighted sort fails - sort is according to short name instead of ID.

Also Excel 2007 fails.