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. 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.

Thanks for your help!
Franz

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to