Description: When use the standard filter to filter some numeric field, the filter don't works if the value (of the condition) has any decimal places Steps to Reproduce: 1. Open the attached database 2. Open the Table1 3. Reset filter/sort (Data > Reset filter/sort or the bar button with the same name) 4. Select Data > Standard filter 5. On filed name select "dec2 6. On criteria select for example "<" (less than) 7. On Value Write "2.1" Actual Results: All values are shown, so The table do not filter data Expected Results: Only values less than 2.1 should be shown (only the first register) Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb) Locale: es-ES (es_ES.UTF-8); UI: es-ES Calc: threaded ---------------------------------- Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 04bad6534b74af0ec9d0a516e0bf0a9c5ec5568c CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded
Created attachment 193272 [details] Test database
Reproducible Version: 24.2.2.1 (X86_64) / LibreOffice Community Build ID: bf759d854b5ab45b6ef0bfd22e51c6dc4fb8b882 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded In fact, opening the Standard filter again doesn't show the condition. No matter if the separator is dot or comma.
Created attachment 193277 [details] HSQLDB sample file create ver 4.4 There seems to be a regression Works for using comma as separator with Version: 4.4.7.2 Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600 Locale: es_ES First bad (for those I have installed) Versión: 5.4.7.2 Id. de compilación: c838ef25c16710f8838b1faec480ebba495259d0 Subprocs. CPU: 16; SO: Windows 6.2; Repres. IU: predet.; Configuración regional: es-ES (es_ES); Calc: CL Sample file is opened fine in ver 5.4 with the filter enable, and even allows to modify the filter, but after reset the filter is not possible to create the filter again.