https://bugs.documentfoundation.org/show_bug.cgi?id=130458
b. <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
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. <[email protected]> ---
(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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
