To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104913 Issue #|104913 Summary|Faulty formatting during import of CSV file Component|Spreadsheet Version|OOo 3.1.1 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|formatting Assigned to|spreadsheet Reported by|prowlerdk
------- Additional comments from [email protected] Wed Sep 9 09:11:18 +0000 2009 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
