command line convert to csv save cell content as shown [closed]

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

bgman gravatar image

updated 2020-08-27 15:25:37 +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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-27 15:25:54.846307