[Libreoffice-bugs] [Bug 140014] Calc crashes when using COUNTIF, SUMIF, etc. on columns "far away" without data

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Feb 2 21:22:18 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=140014

--- Comment #9 from Leyan <ouyang.leyan at hotmail.com> ---
That's because of your locale. You should type "=COUNTIF(BM5:BM9;0)" using the
semicolon separator, not the comma.

I tried en_ZA, I can reproduce it with:

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: d2fe1369ca92f3978a5203498d1ad2898c6a09e8
CPU threads: 4; OS: Linux 5.9; UI render: default; VCL: gtk3
Locale: en-ZA (en_ZA.utf8); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210202/0db60f36/attachment.htm>


More information about the Libreoffice-bugs mailing list