https://bugs.documentfoundation.org/show_bug.cgi?id=95468
--- Comment #2 from Hayo Baan <[email protected]> --- (In reply to m.a.riosv from comment #1) > Hi @Havo, > a cell with a formula is never empty, it has an empty string, but cell is > not empty. True, but I knew of no other way of creating an empty value when using a formula than by using the empty string. > LibreOffice have became more restrictive about how strings are treated in > calculations. I think only direct references with no dubious conversion in > number are treated as such. I understand why LibreOffice has become more strict, and in general this is a good idea. It just bit me a bit hard in this case. And you're right, LibreOffice still does treat the completely empty cell as zero (Heck, even a cell with a simple formula like =A6 where cell A6 is empty is displayed as 0). > In the last versions there is an option on how treat an empty string for > calculations. > > Menu/Tools/Options/LibreOffice calc/Formulas/Detailed calculation settings - > Treat empty string as zero. Awesome! This fully solves my issue. I did check all the available options, but hadn't looked under the “Details…” (doh!) > You can also involve the reference with N() function. > " > Returns the numeric value of the given parameter. Returns 0 if parameter is > text or FALSE. > If an error occurs the function returns the error value. > " Nice! I didn't know this function yet and will use it in the future (so I can use the more strict calculation rules) > I think we can resolve as notabug, please if you are not agree, reopen it. Fully agree, sorry to have bothered you! Your response, and the way LibreOffice is heading in its development, has further convinced me to fully migrate to LibreOffice though, so it wasn't in total vain ;-) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
