Issue 114191 - toolbar sort range incorrect with more than one heading row
Summary: toolbar sort range incorrect with more than one heading row
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Sample document showing problem (116.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-08-30 04:10 UTC, Joe Smith 		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 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.