Created attachment 197013 [details] Simple example file from Calc Attached file has some percentage values calculated by division. When trying to apply standard filter to the column, there is no results given back except for the = 0% condition. 1. Open attached file 2. Apply standard filter on the column D with condition > 50% -> 0 results are given 3. Change the filter condition to = 0% -> 1 result is given, this is correct Seems to have started with: https://git.libreoffice.org/core/+/1f755525189884e4b2824889a6b9dea8933402db commit 1f755525189884e4b2824889a6b9dea8933402db [log] author Balazs Varga <balazs.varga991@gmail.com> Tue May 25 18:23:16 2021 +0200 committer László Németh <nemeth@numbertext.org> Mon May 31 12:15:41 2021 +0200 tree e3b8dbe7dc686e4460cb7105ace91ee2507653b2 parent 9bf1089965672d3825b587cbd888093ac362013e [diff] tdf#142402 sc UI: store formatted values in standard filter Symptom is similar to bug 153057 which was also bibisected to this commit. May or may not be the same problem.
Created attachment 197014 [details] The filter and its results before the regression
Created attachment 197015 [details] The filter and its results after the regression
Reproducible Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 2321626477d4ff930d8bc392efa6ea84e8825171 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Works with > 0,5 but not with > 50%
I changed the flag as Bibisected, based on Description.