https://bugs.documentfoundation.org/show_bug.cgi?id=149662
Bug ID: 149662
Summary: Standard filter treating text badly if being composed
of digits only
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 180879
--> https://bugs.documentfoundation.org/attachment.cgi?id=180879&action=edit
the example announcede in the report
If textual content of cells only consists of deciomal digits, it is not
correctly treated as text by comparators in standard filter. In fact no
comparator except "=" seems to return 'true'.
The attached example is showing filter dialogs and the respective results.
The cells below D1 should show "1", "17", "18", "19" if the compartison is
correctly sone as needed for texts.
In case of one of the expectable errors of a numeric comparison or a comparison
like used for NaturalSort, the single returned value should be 1 or "1".
The actual result is "no match".
Column Q is showing the correct result obtained as soon as the textual nature
of the contents is in addition made unmistakable by a leading letter.
--
You are receiving this mail because:
You are the assignee for the bug.
