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.
