Hi Rik,

On 02/05/11 13:48, rdb wrote:
Strange, I did exactly what you said and still have the same problem. All
fields are formatted as time HH:mm. Both with the standard formula
(=Cell1-Cell2) and using the TIME function (=TIME(0,0,0)-TIME(2,0,0) I get
22:00:00 as my output.


Than go back one step. What OS, LO and Java are you using. Sometimes these things can be version specific or because you are using a different version of java.

I am using...

LibreOffice 3.3.2 OOO330m19 (Build:202)
tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu2~lucid1

On Ubuntu 10.04 LTS

Java JRE Sun Microsystems 1.6.0_20 (although I tested 1.6.0_24 and it worked the same).

Are you using the OpenJDK libraries? this is what LO defaults to I think. I changed because I was finding some unusual problems poped up after moving from OO, which went away when moving back to the SunMicrosystems Java Version.

--
Cheers Simon

   Simon Cropper
   Principal Consultant
   Botanicus Australia Pty Ltd
   PO Box 160, Sunshine, VIC
   W: www.botanicusaustralia.com.au

--
Unsubscribe instructions: E-mail 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

Reply via email to