At 15:34 12/09/2007 -0400, Jerry Feldman wrote:
While generating a CSV, Calc generates some quotes where (I believe)
Excel does not.
A short example is this is part of the input file, in this case a csv:
Input CSV:
Schedule Curve,ID,Name,
Result CSV:
"Schedule Curve","ID","Name",
The problem is that the tool that reads this is picky and does not
like the quotes. But, the resultant file does require some editing
because neither Excel nor Calc generates the dates in the needed
format: yyyy/mm/dd. Swedish comes close with yyyy-mm-dd, but again
the tool likes the forward slashes.
There is an alternative CSV format containing neither quotes nor
commas. To use this, tick the "Edit filter settings" box on the Save
As dialogue box if you have already saved the file as CSV, and then
tick "Fixed column width" on the "Export of text files" screen. If
you want the commas back, you could insert these as data from an
additional spreadsheet column.
The formatting part is easy. Before saving the data as a CSV file,
format the cells containing the dates as you wish them to appear. To
do that, select the cells, columns, rows, or block containing the
dates, and go to Format | Cells... | Numbers. In the "Format code"
box, enter YYYY/MM/DD.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
