You might consider first saving in OO format and THEN saving to CSV,
then closing the program. You'll then save all sheets in the OO file
and only the active sheet for the CSV. As you can imagine, it'd be
difficult to save multiple sheets as one CSV.
Paul wrote:
When saving as .csv there is a warning that is popped (if there are
multiple sheets) that only the current sheet was saved. This is normal
behaviour.... CSV format is a flat file format and therefore cannot
handle more than one sheet of data. M$ Excel does exactly the same
thing.
You cannot 'export' to cvs, but you can 'save as'...
/paul
On 12/5/05, Jacek <[EMAIL PROTECTED]> wrote:
Have you noticed that using option save as .csv file may cause a possible
data loss?
If you save to .csv format (which I have to do since most data analysis
programs don't work with .ods format, but all of them can import .csv). Only
the current sheet is saved (and you may have more than one sheet in one
file), but the OO allows you to work on not-saved sheets. If you close OO
then, and choose save changes in the dialog, only one of the sheets is
saved. (and the rest of them is lost)
Moreover there is no option like export to .csv (which would be
appropriate).
Have any of you encountered such problems?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
