https://bugs.documentfoundation.org/show_bug.cgi?id=153206
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |stephane.guillou@libreoffic | |e.org Blocks| |108386 --- Comment #5 from Stéphane Guillou (stragu) <[email protected]> --- I agree this could be better documented. We've got: - https://help.libreoffice.org/latest/en-US/text/scalc/01/12030100.html - https://help.libreoffice.org/latest/en-US/text/scalc/01/12030200.html There's mention that "Number fields are sorted by size and text fields by the order of the characters", but it doesn't clarify what comes first, and also that the alphabetical part starts with numbers. Hendrik, the example you provide gives me a result that makes sense: 215468 499432 6545146 306518/8 v123245 - First, numbers from lowest to highest (three first rows) - Then, text strings, alphabetically, with numbers first (two last rows) What might be more surprising to users is the inclusion of dates and times in the column. The logic should also be explained in the documentation. Should we change this into a documentation improvement? Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108386 [Bug 108386] [META] Calc sorting related bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
