Created attachment 93386 [details] corresponding csv file When opening attached csv file and saving it into xlsx format, conversion works correctly !!! However, when using a php script $lCmd = '/opt/libreoffice4.1/program/scalc --headless --convert-to xls ' . $this->csvSheet->fileName; $rtn = system($lCmd,&$rtnVal); the conversion fails with many errors. Help is appreciated.
Created attachment 93388 [details] Generated xls file
(In reply to comment #0) > Created attachment 93386 [details] > corresponding csv file > > When opening attached csv file and saving it into xlsx format, conversion > works correctly !!! > I'm not quite sure what you mean when sayin "correctly". Using the same platform and LibreO version, the file imports with some errors, using the default options in the import dialogue. Could you elaborate on the options you selected? What was the expected xlsx file? I any case , some options must be present in the command line, indicating to the headless instance what should it do with the CSV data (e.g. separator, quoting, etc. ). Those options exist, albeit hard to find... This is a non-trivial CSV i think, so you cannot expect the defaults to work out of the box. Version: 4.1.4.2 Build ID: 410m0(Build:2) OS: opensuse 64bit 12.2
The problem here is that the csv file has .txt extension that defaults to Writer, and you can't use Calc export filters for a Writer document. The solution is to give the file .csv extension. If you can't change the extension for some reason, you must specify both the input and output filters (and for master it's enough to just add --calc).