Hi Graham, On Thu, Aug 04, 2005 at 20:09:28 +0100, Graham wrote:
> OO 1.9.113 Win XP. In Spreadsheet when I import a .csv the preview looks > fine but times - e.g. 8.00pm, 10.45am - are translated as 00:00.00 or > 45:00.00. Not what I had in mind... If 8.00pm, 10.45am are literally the content of the CSV file they don't represent valid time strings, using a dot '.' as separator, or, putting it the other way around, there is only one locale that uses the dot, Italian_Italy, but that doesn't use am/pm. In the import dialog set the column type to Text instead. The conversion to some time value that takes the minute part as hours is a bug, please file an issue. Eike P.S.: As you're not subscribed to the mailing list you were posting to, you will miss replies that are directed to the list only. When answering, please reply only to the list (Reply-To header is set), not to my personal account. Thanks. -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
