Issue 67813 - oocalc corrupts csv import
Summary: oocalc corrupts csv import
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.3
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-07-26 21:43 UTC by nodata
Modified: 2006-07-27 11:51 UTC (History)
1 user (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 nodata 2006-07-26 21:43:13 UTC 
If I import a csv file containing the a number such as "1.5", oocal changes it
to the date "01.05.2006". This is annoying since it is not a date, and the
preview shows it correctly.

This is easy to miss in a big spreadsheet too.
Comment 1 Joost Andrae 2006-07-27 10:47:55 UTC 
Within the TXT/CSV import dialog you can define the number format for each
column (just right click onto the column header of each column that you want to
modify and select "US English" format). As I expect your system locale uses a
comma as decimal separator the behavior to format that "number" as a date is
intended to be like that.

Resolving this issue as WORKSFORME
Comment 2 Joost Andrae 2006-07-27 10:48:08 UTC 
closing
Comment 3 nodata 2006-07-27 11:51:33 UTC 
The preview is wrong.