exporting calc as csv but keeping ods form

users
#1

I have an application that takes input formatted as csv. my source form is calc sheet with computed cells. if I save as csv, I need to re open the sheet's ods file when I make changes. is there any way to export as csv but keep the original ods in calc?? macro? bit o'python?

--- thanks

#2

Not that I know of. As you suggest, what you need is an Export As CSV function rather than the existing Save As CSV function.

But there may be a workaround:
o Have both .ods and .csv files open simultaneously in Calc.
o Instead of using Save As from the .ods file, copy the relevant material (it cannot be more than part of a single sheet) from the .ods file and paste it into the .csv file.
o Save the .csv file - or Save As if you need a new file name.
o Swap back to the .ods file (Alt+Tab?) to continue working.

I trust this helps.

Brian Barker

#3

Eric ,

find the code below, you must do some googling to fin the

makePropertyValue function made by Danny Brerwer

hope it helps

Fernand

I have an application that takes input formatted as csv. my source form is calc sheet with computed cells. if I save as csv, I need to re open the sheet's ods file when I make changes. is there any way to export as csv but keep the original ods in calc?? macro? bit o'python?

# Now save it in CSV format.
     cURL= convertToURL( cFile +".csv" ) oDoc.storeToURL( cURL, Array( makePropertyValue( "FilterName", "Text - txt - csv (StarCalc)" ) ) )

#4

Doesn't the File->Save a copy... do the job?

#5

Hi :slight_smile:
+1

I couldn't see the complexity in the question that would prevent doing
something like just saving the document in ODF and then re-saving in
whatever other formats are required.

Does anyone happen to know if there is an Extension that allows a document
to be simultaneously saved in an MS proprietary format and ODF at the same
time with a single click? I might have dreamt it or imagined it or
something. Even if there is i doubt it'd help with saving in Csv, unless
it happens to be OpenSource and happens to be easy to adapt.
Regards from
Tom :slight_smile:

#6

Have you tried the Multi-Save extension?

jonathon