[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