In OpenOffice.org and LibreOffice 3.3 if you used =SUM() to find the total of the numeric values in a row or column where some of the cells were blank or just text, then it worked! Now I've just opened a spreadsheet with LibreOffice 3.4 and #VALUE! is appearing everywhere.
Why the change? It brings back awful memories of the OpenOffice.org upgrade from 1.1.3 to 2.0.0 -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3022764.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
