Welcome to Atalasoft Community Sign in | Help

Which formats does OpenOffice support?

What can you extract from the following dialogue between Prospect and Employee?

P: Which formats does <application name> support?
E: Which one are you interested in?
P: Err… Give me all you have!
E: We support many formats, including… which one you were interested in again?

One can, with certain level of confidence, say that:

  1. Prospect does not fully know/understand what he/she wants;
  2. Employee does not remember from top of his/her head which formats their product supports and does not have a list handy;

If you imagine that employer itself relies on 3rd party components, you may very well end up with #3: employer is not 100% sure which formats are supported by components they use.

It is not a huge secret in ECM world that OpenOffice supports huge variety of formats and has more-or-less appealing API for converting documents; so some people use it to “convert the unconvertible” under the hood of their applications.

Since we are looking into OpenOffice support as well, here is a big question: which formats does the OpenOffice support?

OpenOffice has extendible architecture, so it is hard to say which formats are there. You sure can use the “Open” file command, but, here is a dirty secret, not all stuff OpenOffice can support really is there. Since googling did not give a good answer, so I decided to ask the source. The source code.

Luckily, OpenOffice.org has a common mechanism for registering filters. Namely there is a bunch of XCU files in filter/source/config/fragments/filters. I figured I could use the filter definitions to extract the list of formats I need. So I wrote a simple extraction tool and here is the list I’ve got:

Title Read Write Type
ODF Chart yes yes Chart
StarOffice Chart yes yes Chart
StarOffice Report Chart yes yes Chart
StarChart 3.0 yes no Chart
StarChart 4.0 yes no Chart
StarChart 5.0 yes no Chart
ODF Database yes yes Database
BMP - Windows Bitmap no yes Drawing
BMP - Windows Bitmap yes no Drawing
DXF - AutoCAD Interchange Format yes no Drawing
EMF - Enhanced Metafile no yes Drawing
EMF - Enhanced Metafile yes no Drawing
EPS - Encapsulated PostScript no yes Drawing
EPS - Encapsulated PostScript yes no Drawing
GIF - Graphics Interchange Format no yes Drawing
GIF - Graphics Interchange Format yes no Drawing
HTML Document (product Draw) no yes Drawing
JPEG - Joint Photographic Experts Group no yes Drawing
JPEG - Joint Photographic Experts Group yes no Drawing
Macromedia Flash (SWF) no yes Drawing
MET - OS/2 Metafile yes no Drawing
MET - OS/2 Metafile no yes Drawing
ODF Drawing yes yes Drawing
ODF Drawing Template yes yes Drawing
PBM - Portable Bitmap yes no Drawing
PBM - Portable Bitmap no yes Drawing
PCD - Kodak Photo CD (192x128) yes no Drawing
PCD - Kodak Photo CD (384x256) yes no Drawing
PCD - Kodak Photo CD (768x512) yes no Drawing
PCT - Mac Pict no yes Drawing
PCT - Mac Pict yes no Drawing
PCX - Zsoft Paintbrush yes no Drawing
PDF - Portable Document Format no yes Drawing
PGM - Portable Graymap yes no Drawing
PGM - Portable Graymap no yes Drawing
PNG - Portable Network Graphic no yes Drawing
PNG - Portable Network Graphic yes no Drawing
PPM - Portable Pixelmap yes no Drawing
PPM - Portable Pixelmap no yes Drawing
product format Drawing yes yes Drawing
product format Drawing Template yes yes Drawing
PSD - Adobe Photoshop yes no Drawing
RAS - Sun Raster Image no yes Drawing
RAS - Sun Raster Image yes no Drawing
SGF - StarWriter Graphics Format yes no Drawing
SGV - StarDraw 2.0 yes no Drawing
StarDraw 3.0 yes yes Drawing
StarDraw 3.0 Template yes yes Drawing
StarDraw 5.0 yes yes Drawing
StarDraw 5.0 Template yes yes Drawing
SVG - Scalable Vector Graphics no yes Drawing
SVM - StarView Metafile yes no Drawing
SVM - StarView Metafile no yes Drawing
TGA - yesvision Targa yes no Drawing
TIFF - Tagged Image File Format yes no Drawing
TIFF - Tagged Image File Format no yes Drawing
WMF - Windows Metafile yes no Drawing
WMF - Windows Metafile no yes Drawing
XBM - X Bitmap yes no Drawing
XHTML no yes Drawing
XPM - X PixMap yes no Drawing
XPM - X PixMap no yes Drawing
MathML 1.01 yes yes Formula
MathType3.x yes yes Formula
ODF Formula yes yes Formula
PDF - Portable Document Format no yes Formula
product format Formula yes yes Formula
StarMath 2.0 yes no Formula
StarMath 3.0 yes no Formula
StarMath 4.0 yes no Formula
StarMath 5.0 yes yes Formula
HTML (Writer/Global) no yes Global
HTML Document (product Master Document) no yes Global
ODF Master Document yes yes Global
ODF Text Document no yes Global
PDF - Portable Document Format no yes Global
product format Master Document yes yes Global
product format Text Document no yes Global
StarWriter 3.0 no yes Global
StarWriter 4.0 no yes Global
StarWriter 4.0 Master Document yes yes Global
StarWriter 5.0 no yes Global
StarWriter 5.0 Master Document yes yes Global
Text Encoded (product Master Document) yes yes Global
BMP - Windows Bitmap no yes Presentation
CGM - Computer Graphics Metafile yes no Presentation
EMF - Enhanced Metafile no yes Presentation
EPS - Encapsulated PostScript no yes Presentation
GIF - Graphics Interchange Format no yes Presentation
HTML Document (product Impress) no yes Presentation
JPEG - Joint Photographic Experts Group no yes Presentation
Macromedia Flash (SWF) no yes Presentation
MET - OS/2 Metafile no yes Presentation
Microsoft PowerPoint 2007 XML yes no Presentation
Microsoft PowerPoint 2007 XML Template yes no Presentation
Microsoft PowerPoint 97/2000/XP yes yes Presentation
Microsoft PowerPoint 97/2000/XP Template yes yes Presentation
ODF Drawing (Impress) yes yes Presentation
ODF Presentation yes yes Presentation
ODF Presentation Template yes yes Presentation
PBM - Portable Bitmap no yes Presentation
PCT - Mac Pict no yes Presentation
PDF - Portable Document Format no yes Presentation
PGM - Portable Graymap no yes Presentation
PNG - Portable Network Graphic no yes Presentation
PPM - Portable Pixelmap no yes Presentation
product format Drawing (product Impress) yes yes Presentation
product format Presentation yes yes Presentation
product format Presentation Template yes yes Presentation
PWP - PlaceWare no yes Presentation
RAS - Sun Raster Image no yes Presentation
StarDraw 3.0 (product Impress) yes yes Presentation
StarDraw 3.0 Template (product Impress) yes yes Presentation
StarDraw 5.0 (product Impress) yes yes Presentation
StarDraw 5.0 Template (product Impress) yes yes Presentation
StarImpress 4.0 yes yes Presentation
StarImpress 4.0 Template yes yes Presentation
StarImpress 5.0 yes yes Presentation
StarImpress 5.0 Packed yes no Presentation
StarImpress 5.0 Template yes yes Presentation
SVG - Scalable Vector Graphics no yes Presentation
SVM - StarView Metafile no yes Presentation
TIFF - Tagged Image File Format no yes Presentation
Unified Office Format presentation yes yes Presentation
WMF - Windows Metafile no yes Presentation
XHTML no yes Presentation
XPM - X PixMap no yes Presentation
ODF Database Report yes yes Report
Data Interchange Format yes yes Spreadsheet
dBASE yes yes Spreadsheet
HTML Document (product Calc) yes yes Spreadsheet
Lotus 1-2-3 yes no Spreadsheet
Microsoft Excel 2003 XML yes yes Spreadsheet
Microsoft Excel 2007 Binary yes no Spreadsheet
Microsoft Excel 2007 XML yes no Spreadsheet
Microsoft Excel 2007 XML Template yes no Spreadsheet
Microsoft Excel 4.0 yes no Spreadsheet
Microsoft Excel 4.0 Template yes no Spreadsheet
Microsoft Excel 5.0 yes yes Spreadsheet
Microsoft Excel 5.0 Template yes yes Spreadsheet
Microsoft Excel 95 yes yes Spreadsheet
Microsoft Excel 95 Template yes yes Spreadsheet
Microsoft Excel 97/2000/XP yes yes Spreadsheet
Microsoft Excel 97/2000/XP Template yes yes Spreadsheet
MiniCalc (Palm) yes yes Spreadsheet
ODF Spreadsheet yes yes Spreadsheet
ODF Spreadsheet Template yes yes Spreadsheet
PDF - Portable Document Format no yes Spreadsheet
Pocket Excel yes yes Spreadsheet
product format Spreadsheet yes yes Spreadsheet
product format Spreadsheet Template yes yes Spreadsheet
Quattro Pro 6.0 yes no Spreadsheet
Rich Text Format (product Calc) yes no Spreadsheet
StarCalc 1.0 yes no Spreadsheet
StarCalc 3.0 yes yes Spreadsheet
StarCalc 3.0 Template yes yes Spreadsheet
StarCalc 4.0 yes yes Spreadsheet
StarCalc 4.0 Template yes yes Spreadsheet
StarCalc 5.0 yes yes Spreadsheet
StarCalc 5.0 Template yes yes Spreadsheet
SYLK yes yes Spreadsheet
Text CSV yes yes Spreadsheet
Unified Office Format spreadsheet yes yes Spreadsheet
Web Page Query (product Calc) yes no Spreadsheet
XHTML no yes Spreadsheet
Ami Pro 1.x-3.1 yes no Text
AportisDoc (Palm) yes yes Text
BibTeX no yes Text
Claris Works yes no Text
CTOS DEF yes no Text
DataGeneral CEO Write yes no Text
DCA Revisable Form Text yes no Text
DCA with Display Write 5 yes no Text
DCA/FFT-Final Form Text yes no Text
DEC DX yes no Text
DEC WPS-PLUS yes no Text
DisplayWrite 2.0-4.x yes no Text
DisplayWrite 5.x yes no Text
DocBook yes yes Text
EBCDIC yes no Text
Enable yes no Text
Frame Maker MIF 3.0 yes no Text
Frame Maker MIF 4.0 yes no Text
Frame Maker MIF 5.0 yes no Text
Frame Work III yes no Text
Frame Work IV yes no Text
Hangul WP 97 yes no Text
HP AdvanceWrite Plus yes no Text
HTML Document (product Writer) yes yes Text
ICL Office Power 6 yes no Text
ICL Office Power 7 yes no Text
Interleaf yes no Text
Interleaf 5 - 6 yes no Text
LaTeX 2e no yes Text
Legacy Winstar onGO yes no Text
Lotus 1-2-3 1.0 DOS (product Writer) yes no Text
Lotus 1-2-3 1.0 WIN (product Writer) yes no Text
Lotus Manuscript yes no Text
Mac Write 4.x 5.0 yes no Text
Mac Write II yes no Text
Mac Write Pro yes no Text
MASS 11 Rel. 8.0-8.3 yes no Text
MASS 11 Rel. 8.5-9.0 yes no Text
MediaWiki no yes Text
Microsoft Excel 4.0 (product Writer) yes no Text
Microsoft Excel 5.0 (product Writer) yes no Text
Microsoft Excel 95 (product Writer) yes no Text
Microsoft MacWord 3.0 yes no Text
Microsoft MacWord 4.0 yes no Text
Microsoft MacWord 5.x yes no Text
Microsoft WinWord 1.x yes no Text
Microsoft WinWord 2.x yes no Text
Microsoft WinWord 5 yes no Text
Microsoft Word 2003 XML yes yes Text
Microsoft Word 2007 XML yes no Text
Microsoft Word 2007 XML Template yes no Text
Microsoft Word 3.x yes no Text
Microsoft Word 4.x yes no Text
Microsoft Word 5.x yes no Text
Microsoft Word 6.0 yes yes Text
Microsoft Word 6.x yes no Text
Microsoft Word 95 yes yes Text
Microsoft Word 95 Template yes no Text
Microsoft Word 97/2000/XP yes yes Text
Microsoft Word 97/2000/XP Template yes no Text
Microsoft Works 2.0 DOS yes no Text
Microsoft Works 3.0 Win yes no Text
Microsoft Works 4.0 Mac yes no Text
MultiMate 3.3 yes no Text
MultiMate 4 yes no Text
MultiMate Adv. 3.6 yes no Text
MultiMate Adv. II 3.7 yes no Text
NAVY DIF yes no Text
ODF Text Document yes yes Text
ODF Text Document Template yes yes Text
OfficeWriter 4.0 yes no Text
OfficeWriter 5.0 yes no Text
OfficeWriter 6.x yes no Text
PDF - Portable Document Format no yes Text
Peach Text yes no Text
PFS First Choice 1.0 yes no Text
PFS First Choice 2.0 yes no Text
PFS First Choice 3.0 yes no Text
PFS Professional Write 1.0 yes no Text
PFS Professional Write 2.x yes no Text
PFS Professional Write Plus yes no Text
PFS Write yes no Text
Pocket Word yes yes Text
product format Text Document yes yes Text
product format Text Document Template yes yes Text
Q&A Write 1.0-3.0 yes no Text
Q&A Write 4.0 yes no Text
Rapid File 1.0 yes no Text
Rapid File 1.2 yes no Text
Rich Text Format yes yes Text
Samna Word IV-IV Plus yes no Text
StarWriter 1.0 yes no Text
StarWriter 2.0 yes no Text
StarWriter 3.0 yes yes Text
StarWriter 3.0 Template yes yes Text
StarWriter 4.0 yes yes Text
StarWriter 4.0 Template yes yes Text
StarWriter 5.0 yes yes Text
StarWriter 5.0 Template yes yes Text
StarWriter DOS yes no Text
T602 Document yes no Text
Text yes yes Text
Text Encoded yes yes Text
Total Word yes no Text
Unified Office Format text yes yes Text
Uniplex onGO yes no Text
Uniplex V7-V8 yes no Text
VolksWriter 3 and 4 yes no Text
VolksWriter Deluxe yes no Text
Wang II SWP yes no Text
Wang PC yes no Text
Wang WP Plus yes no Text
Win Write 3.x yes no Text
WITA yes no Text
WiziWord 3.0 yes no Text
WordPerfect (Win) 5.1-5.2 yes no Text
WordPerfect (Win) 6.0 yes no Text
WordPerfect (Win) 6.1 yes no Text
WordPerfect (Win) 7.0 yes no Text
WordPerfect 4.1 yes no Text
WordPerfect 4.2 yes no Text
WordPerfect 5.0 yes no Text
WordPerfect 5.1 yes no Text
WordPerfect 6.0 yes no Text
WordPerfect 6.1 yes no Text
WordPerfect Document yes no Text
WordPerfect Mac 1 yes no Text
WordPerfect Mac 2 yes no Text
WordPerfect Mac 3 yes no Text
WordStar (Win) 1.x-2.0 yes no Text
WordStar 2000 Rel. 3.0 yes no Text
WordStar 2000 Rel. 3.5 yes no Text
WordStar 3.3x yes no Text
WordStar 3.45 yes no Text
WordStar 4.0 yes no Text
WordStar 5.0 yes no Text
WordStar 5.5 yes no Text
WordStar 6.0 yes no Text
WordStar 7.0 yes no Text
WriteNow 3.0 (Macintosh) yes no Text
Writing Assistant yes no Text
XEROX XIF 5.0 yes no Text
XEROX XIF 5.0 (Illustrator) yes no Text
XEROX XIF 6.0 (Color Bitmap) yes no Text
XEROX XIF 6.0 (Res Graphic) yes no Text
XHTML no yes Text
XyWrite (Win) 1.0 yes no Text
XyWrite III yes no Text
XyWrite III+ yes no Text
XyWrite IV yes no Text
XyWrite Sig. (Win) yes no Text
XyWrite Signature yes no Text
Help content yes no Web
HTML Document yes yes Web
HTML Document Template yes yes Web
MediaWiki no yes Web
PDF - Portable Document Format no yes Web
product format HTML Template yes yes Web
product format Text Document (product Writer/Web) no yes Web
product Text (product Writer/Web) no yes Web
StarWriter 3.0 (product Writer/Web) no yes Web
StarWriter 4.0 (product Writer/Web) no yes Web
StarWriter 5.0 (product Writer/Web) no yes Web
StarWriter/Web 4.0 Template yes yes Web
StarWriter/Web 5.0 Template yes yes Web
Text (product Writer/Web) yes yes Web
Text Encoded (product Writer/Web) yes yes Web

The tool and result files (TXT,OpenOffice and Excel) can be downloaded here.

Needless to say, this list will change from release to release. In order to generate it you will need to download the source code from OpenOffice.org source code download page or directly from their SVN (browse). You will minimally need the filter/source/config/fragments/filters folder.

Published Thursday, July 09, 2009 1:10 PM by dbarvitsky
Filed under: , , ,

Comments

# How to Convert Microsoft Word Files to Open Office | Open Office Tutorial

Anonymous comments are disabled