Issue 23806 - when i import date column into OpenOffice I get only half the columns coverted to date.
Summary: when i import date column into OpenOffice I get only half the columns coverte...
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC5
Hardware: Other Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-12-22 19:04 UTC by kentlewan
Modified: 2004-03-03 12:10 UTC (History)
1 user (show)

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

Attachments
i used ScreenCapture to illustrate the problem in 2 .gifs (65.48 KB, application/octet-stream)
2003-12-22 19:11 UTC, kentlewan 		no flags Details
csv file for loading into OOffice to generate the bug (797.53 KB, application/vnd.sun.xml.writer)
2004-01-12 11:17 UTC, kentlewan 		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 kentlewan 2003-12-22 19:04:44 UTC 
- I create an ascii .csv file with about 11,000 rows using SAS System
- next I try to import the .csv using OpenOffice Calc
- I assign the type "Date" to the column I want to sort by (SAS format 21Dec03)
- When I load the file, the spreadsheet contains only about 50% of the columns 
formatted into proper dates.
- when I do the same using M$ it works.
Comment 1 kentlewan 2003-12-22 19:11:50 UTC 
Created attachment 12075 [details]
i used ScreenCapture to illustrate the problem in 2 .gifs
Comment 2 frank 2004-01-08 16:34:32 UTC 
Hi,

without a bugdoc showing this behaviour I can't do anything to confirm it.
Please attach a document that shows your problem on opening it. This will save
us a long time.

Thanks

Frank
Comment 3 kentlewan 2004-01-09 10:43:19 UTC 
Frank,

I already attached two .gifs showing the behavior on opening / loading the 
spreadsheet in OO Calc.  Please download the attached .zip, look at both .gif 
files and then tell me if this helps.

Kent
Comment 4 frank 2004-01-09 11:38:00 UTC 
Hi Kent,

I've had a look on your GIF's but this is not enough. I need a document,
otherwise I had not asked for one. ;-)

Frank
Comment 5 kentlewan 2004-01-12 11:17:44 UTC 
Created attachment 12434 [details]
csv file for loading into OOffice to generate the bug
Comment 6 kentlewan 2004-01-12 11:20:34 UTC 
I did the following steps to generate the error:
- load the attached .csv file as type "Text/CSV"
- formatted the columns TEXT except the Dates, which I formatted STANDARD
- when the doc loads the .csv, then Date column contains a mixture of text 
("01DEC2003") and date formats ("1.12.03"), which cannot be correctly sorted.
Comment 7 frank 2004-01-12 13:52:48 UTC 
Hi Kent,

the problem seems to be the locale setting. If I open the document with the
parameters you described and und Tools options langugage settings german is
selected, I get the described behaviour. If I choose English US as language, all
goes in smooth.

This is the case because OCT is the short form for October in english but in
german it is OKT. You see it's just how the language setting is choosen. As
workaround just select US English for the date column. After import you have to
set the date column to the correct date format when. Or you set the language
under tools options Language settings to English US, import the file and switchh
the language setting back.

I'm sorry, but there is no better way to achieve what you want.

Frank
Comment 8 frank 2004-03-03 12:10:35 UTC 
closed wfm