Issue 31326 - CSAV import in Spreadsheet date field incorrect in some cells
Summary: CSAV import in Spreadsheet date field incorrect in some cells
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.2
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-07-09 21:37 UTC by rvto
Modified: 2004-07-12 11:11 UTC (History)
1 user (show)

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

Attachments
orginal csv file (4.16 KB, text/txt)
2004-07-09 21:40 UTC, rvto 		no flags Details
File with txt of csv file and spreadsheet output (11.85 KB, application/vnd.sun.xml.writer)
2004-07-09 21:43 UTC, rvto 		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 rvto 2004-07-09 21:37:58 UTC 
Importing a .csv file in spreadsheet with date column, in d/m/y format gives not
all the same format in one column . Changing the format of the cels not change
the  format.
Comment 1 rvto 2004-07-09 21:40:52 UTC 
Created attachment 16369 [details]
orginal csv file
Comment 2 rvto 2004-07-09 21:43:07 UTC 
Created attachment 16370 [details]
File with txt of csv file and spreadsheet output
Comment 3 frank 2004-07-12 11:11:34 UTC 
Hi,

this is not a bug.

The only problem I could see is the one in the column snelheid. This is because
the decimal separator used in the csv file is a dot. This is true if I'm using
netherlands locale settings.

If I use en_US locales, the problem may be the date column. 

Both problems can be solved by using the proper import settings. select them by
clicking on the column headers in the import dialog. US English for the snelheid
and the proper date setting for the date column.

Frank
Comment 4 frank 2004-07-12 11:11:56 UTC 
closed worksforme