https://bugs.documentfoundation.org/show_bug.cgi?id=164887
Bug ID: 164887
Summary: AutoFilter is filtering data as TEXT
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 198797
--> https://bugs.documentfoundation.org/attachment.cgi?id=198797&action=edit
Data formatted as numbers with thousands separator not included in filter
results
Despite of numbers in column, AutoFilter treats them as formatted text.
Ie. enabling thousands separator prevents searching by real value.
IMHO such behaviour is not by design.
BTW MSExcel has the same since ever, but LibreOfficeCalc could be better in
this point either.
Best Regards
--
You are receiving this mail because:
You are the assignee for the bug.