<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Formula to Value renders a blank non-empty cell" href="https://bugs.documentfoundation.org/show_bug.cgi?id=144986#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Formula to Value renders a blank non-empty cell" href="https://bugs.documentfoundation.org/show_bug.cgi?id=144986">bug 144986</a> from <a class="email" href="mailto:iavs.leroy@gmail.com" title="LeroyG <iavs.leroy@gmail.com>"> LeroyG</a> <pre>Thanks Miguel and Eike. After reading comments 1 to 3, I agree that this type(?) of content "should be searchable" (<a href="show_bug.cgi?id=144986#c2">comment 2</a>). 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>