OpenXML/ODF Translator Add-ins for Office

Table of Contents

• Highlights
  • Highlights of ODF Add-in for Word
  • Highlights of ODF Add-in for Excel
  • Highlights of ODF Add-in for PowerPoint
• Download
  • ODF Add-in for Word
  • ODF Add-in for Excel
  • ODF Add-in for PowerPoint
• Software Requirements
• Installing the Add-in
  • ODF Add-in for Word
  • ODF Add-in for Excel
  • ODF Add-in for PowerPoint
• Troubleshooting
• Silent Installation Guide
• OpenXML/ODF Translator Command Line Tools
• Source distribution

Highlights

Highlights of ODF Add-in for Word 1.1

ODF Add-in for Word 1.1 has been released. Below are the enhancements to the existing Word 1.0.

• Japanese & Chinese localized Add-ins
• Performance improvements (up to 80% faster)
• Improved translation of page layout settings (including header and footer)
• Support for OLE objects (with certain limitations due to incompatibilies)
• Improved frame translation
• Improved translation of features related to headings, numbering, multi-level lists and paragraph indentation
• Revamped translation of Table of Contents fields
• Fixed read-only documents bug
• Improved installation process and dependencies detection
• Many other bug-fixes and features added (handling of cropped images, non-standard bullet symbols, user-fields, Asian font support etc.)

For a more detailed list of improvements please see the Release Note document published on SourceForge.

Highlights of ODF Add-in for Excel

Please find below the list of features implemented for ODF Add-in for Excel:

• Charts (2D&3D: Line, Area, Column, Bar, Pie)
• Hyperlinks
• Headers & Footers
• Conditional formatting (Direct conversion)
• Pictures
• Data styles (Time, Fractions, Scientific)
• Annotations (Reverse conversion: Note without shapes properties)
• Annotations (Direct)
• Basic and Advanced Table Model
• Headers & Footers
• Styles and Default styles
• Text & Paragraph formatting
• Page Styles and Layout
• Data styles:
  • Numbers
  • currencies
  • date
  • percentages
• Basic and Advanced Table Model
• Basic Text and Paragraph Formatting
• Document Metadata
• Document structure

Highlights of ODF Add-in for PowerPoint

Please find below the list of features implemented so far for PowerPoint add-in:

• Design Layouts
• Paragraph
• Format Background
• Text, Paragraph, Formatting Indent and Spacing
• List numbering and bullets
• Shapes:
  • Basic Shapes: Line, Text Box, Arrow, Double Arrow, Elbow Connector, Elbow Arrow Connector, Elbow Double-Arrow Connector, Curved Connector, Rounded, Snip Single Corner, Oval, Isosceles Triangle, Right Triangle, Triangle, Rectangle, Textbox
  • FlowChart: Process, AlternateProcess, Decision, Data, Predefined Process, Internal Storage, Document, Multi document, Terminator, Preparation, Manual Input, Manual Operation, Connector, Off-page Connector, Card, Punched Tape, Summing Junction, Or, Collate, Sort, Extract, Merge, Stored Data, Delay, Sequential Access Storage, Magnetic Disk, Direct Access Storage, Display
• Page Setup
• Custom Slide Show
• Footer
• Design Layouts (Blank and Title only)

Software Requirements

Before installing the ODF Add-in for Word, Excel or PowerPoint, make sure you have the following installed on your PC:

• Microsoft Office 2007 with .NET Programmability Support activated comprising of Word 2007 / Excel 2007 / PowerPoint 2007 as applicable (depending on the converter(s) you are planning to install)
• .NET Framework 2.0*

or

• Microsoft Office 2003 comprising of Word 2003 / Excel 2003 / PowerPoint 2003 as applicable (depending on the add-in(s) you are planning to install)
• Office Compatibility Pack
• .NET Framework 2.0*

or

• Microsoft Office XP comprising of Word XP / Excel XP / PowerPoint XP as applicable (depending on the add-in(s) you are planning to install)
• Office Compatibility Pack
• .NET Framework 2.0

(*) Warning: If you install Microsoft Office before the .NET Framework, you will need to update your Word / Excel / PowerPoint installation, by running the following steps:

1. Open "Add or Remove Programs" from the Control Panel
2. Find the Microsoft Word, Microsoft Excel, Microsoft PowerPoint or Microsoft Office entry respectively and choose "Change"
3. Within the installation process, select "Add or remove features", then add ".NET Programmability Support" in the "Microsoft Office Word" / "Microsoft Office Excel" / "Microsoft Office" section and confirm all installation steps.

Download

ODF Add-in for Word

You can download the ODF Add-in for Word from our download page on SourceForge.net.

Back to top

ODF Add-in for Excel

You can download the ODF Add-in for Excel from our download page on SourceForge.net.

Back to top

ODF Add-In for PowerPoint

You can download the ODF Add-in for PowerPoint from our download page on SourceForge.net.

Back to top

Installing the Add-in

ODF Add-in for Word

Double click the "OdfAddInForWordSetup-en-1.0.exe" file

If installation is successful, you should be able to open an ".ODT" file from Microsoft Word (see menu"File>ODF..."). Also, when right-clicking on a ".ODT" file in explorer, you should have the option to open the document in Microsoft Word (menu "Open with Word").

Important note: The ODF file opened by the add-in is imported in Microsoft Word as a read-only .DOCX file. If you want to save it as ODF, you will have to first make a copy of the document("Menu>Save As") and then use the "Export as ODF" menu.

Back to top

ODF Add-in for Excel

Run the downloaded install program and follow the steps...

If installation is successful, you should see a new "Open ODF" entry in the "File" menu in Excel. It allows you to either import an ODF spreadsheet file or export your current working document as an ODF spreadsheet file (note that during development process, those functionalities might be temporary unavailable).

Important note: The ODF file opened by the add-in is imported in Microsoft Excel as a read-only DOCX file. If you want to save it back as ODF, you will have to first make a copy of the document("Menu>Save As") and then use the "Export as ODF" menu.

Back to top

ODF Add-in for PowerPoint

Run the downloaded install program and follow the steps...

If installation is successful, you should see a new "Open ODF" entry in the "File" menu in PowerPoint. It allows you to either import an ODF presentation file or export your current working document as an ODF presentation file (note that during development process, those functionalities might be temporary unavailable).

Important note: The ODF file opened by the add-in is imported in Microsoft PowerPoint as a read-only DOCX file. If you want to save it back as ODF, you will have to first make a copy of the document("Menu>Save As") and then use the "Export as ODF" menu.

Back to top

Troubleshooting

If you don't see the ODF entry in Microsoft Word / Excel / PowerPoint menu, it could be due to missing features in Word / Excel / PowerPoint (see Software Requirements section) or a failure in the installation of Word / Excel / PowerPoint Primary Interop Assemblies. You will then need to activate the Add-in manually by doing the following...

Microsoft Office XP/2003

1. Go to Tools > Customize, and then click the Commands tab.
2. In the Categories box, click Tools.
3. Drag COM Add-Ins from the Commands box over the Tools menu. When the Tools menu displays the menu commands, point to the location where you want the COM Add-Ins command to appear on the menu, and then release the mouse button.
4. Click Close.
5. In the Tools menu, click COM Add-Ins and check box next to the add-in name in the available list. If the add-in you want isn't in the list, click Add, locate the add-in, and then click OK.

Microsoft Office 2007

1. Click "Word Options" in the "File" menu
2. In the "Add-ins" section, select "COM Add-ins" in the list box and press the "Go" button
3. Make sure to select the checkbox "ODF Word Add-in"/"ODF Excel Add-in"/"ODF PPT Add-in" and validate with the "OK" button.

Back to top

OpenXML/ODF Translator Command Line Tools

OpenXML/ODF Translator Command Line Tools are an additional resource enabling a stand-alone conversion from OpenXML formats to ODF formats and vice-versa. An installation of Microsoft Office is not required.

You can download the command line tools from our download page on SourceForge.net.

Minimum Software Requirements

The command line tools require .NET Framework 2.0.

Installation

To install the command line tools, simply unzip the downloaded file into a folder of your choice.

Usage

To use the command line tools, open a console and type the following:

OdfConverter.exe /I Filename [/O PathOrFilename] [/V]

Where:

• /I Filename: Name of the ODF file to transform
• /O PathOrFilename: Path of the folder where to put the output file (must exist) or name of the output file
• /V: Validate the result of the transformation against OpenXML/ODF schemas
• /DEBUG Value: Debug mode (Value from 1-4)

Back to top

Source distribution

Download

You can download the complete source code from our download page on SourceForge.net.

Minimum Software Requirements

To compile the source distribution, you will need Microsoft Visual Studio 2005 or the free Microsoft Visual C# 2005 edition.

Back to top