https://bugs.documentfoundation.org/show_bug.cgi?id=139546
--- Comment #9 from Jürgen Kirsten <[email protected]> --- (In reply to Regina Henschel from comment #8) Hello Regina, Thank you very much for your reply to my comment. > I do not understand. The entry "Default..." is the last one in the list. You > can always go back to that mode. My comment that it should be possible to delete an entry again referred to the situation described in my previous suggestion, where only those languages that allow an entry in Options would be listed. If the default entry is also available in the drop-down menu, then, as you quite rightly pointed out, there is of course no need for it. > That would be bad, because the locale selected there is also used for other > sort properties, e.g. to determine the decimal separator in "natural sort". > Nevertheless the information is useful, which locale is actually used in the > sorting algorithms. I was not aware that the locale setting under the sort options was supposed to influence the sort order for natural sorting. Upon closer inspection and testing of the option, I was unable to reproduce this behaviour. The locale setting does influence the sort order for natural sorting, but not the setting in the sort options, rather the setting in Options - Languages and Locales - General - Formats - Locale:. To test this, I sorted two columns with the entries listed here under different settings. The vertical line here symbolises the cell separation. A1.1 | A1.2 | A1.3 | A1.4 | A1.5 | A1.6 | A1.7 | A1.8 | A1.9 | A1.10 | A1.11 | A1.12 A1,1 | A1,2 | A1,3 | A1,4 | A1,5 | A1,6 | A1,7 | A1,8 | A1,9 | A1,10 | A1,11 | A1,12 So two series of numbers after a letter with a decimal separator. The full stop for the English locale and the comma for the German locale. Changing the locale under the sorting options has no effect and does not change anything. With the German locale under the options, it looks like this: Without natural sorting (as expected): A1.1 | A1.10 | A1.11 | A1.12 | A1.2 | A1.3 | A1.4 | A1.5 | A1.6 | A1.7 | A1.8 | A1.9 A1,1 | A1,10 | A1,11 | A1,12 | A1,2 | A1,3 | A1,4 | A1,5 | A1,6 | A1,7 | A1,8 | A1,9 With natural sorting: A1.1 | A1.2 | A1.3 | A1.4 | A1.5 | A1.6 | A1.7 | A1.8 | A1.9 | A1.10 | A1.11 | A1.12 A1,1 | A1,10 | A1,11 | A1,12 | A1,2 | A1,3 | A1,4 | A1,5 | A1,6 | A1,7 | A1,8 | A1,9 That's completely wrong! Under the German locale, natural sorting should work with a comma, not a full stop. If you change the language in Options - Languages and Locales - General - Formats - Locale: to English, this is what it looks like when using natural sorting: A1.1 | A1.10 | A1.11 | A1.12 | A1.2 | A1.3 | A1.4 | A1.5 | A1.6 | A1.7 | A1.8 | A1.9 A1,1 | A1,2 | A1,3 | A1,4 | A1,5 | A1,6 | A1,7 | A1,8 | A1,9 | A1,10 | A1,11 | A1,12 And here too, it's wrong. Under the English locale, the full stop should work for natural sorting, not the comma. In summary, it seems that your argument that the entry in Sort Options - Locale has an influence and that the information is helpful does not apply. My suggestion that only languages that allow an entry in Options should be listed there is therefore still on the table. Or is it? Perhaps I have misunderstood something or carried out the tests incorrectly. You wrote that natural sorting is only one example. What other sorting options does the entry under the locale affect? I would like to test that as well. It would be nice if you could comment on this again. In your opinion, should the apparently incorrect sorting when using the natural sorting option be treated as a separate error message? -- You are receiving this mail because: You are the assignee for the bug.
