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.
----- -- 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