Issue 114191

Summary: toolbar sort range incorrect with more than one heading row
Product: Calc Reporter: Joe Smith <jes>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.2.1   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Sample document showing problem none

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.