https://bugs.freedesktop.org/show_bug.cgi?id=55186
Bug #: 55186
Summary: EDITING: Ordering wrongly includes the headers when
last header is empty
Classification: Unclassified
Product: LibreOffice
Version: 3.6.1.2 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: silva...@katamail.com
Problem description:
When you have some column of data, all with a header except for the last one,
when ordering the option "selection includes headers" is off by default. You
can turn it on, and then you will be able to select the ordering criteria based
on the header names instead of column lettering (this is correct). However, the
resulting order moves the first line containing header as if it were a normal
data line to be ordered (this is incorrect, since you specified that data had
headers used to identify columns)
Steps to reproduce:
1. fill some coloums with any numeric data, and put some text description in
the first row above these columns, except for the last columns on the right:
for this, leave the header cell empty.
2. select the whole set of data, headers included, and go to the "data>sort"
menu command (I am not using the english version, so the exact command names
may not correspond to the actual one). In the first page, where you set the
ordering criteria, the choices are "column A" etc.
3. switch to the second page of the sorting dialog, and tick the option "data
contain headers in the first row".
4. now go back to first page, and you can correctly choose among the various
headers, or the "column XX" for the last column that has no header. Choose for
example the first column header as sorting criteria.
5. the result is incorrect in that the first row containing headers was ordered
together with the data rows, while it should have been excluded from the
sorting, staying on top in any case. This happens (correctly) when all header
cells are not empty.
6. the same error takes place if the empty header is in another column (not the
last one), or even if there is a numeric data in one of the headers.
I think this did not happen in older releases, but I can't say in which release
it started
Expected behavior: when the option for the first row containing headers is
active, any sorting operation should leave the first row on top regardless of
the fact that some header cells maybe empty of may have numerical content
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:15.0) Gecko/20100101
Firefox/15.0.1
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
