First at all sorry for my bad english, obvious it is not my home language :-))
Thank you for advice, but I am using Croatian settings as default on XP, and in general view or in specific custom definied formats everything is fine. Problem is when I try to save calc files as text or csv, to import in MySql or any other program. Date and time formats are not correct as I define and seen in calc (24 hours or dd/mm/yyyy), but as calc calculate (12 hours format; and mm/dd/yyyy format). If you want to test, just try to do reformat in Calc, save in txt file and open txt with some external text editor. I hope you will see problem. Zeljko -----Original Message----- From: Joost Andrae [mailto:[EMAIL PROTECTED] Sent: Friday, February 25, 2005 2:36 PM To: [email protected] Subject: Re: [qa-dev] Export time as 24 hours format from spreadsheet in txt or csv Hello Željko, Calc uses the locale settings for these formats. You could overrule these settings by changing the locale settings within the application in "/tools/options/language settings/languages". Example: If I use a system locale like en_US.UTF-8 then the numberformat for a time value is used with 12 hour representation If I change the locale setting within the application to eg. German then the representation of the number format changes to 24 hours. Kind regards, Joost --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
