https://bugs.documentfoundation.org/show_bug.cgi?id=96953
Bug ID: 96953
Summary: Data Sort not sorting correctly with multiple fields
Product: LibreOffice
Version: 4.4.7.2 release
Hardware: All
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 121787
--> https://bugs.documentfoundation.org/attachment.cgi?id=121787&action=edit
screenshot documenting problem, underlying .xlsx file - note that I use .xlsx
format for compatibility with colleagues, but the same problem is present in
.ods format
With Data Range defined and Sort options set to include identification of
Column headers, sorting on three Keys (comp, chestForce, chestAccel - all
numeric) results in incorrect sorting on 2nd key.
Attached screenshot following sort by comp, chestForc, chestAccel shows among
comp = 0.00, chestForce goes from long series of 0.00 (as it should) to 0.04,
back ot 0.00, up to 3.10, back to 0.01,0.01, down to 0.00, 0.00 - all out of
order per sort request.
Sorting on 3rd key is inconsistent as well. Note that among comp = 0.00,
chestForce = 0.00, chestAccel goes from many 0.00, to sequentially sorted 2.16
.. 62.91 (as it should) but then dow to 0.56, then up to 9.20, 14.55 (as it
should locally). After that, it is confused with 2nd key being out of order.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
