LibreOffice Calc v188.8.131.52 on Windows 10 and
LibreOffice Calc v184.108.40.206 on Ubuntu 22.04 LTS
cell A1 is empty
cell B1 contains formula ="" (which results in showing as a blank cell)
cell C1 contains formula =COUNTIFS(A1:B1, “<>”)
according to LibreOffice Calc help “For <>, if the value is empty it matches non-empty cells” and I expect the result in cell C1 to be 0.
In Windows version of LibreOffice Calc this result IS 0. In Linux version it USED TO BE 0 before I upgraded to 7.3 but now it calculates to 1 - so it considers cells containing formulas as non-empty on linux regardless of the result of the formula and it considers cells containing formula that calculates to “” as empty on Windows.
So my question is:
I would like to configure my Linux LibreOffice Calc 7.3 to behave as it used to and match the behavior of my Windows LibreOffice Calc 7.3. In other words, I would like COUNTIFS in the above scenario return 0. How do I do that? I checked the Tools-Options-LibreOffice Calc settings and they are identical as far as I can tell.
And a philosophical question (this doesn’t really need answering):
Why would I care to count cells containing formulas using COUNTIFS if those cells return “” appearing as blank in the first place? Seems more of a feature for debugging spreadsheets rather than using them - it would make more sense to see cell that appears blank because formula it contains results in blank as “empty” and this is how to it used to behave on both Linux and Windows when I originally created my spreadsheets…
Thank you for taking your time to answer my question.