I have spreadsheets for tracking expenses that include a column for categorizing the expense. If I sort the sheet with that column as the primary key and select the "Range contains column labels" option, the column label row gets sorted in with the rest, putting it elsewhere than at the top row.
Steps to reproduce:
1. Create a spreadsheet with column labels, including a date, a "what" column and other columns that contain currency cells.
2. Fill in some rows with dates, a category and dollar amounts, not all of which are filled in (typically one column per row).
3. Sort using the "what" column as the primary key and one or two other columns as secondary (and below) keys.
The label row will be sorted in alphabetical order by the contents of the "what" column, not left at the top.
The header row should never be moved from the top row.
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:16.0) Gecko/20100101 Firefox/16.0
Duplicate of bug 53482 fixed in LO 3.6.3.
Please upgrade to the current version and try again.
Best regards. JBF
*** This bug has been marked as a duplicate of bug 53482 ***