Bug 56717

Summary: sorting data in the spreadsheet is not as good as excel
Product: LibreOffice Reporter: Anand Kumria <wildfire>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: serval2412
Priority: medium    
Version: 3.5.4 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Anand Kumria 2012-11-03 14:48:34 UTC 
I am following along the Coursera courge (Computation Investing).

They grab data for a specific month range for a stock (AAPL from finance.yahoo.com) and download it as a CSV.

The data is then sorted.

In Excel; you select the entire spreadsheet, hit the sort menu item and are prompted to pick the column (with the title, e.g. Date, etc, in it) and the data is sorted -- and the row which has columns in it is *NOT* moved.

In LibreOffice; you select the entire spreadsheet, hit the sort menu item and have to pick the column (named as Column A, B, etc.) and the data is sorted.

However the row which has the column title is also sorted.

It would be an improvement if sorting worked as people expect -- not moving the title row.
Comment 1 m_a_riosv 2012-11-21 22:07:14 UTC 
In Menu/Data/Sort/Options, you can set: Range contains column labels
Comment 2 Julien Nabet 2012-12-01 13:53:04 UTC 
Anand: You should give a try to 3.6.3 which contains a fix about this.
If you reproduce this with this 3.6.3, don't hesitate to reopen the tracker, include your file and give a step by step to reproduce the behaviour.

*** This bug has been marked as a duplicate of bug 53482 ***