Franz Waldmüller wrote:
Andreas Saeger schrieb:
Franz Waldmüller wrote:
I am looking for an extension macro which enables me to save a
certain (selected) cell range of a sheet to a csv file.
If I am right I remember using a macro or extension before. I am work
on a fresh ubuntu 9.10 install and spend a lot of time with the usual
search engines.
Maybe somebody of you has the name or a hyperlink ready for me.
I appreciate your help!
Franz
Why not using the application as is?
Ctrl+C
Ctrl+N
Ctrl+Shift+V (or Insert Key)
[X] Text
[X] Values
[X] Dates
[ ] Formulas (off)
Enter (dialog settings are saved for the session)
A file picker is needed anyway:
Ctrl+S
File Type: csv
Hi Andreas!
Thank you for your suggestion. Another way is to put all values in a
seperate sheet (=$sheet1.A1 and so on ) which can be exported to csv
with the Save As Dialog. This way I just have to reexport the sheet if I
have to correct some values.
No! Don't do this.
When you have some document, say "MyDatabase.ods", and you save any part
of it as report.csv. The document points to that plain text file.
Now you continue working in the document, edit this sheet, save, edit
that sheet, save and close the program ending up with the unmodified
"MyDatabase.ods" and "that sheet" in report.csv (the last active sheet
when saving).
The spreadsheet contains already a lot of sheets and I thought there was
a macro which enables me to save a cell range to csv. Just like the
Calc2LateX extension does.
I am about to finish my masters thesis and I have to save my data to a
lot of small csv files for further processing with gnuplot and the
datatool-latex package.
If it has to be a spreadsheet as storage (which I doubt), Gnuplot can
read from Gnumeric spreadsheets. I believe it can even read filtered
sets of data, so you don't need to split your lists.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
