libreofffice --headless --convert-to ods file.sxc generates a file with extension .ods which is actually a flat XML file and should therefore have file extension .fods . See (NOTABUG) bug report #89935 for consequences. Can it be fixed so that if one requests conversion to ods, one actually gets ods? The action of the above command would best be expressed as --convert-to fods, and if there is no appropriate filter for converting to ods, then the appropriate action of the above command would be an error message something like "No filter exists that can convert sxc to ods. You can, however, use --convert-to fods" In mitigation I do now realize the significance of the text output by the above command "using OpenDocument Spreadsheet Flat XML". But at the time the command seemed to have succeeded: I had a .ods file that opened OK Info request: is there a headless convert command that will turn a .fods file into a genuine .ods file so that I can reconvert about 3,000 files that may have been edited subsequent to conversion from .sxc?
Hello, I tested convert this command produce xml soffice --headless --convert-to ods /tmp/sxcFile.sxc convert /tmp/sxcFile.sxc -> /tmp/sxcFile.ods using OpenDocument Spreadsheet Flat XML If you want .ods you should use this: soffice --headless --convert-to ods:"calc8" /tmp/sxcFile.sxc convert /tmp/sxcFile.sxc -> /tmp/sxcFile.ods using calc8
(In reply to Nigel Arnot from comment #0) > > Info request: is there a headless convert command that will turn a .fods > file into a genuine .ods file so that I can reconvert about 3,000 files that > may have been edited subsequent to conversion from .sxc? try soffice --headless --convert-to ods:"calc8" *.ods I think we can close the bug? Correct command is> soffice --headless --convert-to ods:"calc8" /tmp/sxcFile.sxc
(In reply to raal from comment #1) > this command produce xml > soffice --headless --convert-to ods /tmp/sxcFile.sxc > convert /tmp/sxcFile.sxc -> /tmp/sxcFile.ods using OpenDocument Spreadsheet > Flat XML That's definitely not what I'd expect... > If you want .ods you should use this: > soffice --headless --convert-to ods:"calc8" /tmp/sxcFile.sxc > convert /tmp/sxcFile.sxc -> /tmp/sxcFile.ods using calc8 "calc8" ? That's esoteric, LibreOffice-only, technical language we're using there. I just searched on the TDF Wiki and the Help Wiki, and got zero hits for 'calc8': https://wiki.documentfoundation.org/index.php?search=calc8&title=Special%3ASearch&go=Go https://help.libreoffice.org/index.php?search=calc8&title=Special%3ASearch&go=Go I also checked info in latest 4.4.1.2 regarding the --convert-to switch: --convert-to output_file_extension[:output_filter_name[:output_filter_options]] [--outdir output_dir] files I don't see any clear mention of where one can find the list of the output filter names/options. I strongly suggest that we clean up this interface so it's intuitive, doesn't refer to internal LO jargon, and is well documented. Perhaps UX can help here? Component -> ux-advise Status -> NEW See Also -> link to bug 89935
*** This bug has been marked as a duplicate of bug 78989 ***