Created attachment 121787 [details] 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.
Comment on attachment 121787 [details] 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 I tried to attach the spreadsheet as well, but BugZilla appears to support only one attachment. Let me know if you need the spreadsheet as well.
Created attachment 121788 [details] the problem spreadsheet, in xlsx format (same problem is present in ods format) maybe this will get you the spreadsheet as well? BugZilla interface confusing.
Created attachment 121789 [details] Screenshot with more decimal Do not trust what you see. You see a long list of 0.00 while Calc use the true content of the cell. Look at the screenshot where I add more decimal.