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.

Reply via email to