2011/12/3 David S. Crampton <david_crampton@ie2b.com>:
I agree with Pedro. A null text is not to be treated as a numeric zero. An empty cell may be calculated as a zero but a null text is not an empty cell. If have found the #VALUE result of mixing null text within a calculation to be a good debugging and alert technique that the values elsewhere in my spreadsheet have become messed up.
I could agree with that, but it would have been nice if they thought of that since 1.0 and not changing it on the way, breaking a whole lot of spreadsheets… Let's assume we have this example: A2: =IF(A1=6;"";B1) Now, in some cases, A2 will be an empty string, so =A2+1 will fail in another cell, right? Is there another way to make A2 look empty in this case, making it useable for calculations? Something like the following: =IF(A1=6;SomethingNiceToPutHere;B1) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ
----- -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557547.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted