Created attachment 180879 [details] 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.
Shou8ld add that the above reported results in column D are unchganged, if column A is formatted 'General' (or otherwise for numbers), and the shown textual represented numbers are returned by formulas like =TEXT(1;"0").
Reproducible Version: 7.3.4.2 (x64) / LibreOffice Community Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: e4d23c27288b99c3ed3cfa332ff308b31c01f97d CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL