https://bugs.documentfoundation.org/show_bug.cgi?id=153387
Bug ID: 153387 Summary: UX: Sorting string not following Unicode / ASCII order by default Product: LibreOffice Version: 3.6.7.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: enhancement Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: frank...@goodhorse.idv.tw Description: In the default behavior of data sorting in Calc (Writer as well, see reference questions), the sorting algorithm is not following Unicode/ASCII code, which I think it's an intuitive and reasonable default behavior. If it is not, what kind of behavior does it follow? I didn't find any document explaining the default sorting algorithm or behavior. Language/locale settings? Opening with en_US.UTF-8 locale got the same result. You can visit the reference 2. I'll attach the file here later. It may not be a bug, but a user experience issue. Reference: 1. https://ask.libreoffice.org/t/calc/86667 2. https://ask.libreoffice.org/t/calc-data-sorting-not-following-ascii-unicode-order/87503 3. https://ask.libreoffice.org/t/writer-not-sort-following-ascii-code/84334 Steps to Reproduce: 1. Open the attached file 2. Data -> Sort Column B as ascending 3. The result does follow ASCII/Unicode code Actual Results: The result does follow ASCII/Unicode code Expected Results: - Following ASCII/Unicode is a reasonable default behavior IMO - If not, any document describing the default sorting algorithm? - If not, any option to force following ASCII/Unicode order? (Filling every character in Tool - Options - Calc - Sort List is NOT a user-friendly solution IMO) Reproducible: Always User Profile Reset: No Additional Info: Earliest version I tested: 版本 3.6.7.2 (組建 ID:e183d5b) Should be inherited from OO.o I think. -- You are receiving this mail because: You are the assignee for the bug.