https://bugs.documentfoundation.org/show_bug.cgi?id=153206
--- Comment #6 from Hendrik Maryns <[email protected]> --- (In reply to Stéphane Guillou (stragu) from comment #5) > 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. And ‘You can define the sort rules on Data - Sort - Options.’ is not really true; this is exactly the point I try to make here. > Hendrik, the example you provide gives me a result that makes sense: > - First, numbers from lowest to highest (three first rows) > - Then, text strings, alphabetically, with numbers first (two last rows) They make sense if you look at it with a particular logic, which you are probably familiar with. As a non-programming end user, this is a non-intuitive logic. > 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. Agree! > Should we change this into a documentation improvement? I hope that, apart from fixing the documentation, it can also be enhanced so that one can choose to sort dates, times, numbers etc. as text. Makes sense in my case, though maybe in another situation you would want it differently. -- You are receiving this mail because: You are the assignee for the bug.
