https://bugs.documentfoundation.org/show_bug.cgi?id=146811
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ilmari.lauhakangas@libreoff | |ice.org Blocks| |108827 Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #4 from Buovjaga <[email protected]> --- (In reply to Mike Kaganski from comment #0) > Make sure to *disable* Options->Calc->Calculate->Search criteria "=" and > "<>" must apply to whole cells. > > Put this formula in A1: > > ="" > > Put this formula in B1: > > =COUNTIF(A1:A10; "") > > The observed result in B1 is 9, but is expected to be 10. Note that the > result of '=COUNTIF(A1:A10; "=")' using comparator *is* expected to be 9, > and it is OK in Calc. See COUNTIF documentation [1], and Criterion > documentation [2] (the criterion "" matches the "Other Text value" clause > there). Repro Arch Linux 64-bit Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 2b093d27b7e6f231512920f20089fcac291b021f CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 2 December 2022 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
