Issue 6794 - Text CSV import doesn't work with dates in September
Summary: Text CSV import doesn't work with dates in September
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords: oooqa
: 8942 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-08-06 15:48 UTC by Unknown
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Test case for issue 6794 (257 bytes, text/plain)
2002-08-06 20:35 UTC, Unknown 		no flags Details
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 Unknown 2002-08-06 15:48:11 UTC 
When attempting to open fixed-width text files using "Text CSV" where dates are
of the form "DD-MON-YYYY", all dates import correctly except those where MON is
"SEP" (very weird). Date columns were defined in the "Fields" section of the
"Import" dialog as "Date (DMY)".
Comment 1 frank 2002-08-06 16:42:03 UTC 
Hi Steve,

please attach such a file using the 'Create new attachment' Link above. 

Thanks for your cooperation.

Frank
Comment 2 Unknown 2002-08-06 20:35:57 UTC 
Created attachment 2446 [details]
Test case for issue 6794
Comment 3 frank 2002-08-07 09:41:59 UTC 
I take it
Comment 4 frank 2002-08-07 11:14:40 UTC 
Hi Steve,

this is that the english default short letter code for September is
SEPT and not SEP. So the numberformat recognizes all other 3 Letter
codes as Months correctly but do not know the SEP and assumes this is
text.

Hi Eike,

as discussed this one is for you.

Frank
Comment 5 Unknown 2002-08-07 15:17:05 UTC 
Generally, though, when you generate dates in a fixed-width text from
a database like Oracle or PostgreSQL using a date format string
"DD-MON-YYYY" you end up with the 3-character month for all cases. It
was just such a file, generated from an Oracle database, that alerted
me to the problem.

I would suggest that it may be best to take the approach adopted by
PostgreSQL and support both "Sept" and "Sep" for September.

Steve.
Comment 6 frank 2002-08-07 15:30:54 UTC 
Hi Steve,

thats exactly what Eike and I have discussed ;-)) . As Eike has to
implement it, the Issue isassigned to him.

Have fun

Frank
Comment 7 ooo 2002-08-07 17:43:11 UTC 
fixed in:
SRC641:
svtools/source/numbers/zforfind.cxx 
1.22.2.2
sc/source/ui/docshell/impex.cxx 
1.18.8.1
SRX643:
svtools/source/numbers/zforfind.cxx 
1.24
sc/source/ui/docshell/impex.cxx 1.20
Comment 8 prgmgr 2002-11-21 00:39:06 UTC 
*** Issue 8942 has been marked as a duplicate of this issue. ***
Comment 9 ooo 2002-12-09 16:28:33 UTC 
pending, join to OOO_STABLE_1 branch
Comment 10 ooo 2003-02-05 13:34:59 UTC 
reopen to reassign
Comment 11 ooo 2003-02-05 13:35:54 UTC 
reassign to QA
Comment 12 ooo 2003-02-05 13:36:13 UTC 
restore status
Comment 13 frank 2003-02-05 14:14:56 UTC 
Closed as I've verified it in OOo1.0.2

Frank