Description: Why does the logical function =IF(OR(J6="",K6=""),"",J6+K6) return "" when the test is TRUE but the function =IF(OR(J6="",K6=""),J6+K6,"") return 0 when the test is false? Steps to Reproduce: 1.Why does the logical function =IF(OR(J6="",K6=""),"",J6+K6) return "" when the test is TRUE but the function =IF(OR(J6="",K6=""),J6+K6,"") returns 0 when the test is false? 2. 3. Actual Results: see above Expected Results: Following function should return "" (null) if test is false =IF(OR(J6="",K6=""),J6+K6,"") Reproducible: Always User Profile Reset: No Additional Info: return "" instead of zero
On pc Debian x86-64 with LO Debian package 24.2, I don't reproduce this. Could you give a try on a recent LO version like 7.6.4? If you still reproduce this, could you attach an example file?
When _both_ cells are not equal to "", then the result is J6+K6, which could possibly be zero (among many other possibilities, including errors), depending on the values of each of these 2 cells. This is not a bug report, but rather a question that should better be asked at forum sites such as <https://ask.libreoffice.org>. In any case, anyone trying to help would probably need at least a minimal sample of the spreadsheet document. ATM this "report" is set as NEEDINFO. I would set it as invalid, but I'll leave that for the reporter (Dennis).