Issue 6132 - Wrong date-format when importing from SDV-files
Summary: Wrong date-format when importing from SDV-files
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: PC Windows NT
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
: 5842 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-06-26 11:38 UTC by sleipner
Modified: 2013-08-07 15:14 UTC (History)
1 user (show)

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

Attachments
comma-separated data file (2.33 KB, text/plain)
2002-06-26 12:54 UTC, sleipner 		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 sleipner 2002-06-26 11:38:18 UTC 
OpenOffice assumes US-date format (mm/dd/yy) when importing data from SDV-formatted files, 
even if the local language has other preferences.
Comment 1 daniel.rentz 2002-06-26 12:22:30 UTC 
Please explain "SDV" and give a little example.
Comment 2 sleipner 2002-06-26 12:54:51 UTC 
Created attachment 2084 [details]
comma-separated data file
Comment 3 sleipner 2002-06-26 12:57:29 UTC 
I think OpenOffice does not accept dates it thinks are not possible according to the 
US-date format.

DATEVALUE("07/20/54") --> 19925
DATEVALUE("20.07.54") --> 
Err:502

When importing the attached file, dates that could be possible in the US-
format are shown right aligned, dates not possible are shown left aligned.
Comment 4 sleipner 2002-07-01 11:31:11 UTC 
*** Issue 5842 has been marked as a duplicate of this issue. ***
Comment 5 daniel.rentz 2002-07-10 14:52:36 UTC 
I have tried it with an English OOo and german system settings
(Windows) and it works as expected. After setting TABs as delimiters,
the 3 columns in the front all contain date values.

Please check your settings in Tools|Options|Languages|LocaleSetting.
Is it German -or- is it Default and your system is German?

Just found another problem: Preview can't handle with TAB characters.
Comment 6 daniel.rentz 2002-07-31 09:03:18 UTC 
I take it for the TAB chars problem.
Comment 7 daniel.rentz 2002-07-31 09:03:35 UTC 
Problem with TAB characters fixed in next 643 build.
Comment 8 sleipner 2002-09-26 17:44:22 UTC 
See issue 7905
Comment 9 daniel.rentz 2002-10-14 14:33:28 UTC 
TAB handling correct in OOo643
Comment 10 daniel.rentz 2003-01-13 16:55:38 UTC 
fixed, target->OOo1.1beta
Comment 11 daniel.rentz 2003-03-26 09:43:45 UTC 
checked in ooo644m7
Comment 12 stx123 2003-04-02 11:37:18 UTC 
new/fixed is a unusual state...
Comment 13 peter.junge 2003-04-02 11:52:24 UTC 
> new/fixed is a unusual state...

I disagree. This issue has recently been fixed in the development and
goes back to QA for verification. AFAIK it's not possible to change
the owner under RESOLVED/FIXED conditions.

Peter
Comment 14 oc 2003-04-28 13:53:09 UTC 
Fixed and verified in OOo644m7
Comment 15 oc 2003-04-28 13:53:35 UTC 
Closed because fixed