CSV exporting is still very important. XML is still not common enough and 
standardized enough to completely replace CSV.

Using a text delimiter seems to result in all fields enclosed with quotes- 
text, number or whatever. Data types of cells get ignored. The quotes will fool 
a lot of other software into importing everything as text, bypassing any 
automatic conversions they might do. Sometimes even preventing conversion.

Currency amounts are not numbers. They should always be exported with the 
currency symbol. This is not an option in OO spreadsheet. In a column of money 
amounts there may be several currencies, all of which must be differentiated. 
It probably should not be exported with text quotes because it is not really 
text and could be incorrectly recognized as simple text. A future feature might 
be to support a conversion rate table (or XML website), and a convert/create 
column command which converts amounts and replaces currency symbols.

There are many CSV export options offered by OO spreadsheet, but no combination 
could duplicate the default CSV export (with no options) that MS Excel offers. 
It's one reason I still am saddled with Excel.

Description of Excel export-
CSV (Comma delimited) format
The CSV (Comma delimited) file format saves only the text and values as they 
are displayed in cells of the active worksheet. All rows and all characters in 
each cell are saved. Columns of data are separated by commas, and each row of 
data ends in a carriage return. ___If a cell contains a comma, the cell 
contents are enclosed in double quotation marks___.

If cells display formulas instead of formula values, the formulas are converted 
as text. All formatting, graphics, objects, and other worksheet contents are 
lost.

Note   If your workbook contains special font characters such as a copyright 
symbol (©), and you will be using the converted text file on a computer with a 
different operating system, save the workbook in the text file format 
appropriate for that system. For example, if you are using Windows and want to 
use the text file on a Macintosh computer, save the file in the CSV (Macintosh) 
format. If you are using a Macintosh computer and want to use the text file on 
a system running Windows or Windows NT, save the file in the CSV (Windows) 
format.