https://bugs.documentfoundation.org/show_bug.cgi?id=130458
b. <newbie...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |newbie...@gmx.de
OS|Linux (All) |All
Status|NEEDINFO |RESOLVED
Resolution|--- |NOTABUG
Summary|Cannot evaluate an cell |Cannot evaluate a cell with
|with an empty result from a |an empty result from a
|formula |!string / text! formula,
| |result: #VALUE!
--- Comment #4 from b. <newbie...@gmx.de> ---
(In reply to m.a.riosv from comment #2)
> Please test it the option in Menu/Tools/Options/LibreOffice calc/Formula -
> Detailed calculation settings - Treat empty string as zero, solve your issue.
issue and solution confirmed, without this option an empty result of a string
operation in B2 produces #VALUE! in B3, with the option checked the result is
'0',
as well in 6.1.6.3 (winx64) as in actual 7.1.0.0 dev (winx64),
thus 'notabug'
the option is in [tools - options - libreoffice calc - formula - detailed
calculation settings - **custom (conversion of text to numbers and more):
details** - treat empty string as zero]
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
