Apache OpenOffice (AOO) Bugzilla – Issue 104913
Faulty formatting during import of CSV file
Last modified: 2009-09-10 18:45:16 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: http://picasaweb.google.com/ProwlerDK/MagentoCSV?feat=directlink 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.
Created attachment 64638 [details] Show cell format before and after import.
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 ***
closing duplicate