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 <[email protected]> > To: [email protected] > 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 [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 > > -- 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
