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 18.104.22.168 in Ubuntu 15.04, python 2.7.9.
Many thanks to any and all!!