Hi :) I think those empty cells (that now contain - ) might be causing the error. If you delete the - in just 1 row does that fix the formula to display correctly? I think number cells can be formatted to show a - mark if empty but 3.4 might have got confused and thought those - were keyed in rather than being part of the formatting. It's a long time since i dealt with this sort of thing and that was in Excel so i could easily be utterly wrong. Regards from Tom :) ----- Original Message ----
From: prholland <ooo@hollandnumerics.com> To: users@libreoffice.org Sent: Sat, 4 June, 2011 14:26:56 Subject: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4? The following screenshot is taken from a spreadsheet that previously showed "00:00" in LibreOffice 3.3.2, where LibreOffice 3.4.0 is now showing "#VALUE!" (NB: all the cells are formatted as Time values, and the "text" cells contain "-"): http://nabble.documentfoundation.org/file/n3023141/%23VALUE-screenshot.png -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3023141.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+help@libreoffice.org In case of problems unsubscribing, write to postmaster@documentfoundation.org 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
-- Unsubscribe instructions: E-mail to users+help@libreoffice.org In case of problems unsubscribing, write to postmaster@documentfoundation.org 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