command line convert to csv save cell content as shown

asked 2015-11-17 20:57:15 +0200

bgman gravatar image

updated 2015-11-18 15:49:41 +0200

Alex Kemp gravatar image

When I save a calc file as csv using the File - Save As menu, I'm given an option to "Save cell content as shown" or I could "Save formulas". Is there a way to force the "Save cell content as shown" when performing the conversion from the command line?

The cells affected are those with a call to a libreoffice basic macro. Those cells only display #NAME? following the command line conversion. Following the File-Save As conversion, these cells all display the corrected calculated value.

My python code:

return_code = subprocess.call("soffice -env:UserInstallation=file:///tmp/tempprofile --headless --convert-to csv " + InputFile + " > null", shell=True)

I'm using LO 4.4.6.3 in Ubuntu 15.04, python 2.7.9.

Many thanks to any and all!!

edit retag flag offensive close merge delete