[Libreoffice-bugs] [Bug 144986] Formula to Value renders a blank non-empty cell

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144986

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
Strictly spoken the behaviour is correct, but the result of an empty text
content should be searchable (it might not be because such can't be entered via
UI). If an empty string was replaced with a blank cell, semantics would change
like

 A1: `=""`
 A2: `=A1+2`
 => `#VALUE!` (if strict text conversion is enabled)

With A1 being empty the result would change to 2.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20211008/a5d68292/attachment.htm>