https://bugs.documentfoundation.org/show_bug.cgi?id=167513
Bug ID: 167513
Summary: EDITING: Autofilter sorts (decimal) numerical values
wrongly
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 201807
--> https://bugs.documentfoundation.org/attachment.cgi?id=201807&action=edit
Test file (.xlsx, originally created not by LO, but now multiple times saved by
LO)
That's with Version: 25.2.4.3 (X86_64) / LibreOffice Community (openSUSE build)
Build ID: 520(Build:3), de_DE locale.
Autofilter sorts randomly for the penultimate column:
4,043 5,100 5,629 5,771 7,214 7,357 7,650 6,600 (!) 6,700
sorting again changes the result (but not for the firs columns shown).
The column itself is formatted as number and consists of the equation '= X + Y
- Z' each of the letter I typed refers to a cell of the same row.
In the filer view, the values are all correctly ordered and appear only once.
--
You are receiving this mail because:
You are the assignee for the bug.
