Apache OpenOffice (AOO) Bugzilla – Issue 18458
CSV files should use "Text" cell types by default.
Last modified: 2003-09-08 16:55:29 UTC
Unless you specify "Text" as the cell type for all cells of a CSV, the contents are imported unpredictably. Fractions are sometimes converted to dates. Also, saving a CSV file shouldn't make you view two different warnings just to save the same file you just opened. Since you opened a CSV file, it should assume that you actually WANT to save it as a CSV file again.
Hi, first of all, just one description per Issue. Point 1: this is not what most users want. The import of CSV files should make numbers as numbers not text. If you have some formatting Issues, just select the correct format in the CSV Dialog. Point 2: If you want to save your documents as CSV by default, just select it under tools options load/save as default format. These dialogs have saved me a lot of time and I assume it's the same for a lot of other people all over the world. As both of the points you mentioned are working as designed and a lot of people are happy with them I set this Issue as wontfix. Best regards Frank
closed wontfix
Gillissie, I disagree. CSV means comma separated *values*. The main intention of this file format is to transport numerical data. If you work on a system with period as date separator and comma as decimal separator, the filter may convert text like 10.12 to a date. This does not happen always, as for instance 13.14 is not a valid date. Therefore the latter becomes text then. I think this let you feel that the filter works unpredictably :-) To import these values, set the column type to US-English. This forces the filter to use periods as decimal separator, and not the separator of the current locale settings of your system.