https://bugs.documentfoundation.org/show_bug.cgi?id=174262
--- Comment #1 from [email protected] --- Reproduced in 26.8.1.1: D1=0, E1=1, F1=0. Same with plain formulas: =C1>A1 is FALSE, =C1=A1 is TRUE, =C1-A1 is 0, but =RAWSUBTRACT(C1;A1) is 2.7756E-16. So COUNTIF follows Calc's normal comparison of near-equal values. Version: 26.8.1.1 (X86_64) Build ID: bf6ef2662401c7d6dce671ab4deb26ee0af3a7c1 CPU threads: 20; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: zh-CN (zh_CN); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
