Bug 89952

Summary:	FILTER libreoffice --convert-to ods actually converts to fods
Product:	LibreOffice	Reporter:	Nigel Arnot <nigel.arnot>
Component:	ux-advise	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	libreoffice-ux-advise, nigel.arnot, raal, robinson.libreoffice, vsfoote
Priority:	medium
Version:	4.3.6.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=89935
Whiteboard:
Crash report or crash signature:		Regression By:

Description Nigel Arnot 2015-03-11 09:43:27 UTC

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?

Comment 1 raal 2015-03-11 21:49:11 UTC

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

Comment 2 raal 2015-03-13 12:51:39 UTC

(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

Comment 3 Robinson Tryon (qubit) 2015-03-14 07:01:43 UTC

(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

Comment 4 Maxim Monastirsky 2015-06-10 20:58:54 UTC


*** This bug has been marked as a duplicate of bug 78989 ***