Created attachment 198170 [details] Screenshot of the Standard Filter dialog This is related to bug 163395, and reproducible once its patch gets merged. Or in older versions before 7.1. When the example file attachment 197013 [details] is opened in Calc and I try to set a standard filter on the percentage values in column D, the Standard Filter dialog shows them with many digits and not formatted like in the cells. This can cause incorrect filtering, as the values may be rounded to 1/2 digits and filtering for the many digit representation of values may give different results than expected. 1. Open attachment 197013 [details] 2. Data - More Filters - Standard Filter 3. Select the Open Ratio - 23 field name 4. Select <= as Condition 5. Select a value with many digits like "31.578947368421%" - these do not consider the formatting set in the sheet, similar to the Autofilter -> the value 31.58 is not <= than the above, so it is not shown. However, a sane approach would be to list in the Autofilter and Standard Filter list the formatted values.
Created attachment 198174 [details] Screenshot with data list to filter as percent Works for me with Version: 24.8.4.1 (X86_64) / LibreOffice Community Build ID: 1be9007f5d86a3741c366527d13e2970cbeef057 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded and Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 537645c0834eab2d277113f1e3fcf039c994832d 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
Interesting! It works for me too with es_ES locale, but not with hu_HU and en_US, in a recent-ish master build.
Right also fails for me with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1846448d81aab9812410a30303c0c36a41a825b6 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (es_ES); UI: en-US Calc: CL threaded