https://bugs.documentfoundation.org/show_bug.cgi?id=154011
Bug ID: 154011
Summary: Numeric sort doesn't work
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
rows before sort:
17,97968
18,00363
17,22748
rows after sort:
17,97968
18,00363
17,22748
Steps to Reproduce:
1. create the sheet containing the above numbers
2. sort it
Actual Results:
nothing changes
Expected Results:
numerically sorted rows
Reproducible: Always
User Profile Reset: No
Additional Info:
Please note that comma is used as decimal character, as it is the decimal
character of the regional format setting (Hungarian) in my Ubuntu 22.04.1.
If I replace commas with dots, the sorting is performed correctly.
However, Hungarian locale is selected in the L.O. Calc's tools/options/language
settings, and comma is set as decimal separator ("Same as locale setting" is
checked)
Now there seem to be 2 problems:
1. calc is probably not aware of the decimal character of the locale
2. even if calc doesn't treat these cells as numbers, it still doesn't explain,
why the rows are not sorted alphabetically (which would result the same, as if
they'd be sorted numerically)
--
You are receiving this mail because:
You are the assignee for the bug.
