https://bugs.documentfoundation.org/show_bug.cgi?id=95468
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |miguelangelrv@libreoffice.o
| |rg
Resolution|--- |NOTABUG
--- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> ---
Hi @Havo,
a cell with a formula is never empty, it has an empty string, but cell is not
empty.
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.
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.
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.
"
I think we can resolve as notabug, please if you are not agree, reopen it.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
