Issue 104913 - Faulty formatting during import of CSV file
Summary: Faulty formatting during import of CSV file
Status: CLOSED DUPLICATE of issue 87999
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.1.1
Hardware: Mac Mac OS X, all
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2009-09-09 10:11 UTC by prowlerdk
Modified: 2009-09-10 18:45 UTC (History)
2 users (show)

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

Show cell format before and after import. (307.97 KB, image/jpeg)
2009-09-09 10:19 UTC, prowlerdk
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description prowlerdk 2009-09-09 10:11:18 UTC
Upon importing a CSV file from the Magento webshop system, some cells is
altering formatting. The cells in question is changing from "numbers" to "date".
See link:

It seemes that certain prices (figures/ciffer) is causing the cell formatting to
change. I tried to enter the same price i the above cell and the exact same
thing happended. When putting 8.0000 in the formula bar (cell formatted as
number) it changes to DATE.

I could do a screencast if needed to clarify.

This issue is vital (to me) since calc is the only app.(to my knowledge) that
can handle utf-8 csv file.
Comment 1 prowlerdk 2009-09-09 10:19:12 UTC
Created attachment 64638 [details]
Show cell format before and after import.
Comment 2 Regina Henschel 2009-09-10 18:44:48 UTC
You can determine for each column, which format it should use in the import
dialog. If the data has decimal numbers, which use a dot as decimal delimiter,
then you have to set the format to "US English". Click on the column header,
then the drop down list 'Column type' is active.

The problem, that the number recognition does not handle it correct for format
"standard" is already tracked in issue 87999.

*** This issue has been marked as a duplicate of 87999 ***
Comment 3 Regina Henschel 2009-09-10 18:45:16 UTC
closing duplicate