https://bugs.documentfoundation.org/show_bug.cgi?id=172646
Anders Lind <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #3 from Anders Lind <[email protected]> --- Thanks for the suggestion. I have now tested with the "Search criteria = and <> must apply to whole cells" option both enabled and disabled. In both LibreOffice versions, "Enable wildcards in formulas" was enabled. To "sum" up the below results: The regression is reproducible only when "Search criteria = and <> must apply to whole cells" is enabled. When that option is disabled, both versions behave identically. Results LibreOffice 7.6.7.2 Version: 7.6.7.2 (X86_64) / LibreOffice Community Build ID: 60(Build:2) CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: da-DK (da_DK.UTF-8); UI: en-US Ubuntu package version: 4:7.6.7-0ubuntu0.20.04.1~lo1 Calc: threaded With "Search criteria = and <> must apply to whole cells" enabled: =SUMIF(A1:A3;"🌴*";B1:B3) → 1 =SUMIF(A1:A3;"*🌴";B1:B3) → 10 =SUMIF(A1:A3;"*🌴*";B1:B3) → 11 With the option disabled: 11 11 11 LibreOffice 26.2.4.2 (Flatpak) Version: 26.2.4.2 (X86_64) Build ID: 0229ac93fcf0d7cbc6376066c6f35021cef002dc CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: da-DK (da_DK.UTF-8); UI: en-US Flatpak Calc: threaded With the option enabled: 1 0 1 With the option disabled: 11 11 11 -- You are receiving this mail because: You are the assignee for the bug.
