https://bugs.documentfoundation.org/show_bug.cgi?id=144986
--- Comment #11 from Olivier Hallot <[email protected]> --- (1) https://help.libreoffice.org/master/en-US/text/scalc/01/04060110.html?DbPAR=CALC (2) https://help.libreoffice.org/master/en-US/text/shared/01/02100001.html?&DbPAR=CALC Proposed text in (1) Empty string and blank cells ---------------------------- Cells with the empty string ("") are not equivalent to blank cells. When searching or calculating with text, the empty string "" is the text with length zero. For example, when the formula in A1 returns the empty string "", then the following applies: =ISBLANK(A1) returns FALSE. The cell is not blank. =ISFORMULA(A1) returns TRUE. The cell has a formula. =ISLOGICAL(A1) returns FALSE. Not a logical value =ISNONTEXT(A1) returns FALSE. The cell has the empty string =ISNUMBER(A1) returns FALSE. Not a number. =ISTEXT(A1) returns TRUE. The cell has the empty string =LEN(A1) returns 0. The length of the empty string is zero. Proposed text in (2) (for Calc only) Note: Cells with the empty string ("") are not equivalent to blank cells. When searching or calculating with text, the empty string "" is the text with length zero. -- You are receiving this mail because: You are the assignee for the bug.
