Description: Using Calc on a large spreadsheet "IF" formula will return "#VALUE!" when column used in formula is greater than column "N". example: =IF(N42>0,N42-N41,"") will return correct value if N42 has a value greater than 0 and a blank if 0. example: =IF(O42>0,O42-O41,"") will return correct value if O42 has a value greater than 0 but will return #VALUE! if O42 is 0. This seems to be true for all columns "O" and greater. Steps to Reproduce: 1.use "IF" statement 2. reference column "O" or higher 3. use "" for a blank return as last part of formula Actual Results: See description for results Expected Results: Should be a blank return if the input value is 0 Reproducible: Always User Profile Reset: No Additional Info: cdeefe4 Version 7.5.9.2, tag libreoffice-7.5.9.2 by Xisco Fauli ยท
This bug has been in the last several releases.
Not repro (and most probably NAB/INVALID). Rather than a bug report, this seems an issue to be posted at <https://ask.libreoffice.org>. At any rate, they will probably need you to attach the spreadsheet file, to be publicly available.
On pc Debian x86-64, I don't reproduce this with LO Debian package 7.6.4.1. Do you reproduce this on a brand new ods file and after having applied https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile ?