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.
Couldn't reproduce it in 24.8. 24a08fcf600f0590972cd9943423dc22c0a2016c is the first bad commit commit 24a08fcf600f0590972cd9943423dc22c0a2016c (origin/master, master) Author: libreoffice <libreoffice@libreoffices-MacBook-Air.local> Date: Tue Oct 29 03:35:47 2024 +0100 source f6c9d1012d20541f6373b51ff3c25d8fd7bc8c69 source f6c9d1012d20541f6373b51ff3c25d8fd7bc8c69 LibreOffice.app/Contents/Frameworks/libvcllo.dylib | Bin 15743184 -> 15743184 bytes LibreOffice.app/Contents/Resources/setuprc | 2 +- LibreOffice.app/Contents/Resources/versionrc | 2 +- 3 files changed, 2 insertions(+), 2 deletions(-)
The bug *is still* reproducible ----------- Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: es-ES (es_ES.UTF-8); UI: es-ES Calc: threaded ----------- Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded ---------- Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: deaa5dc2a4d5446cdd120236615608702598e365 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
unable to reproduce on oldest version of the following: Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 798b43c4ef433d9f2cbfa431ebdf9ec35c3b8a39 CPU threads: 24; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded
Working well in (i'm using . as the separator) Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 CPU threads: 16; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Workign well also in Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: b50b8c227a014c2f5590be6ff1a8e9d7594d2382 CPU threads: 16; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
More testing to isolate the version: Worked as expected in install of 25.2, bibisect-win64-24.2, and bibisect-win64-7.6. Unable to fully test in bibisect-win32-6.0 and bibisect-win32-5.4 as both open the supplied test file but generate a SDBC driver error when navigating to the table. Specific version details are listed below. Version: 25.2.3.2 (X86_64) / LibreOffice Community Build ID: bbb074479178df812d175f709636b368952c2ce3 CPU threads: 2; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 6f227b0dd912d4c70a01eb3872fff15d52de543a CPU threads: 2; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Version: 7.4.0.0.alpha1+ (x64) / LibreOffice Community Build ID: c94961c6869c34b3874d21cfaa5ec1488609acfe CPU threads: 2; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Version: 6.0.6.0.0+ Build ID: c30963b8b4bbbe42a24b97aafa161eff9d7ccdd4 CPU threads: 2; OS: Windows 10.0; UI render: default; Locale: en-US (en_US); Calc: group Version: 5.3.0.0.alpha1+ Build ID: 4136757b4e51c4e6f7cb4132c95538a7f831ef2c CPU Threads: 2; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; Locale: en-US (en_US); Calc: group
It's still working *incorrectly*. Note, that sometimes it seems to work, but if you execute step 3. 'Reset filter/sort (Data > Reset filter/sort or the bar button with the same name)', the filter stops working properly. Also note that if you reset the filter and write a new condition, when click ok, the condition should be applied and saved in the dialog, also the button 'Apply Filter' should be activated but none of this occurs. -------------------------- Version: 25.2.4.3 (X86_64) / LibreOffice Community Build ID: 33e196637044ead23f5c3226cde09b47731f7e27 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded ---------------------------------- Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fa4ca41986d58a93e8aeef7b78f2037a941c40d5 CPU threads: 16; OS: Windows 11 X86_64 (build 22631); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded ---------------------------------- Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb) Locale: es-ES (es_ES.UTF-8); UI: es-ES Calc: threaded