Dear developers,
Please add the CSV-format to the Export-Dialog as suggested in issue 32684.
http://www.openoffice.org/issues/show_bug.cgi?id=32684
After a long absence from the statistical horizon (I basically did not
have any scheduled work with advanced statistics over the last 2 years),
I began over the past 2-3 weeks to dwell again in statistics. There are
obvious reasons why I do all my work in R, so I need to export a lot of
csv-files.
Unfortunately, there is NO such option in Calc. You can only 'SAVE' as
csv, which is nonsense. As the csv is really an intermediary transport
file used to transfer *one sheet* of data from the spreadsheet to
another program, I strongly support adding the CSV-format to the
EXPORT-possibilities.
The csv can't support formatting nor formulas, BUT most importantly,
only the *active sheet* is exported, so it is really ONLY an export, NOT
a SAVE AS-functionality.
I therefore strongly suggest to add this option to the EXPORT-dialog.
This has some practical consequences, because it is impossible to
perform any sound statistics in Calc. At the same time, the ODF-format
has become too complex to implement accurate file-readers (that mimic
all its bugs and limitations) in professional statistic packages. It is
therefore imperative to use a simple format for data-transfer, and csv
is simply the best suited one (tab-delimited data is another one).
I therefore strongly hope that this enhancement gets implemented in Calc.
Basically, the export-dialog should have both PDF and CSV as options.
Selecting CSV should export the active sheet, using the sheet-name as
default name. The status of the ods-file should not change (i.e. do not
set changed status). That's it.
Sincerely,
Leonard
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
