EN/documentation/ooo3 user guides/getting started/file formats

Getting Started with OpenOffice.org 3

Appendix B. OpenOffice.org history and community

< Previous Section

[[{{{NextPart}}}| Next Section >]]

• Appendix B. OpenOffice.org history and community
• License, open source, OpenDocument
• File formats
• Frequently asked questions

< Previous Page

Next Page >

File formats OOo can open

OpenOffice.org can open a wide variety of file formats in addition to the OpenDocument formats.

Opening text documents

In addition to OpenDocument formats (.odt, .ott, .oth, and .odm), Writer 3 can open the formats used by OOo 1.x (.sxw, .stw, and .sxg) and the following text document formats:

• Microsoft Word 6.0/95/97/2000/XP (.doc and .dot)
• Microsoft Word 2003 XML (.xml)
• Microsoft Word 2007 XML (.docx, .docm, .dotx, .dotm)
• Microsoft WinWord 5 (.doc)
• WordPerfect Document (.wpd)
• WPS 2000/Office 1.0 (.wps)
• .rtf, .txt, and .csv
• StarWriter formats (.sdw, .sgl, .vor)
• DocBook (.xml)
• Unified Office Format text (.uot, .uof)
• Ichitaro 8/9/10/11 (.jtd and .jtt)
• Hangul WP 97 (.hwp)
• T602 Document (.602, .txt)
• AportisDoc (Palm) (.pdb)
• Pocket Word (.psw)

When opening .htm or .html files (used for web pages), OOo customizes Writer for working with these files.

Opening spreadsheets

In addition to OpenDocument formats (.ods and .ots), Calc 3 can open the formats used by OOo 1.x (.sxc and .stc) and the following spreadsheet formats:

• Microsoft Excel 97/2000/XP (.xls, .xlw, and .xlt)
• Microsoft Excel 4.x–5.0/95 (.xls, .xlw, and .xlt)
• Microsoft Excel 2003 XML (.xml)
• Microsoft Excel 2007 XML (.xlsx, .xlsm, .xltx, .xltm)
• Microsoft Excel 2007 binary (.xlsb)
• Lotus 1-2-3 (.wk1, .wks, and .123)
• Data Interchange Format (.dif)
• Rich Text Format (.rtf)
• Text CSV (.csv and .txt)
• StarCalc formats (.sdc and .vor)
• dBASE (.dbf)
• SYLK (.slk)
• Unified Office Format spreadsheet (.uos, .uof)
• .htm and .html files, including Web page queries
• Pocket Excel (pxl)
• Quattro Pro 6.0 (.wb2)

Opening presentations

In addition to OpenDocument formats (.odp, .odg, and .otp), Impress 3 can open the formats used by OOo 1.x (.sxi and .sti) and the following presentation formats:

• Microsoft PowerPoint 97/2000/XP (.ppt, .pps, and .pot)
• Microsoft PowerPoint 2007 (.pptx, .pptm, .potx, .potm)
• StarDraw and StarImpress (.sda, .sdd, .sdp, and .vor)
• Unified Office Format presentation (.uop, .uof)
• CGM – Computer Graphics Metafile (.cgm)
• Portable Document Format (.pdf)

Opening graphic files

In addition to OpenDocument formats (.odg and .otg), Draw 3 can open the formats used by OOo 1.x (.sxd and .std) and the following graphic formats:

BMP	JPEG, JPG	PCX	PSD	SGV	WMF
DXF	MET	PGM	RAS	SVM	XBM
EMF	PBM	PLT	SDA	TGA	XPM
EPS	PCD	PNG	SDD	TIF, TIFF
GIF	PCT	PPM	SGF	VOR

Opening formula files

In addition to OpenDocument Formula (.odf) files, Math 3 can open the format used by OOo 1.x (.sxm), StarMath, (.smf), and MathML (.mml) files.

When opening a Word document that contains an embedded equation editor object, if the option for it is checked in Tools > Options > Load/Save > Microsoft Office, the object will be automatically converted to an OpenOffice.org Math object.

File formats OOo can save to

Saving in an OpenDocument format guarantees the correct rendering of the file when it is transferred to another person or when the file is re-opened with a later version of OpenOffice.org. It is strongly recommended that you use ODF as default file format. However, you can save files in other formats, if you wish.

When sharing a document that you do not expect or want the recipient to modify, the safest option is to convert the document to PDF. OOo provides a very straightforward way to convert documents to PDF.

Saving text documents

In addition to OpenDocument formats (.odt and .ott), Writer 3 can save in these formats:

• OpenOffice.org 1.x Text Document (.sxw)
• OpenOffice.org 1.x Text Document Template (.stw)
• Microsoft Word 6.0, 95, and 97/2000/XP (.doc)
• Microsoft Word 2003 XML (.xml)
• Rich Text Format (.rtf)
• StarWriter 3.0, 4.0, and 5.0 (.sdw)
• StarWriter 3.0, 4.0, and 5.0 Template (.vor)
• Text (.txt)Text Encoded (.txt)
• Unified Office Format text (.uot, .uof)
• HTML Document (OpenOffice.org Writer) (.html and .htm)
• DocBook (.xml)
• AportisDoc (Palm) (.pdb)
• Pocket Word (.psw)

The .rtf format is a common format for transferring text files between applications, but you are likely to experience loss of formatting and images. For this reason, other formats should be used.

Saving spreadsheet files

In addition to OpenDocument formats (.ods and .ots), Calc 3 can save in these formats:

• OpenOffice.org 1.x Spreadsheet (.sxc)
• OpenOffice.org 1.x Spreadsheet Template (.stc)
• Microsoft Excel 97/2000/XP (.xls and .xlw)
• Microsoft Excel 97/2000/XP Template (.xlt)
• Microsoft Excel 5.0 and 95 (.xls and .xlw)
• Microsoft Excel 2003 XML (.xml)
• Data Interchange Format (.dif)
• dBase (.dbf)SYLK (.slk)Text CSV (.csv and .txt)
• StarCalc 3.0, 4.0, and 5.0 formats (.sdc and .vor)
• Unified Office Format spreadsheet (.uos)
• HTML Document (OpenOffice.org Calc) (.html and .htm)
• Pocket Excel (.pxl)

The Java Runtime Environment is required to use the mobile device filters for AportisDoc (Palm), Pocket Word, and Pocket Excel.

Saving presentations

In addition to OpenDocument formats (.odp, .otp, and .odg), Impress 3 can save in these formats:

• OpenOffice.org 1.x Presentation (.sxi)
• OpenOffice.org 1.x Presentation Template (.sti)
• Microsoft PowerPoint 97/2000/XP (.ppt)
• Microsoft PowerPoint 97/2000/XP Template (.pot)
• StarDraw, StarImpress (.sda, .sdd, and .vor)
• Unified Office Format presentation (.uop)

Impress can also export to MacroMedia Flash (.swf) and any of the graphics formats listed for Draw.

Saving drawings

Draw 3 can only save in the OpenDocument Drawing formats (.odg and .otg), the OpenOffice.org 1.x formats (.sxd and .std) and StarDraw format (.sda, .sdd, and .vor).

However, Draw can also export to BMP, EMF, EPS, GIF, JPEG, MET, PBM, PCT, PGM, PNG, PPM, RAS, SVG, SVM, TIFF, WMF, and XPM.

Writer/Web can save in these formats

• HTML document (.html and .htm), as HTML 4.0 Transitional
• OpenOffice.org 1.0 HTML Template (.stw)
• OpenOffice.org 2.x HTML Template (.oth)
• StarWriter/Web 4.0 and 5.0 (.vor)
• Text (OpenOffice.org Writer/Web) (.txt)
• Text Encoded (OpenOffice.org Writer/Web) (.txt)