Ask Your Question
0

What are the 5.x Calc Import/Export Filters? [closed]

asked 2015-10-08 12:05:36 +0100

Alex Kemp gravatar image

updated 2015-10-08 14:13:56 +0100

I see continual questions such as "Will LO import Lotus 123 files?". Import + export are done via Filters, and there are reported to be hundreds of them available. However, nowhere within the documentation has anybody thought to say what these filters are, nor which files they refer to, nor what programs they support. That makes life damn difficult for humble LO supporters trying to answer questions.

So, what filters are available for Calc files?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-20 23:32:39.035658

Comments

Alex Kemp gravatar imageAlex Kemp ( 2015-11-18 19:13:23 +0100 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2015-10-08 12:13:02 +0100

Alex Kemp gravatar image

updated 2015-11-19 11:11:18 +0100

Thank you for asking that question, Alex.

filters-calc.odt (Writer version of filter.calc)
filters-calc.ods (Calc version of filter.calc) (added 2015-11-18)
(filter.calc is hand-extracted from calc.xcd)

:~$ /opt/libreoffice5.0/program/soffice.bin --version
LibreOffice 5.0.0.5 437e4abdf9e72fd0a6e6f8697a0e659bc77f9b10
:~$ cat filter.calc | wc -l
40

Obtained from /opt/libreoffice5.0/share/registry/calc.xcd; Debian 6.0:

:~$ cat filter.calc | sort
"Apple Numbers 2" application/x-iwork-numbers-sffnumbers Extensions:numbers
"BeagleWorks/WordPerfect Works v1 Spreadsheet" Extensions:-
"ClarisResolve Document" application/clarisworks Extensions:cwk
"ClarisWorks/AppleWorks Spreadsheet" application/clarisworks Extensions:cwk
"dBase" Extensions:dbf
"DIF (Data Interchange Format)" Extensions:dif
"GreatWorks Spreadsheet" Extensions:-
"HTML Table" text/html Extensions:xls
"HTML" text/html Extensions:html htm
"Lotus (Lotus 1-2-3)" application/vnd.lotus-1-2-3 Extensions:wk1 wks 123
"Microsoft Excel 2007-2013 XML" application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Extensions:xlsx xlsm
"Microsoft Excel 2007-2013 XML Template" application/vnd.openxmlformats-officedocument.spreadsheetml.template Extensions:xltm xltx
"Microsoft Excel 2007 Binary" Extensions:xlsb
"Microsoft Works Document" Extensions:wks wdb
"Microsoft Works for Mac Spreadsheet (v1 - v4)" application/vnd.ms-works Extensions:wps
"MS Excel 4.0" application/vnd.ms-excel Extensions:xls xlw xlc xlm
"MS Excel 4.0 Vorlage/Template" application/vnd.ms-excel Extensions:xlt
"MS Excel 5.0/95" application/vnd.ms-excel Extensions:xls xlc xlm xlw
"MS Excel 5.0/95 Vorlage/Template" application/vnd.ms-excel Extensions:xlt
"MS Excel 95" application/vnd.ms-excel Extensions:xls xlc xlm xlw
"MS Excel 95 Vorlage/Template" application/vnd.ms-excel Extensions:xlt
"MS Excel 97" application/vnd.ms-excel Extensions:xls xlc xlm xlw xlk
"MS Excel 97 Vorlage/Template" application/vnd.ms-excel Extensions:xlt
"ODF Spreadsheet (Calc 8)" application/vnd.oasis.opendocument.spreadsheet Extensions:ods
"ODF Spreadsheet Template (Calc 8 Template)" application/vnd.oasis.opendocument.spreadsheet-template Extensions:ots
"Office Open XML Spreadsheet" application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Extensions:xlsx xlsm
"Office Open XML Spreadsheet Template" application/vnd.openxmlformats-officedocument.spreadsheetml.template Extensions:xltx xltm
"OpenDocument Spreadsheet Flat XML" Extensions:fods ods xml
"OpenOffice.org 1.0 Spreadsheet Template" Extensions:
"PDF - Portable Document Format" application/pdf Extensions:pdf
"Quattro Pro 6.0" Extensions:wb2
"QuattroPro Document" Extensions:wq1 wq2
"Rich Text Format" application/rtf Extensions:rtf
"StarOffice XML (OpenOffice.org 1.0 Spreadsheet) (Calc 6.0)" application/vnd.sun.xml.calc Extensions:sxc
"StarOffice XML Template (OpenOffice.org 1.0 Spreadsheet Template) (Calc 6.0 Template)" application/vnd.sun.xml.calc.template Extensions:stc
"SYLK" text/spreadsheet Extensions:slk sylk
"Text CSV (StarCalc)" Extensions:csv
"Text" text/plain Extensions:csv tsv tab txt
"Wingz for Mac Document" Extensions:-
"WPS Lotus Document" Extensions:wk1 wk3

If this helps then please show you like it with an uptick ()

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2015-10-08 12:05:36 +0100

Seen: 1,765 times

Last updated: Nov 19 '15