Saturday, August 22, 2009

Converting Office 2007 Templates to OpenOffice 3.1

Ever run into a situation where you have an Office 2007 template, but you need to convert it to OpenOffice 3.1 in Ubuntu? Here what I did in Ubuntu 9.04 64bit

  1. Install rpm2cpio and cpio: sudo apt-get install rpm libgif4
  2. Download the latest ODF Converter RPM from http://download.go-oo.org/tstnvl/odf-converter/RPMS/x86_64/ into a temporary folder.
  3. Extract the package by executing: rpm2cpio odf-converter*rpm | cpio -ivd
  4. Next copy the contents of /usr/lib/ooo3/program/OdfConverter to /usr/bin using the command: sudo cp usr/lib/ooo-2.0/program/OdfConverter /usr/bin
  5. This program requires libtiff.so.3 which is not present in the 64-bit Ubuntu 9.04. Create a symbolic link in /usr/lib called libtiff.so.3 to libtiff.so.4 by executing: sudo ln -s /usr/lib/libtiff.so.4 /usr/lib/libtiff.so.3
  6. Run sudo ldconfig to update the library cache.
  7. The converter is now installed.
To convert a template, run:
OdfConverter /i .???x

This will create a OpenOffice template of the Office 2007 template in the directory where the template was saved.