Created attachment 198797 [details] 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
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 198798 [details] Sample document
Reproducible Version: 24.8.4.2 (X86_64) / LibreOffice Community Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded + Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 85c8901dc2710e91bccb64cd7d8068441f42f65b CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Latest version that works on the ones I have installed. Version: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 16; OS: Windows 10.0 Build 26100; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL But 6.4 shows the items without format. I can't find but I think there are other bug about this matter. I'm not sure if this is a regression or on purpose.