Apache OpenOffice (AOO) Bugzilla – Issue 16760
default sorting includes column headers
Last modified: 2013-08-07 15:15:02 UTC
Set up a database with column headers in row 1 and columns of data in rows 2+. Select one of the filled cells within the database and press one of the sort buttons. The column headers are included in the sort! This is supposedly how older versions of Excel worked, but newer ones know enough to ignore column headers. Calc should do the same. The alternative is to require that the entire database (exclusive of the column headers) be first selected, and then the sort done. That is unnecessary in newer versions of Excel.
Not a bug, but maybe an enhancement.
duplicate to issue 22758. *** This issue has been marked as a duplicate of 22758 ***
.