Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Hello prholland,

On Sat, 4 Jun 2011 06:26:56 -0700 (PDT) (your time) you said:

> 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 "-"):

Tom is correct, just tried it. If the cell is formatted as time, you get
'#VALUE!' as '-' isn't recognised as a time value. Taking the '-' out and
leaving the cells empty works.

I've worked with time sheets in 3.3.2 as well but then I never used a hyphen
to indicate 'no hours'. Maybe it was a 'fix' in this new version.

-- 
Si (PLO)
#32955. Ego Sow Whir Den? ¶

Auxiliary Information:
 • LibreOffice 3.4.0 OOO340m1 (Build:12)
 • Windows XP Pro 5.1.2600 Service Pack 3


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