On Wed, 12 Sep 2007 22:15:58 +0100 Brian Barker <[EMAIL PROTECTED]> wrote:
> 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. I'll check this out. -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix user group http://www.blu.org PGP key id:C5061EA9 PGP Key fingerprint:053C 73EC 3AC1 5C44 3E14 9245 FB00 3ED5 C506 1EA9
signature.asc
Description: PGP signature