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.
In Menu/Data/Sort/Options, you can set: Range contains column labels
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 ***