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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Oct 8 16:50:55 UTC 2021


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

--- Comment #4 from LeroyG <iavs.leroy at gmail.com> ---
Thanks Miguel and Eike.

After reading comments 1 to 3, I agree that this type(?) of content "should be
searchable" (comment 2).

So, what is next? Change the bug title to reflect that? Close this bug and post
an enhancement request for the search issue?

After apply Formula to Value in A1: ="" 

=ISBLANK(A1) gives FALSE.
=ISFORMULA(A1) gives FALSE.
=ISLOGICAL(A1) gives FALSE.
=ISNONTEXT(A1) gives FALSE.
=ISNUMBER(A1) gives FALSE.

=ISTEXT(A1) gives TRUE.

-- 
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/b7a1a301/attachment.htm>


More information about the Libreoffice-bugs mailing list