2011/12/3 David S. Crampton <david_cramp...@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+h...@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+h...@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