Issue 23252 - time format incorrect in csv files exported from calc
Summary: time format incorrect in csv files exported from calc
Status: CLOSED DUPLICATE of issue 4925
Alias: None
Product: Internationalization
Classification: Code
Component: BiDi (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@l10n
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2003-12-07 03:25 UTC by jpbonn
Modified: 2004-04-30 20:55 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jpbonn 2003-12-07 03:25:09 UTC 
I'm trying to export a spreadsheet into csv format but columns
containing a time are not exporting correctly.  I have the time column
in HH:MM:SS format, my system regional settings (WinXP) are set to
english(USA) and time format set to HH:mm:ss, in OO Calc I've set
tools-options-Language settings to English (USA).  The time column
displays correctly in Calc and saves and loads correctly if I use the OO
Spreadsheet format.  If I try to save the spreadsheet as csv the time
column saves in a "HH:MM:SS AM/PM" format, in spite of having everthing
set to HH:MM:SS format.

Note that if I set the language (in the OO Calc format cells) to English(Eire)
that the csv export works correctly and saves in the HH:MM:SS format.
Comment 1 sforbes 2003-12-08 10:09:07 UTC 
* can you please upload an example file?
* This sounds like it might be related to Issue #15945.

FT: do you think this might be a dup?
Comment 2 jpbonn 2003-12-08 19:04:09 UTC 
This doesn't look like Issue #15945 to me.  This only seems to bea problem with
csv format when it's exported and I'm not using different character sets.  If I
save in Excel or OO format everthing works fine.  

Here's a sample file.  Save it as sample.csv.  imp[ort it into OO, set the time
column to HH:MM:SS format English (USA) (in addition to the system settings, and
OO settings as described previously) and do "save as .csv".  it will save in
"HH:MM:SS AM/PM" format.  Now change the format to "HH:MM:SS" English (Eire) and
do "save as .csv" and it will save in "HH:MM:SS" format as described above.

date,time,jultime,Mopen,high,low
12/12/2002,10:41:05,641,852.7,853.6,849.7,849.7
12/12/2002,10:50:28,650,849.5,850,847,847
12/12/2002,10:59:42,659,846.9,848,844.4,844.4
12/12/2002,12:01:20,721,844.2,847,842.4,847
12/12/2002,12:40:44,760,846.9,849.7,845.4,849.7
12/12/2002,12:46:11,766,849.5,849.5,847,847
12/12/2002,13:00:19,780,846.9,847,844.4,844.4
12/12/2002,13:23:14,803,844.7,847,844.2,847
Comment 3 Dieter.Loeschky 2004-01-29 16:56:13 UTC 
DL->OC: Could you please handle this?
Comment 4 Joost Andrae 2004-02-25 20:32:07 UTC 
JA->OC: ER should have a look at this
Comment 5 frank 2004-04-30 12:00:40 UTC 
Hi,

this one is a double to Issue 4925.

So I've set the flags.

Frank

*** This issue has been marked as a duplicate of 4925 ***
Comment 6 frank 2004-04-30 12:01:03 UTC 
closed double
Comment 7 jpbonn 2004-04-30 20:55:47 UTC 
I don't believe this is related to Issue 4925.  Everything works fine if you use
a locale English (Eire) instead of English (USA). That would imply that there is
code to handle this but it's just not working correctly for English (USA).  Read
the comments of December 8, 2003