// you’re reading...

Open Source

Open Office 2007 files in Linux

Occasionally (or often), when one sends you Office 2007 files (docx, xlsx, pptx) and you are using OpenOffice, you wonder how to open it?  I can suggest, my tried and tested solution on OpenOffice, on Linux.

Earlier I had been converting Office 2007 on Linux command line using OdfConverter as per the instructions at http://www.oooninja.com/2008/01/convert-openxml-docx-etc-in-linux-using.html.

Today saw Ubuntu Linux opening Office 2007 files in OpenOffice 2.4. I have been using Fedora (as of this writing I’m running Fedora 9) on my laptop.Definitely there had to be something similar, for OpenOffice 2.4 in Fedora 9.

Found it at the following URL: http://katana.oooninja.com/w/odf-converter-integrator

  1. Fedora users can install the RPMs from http://katana.oooninja.com/f/software/odf-converter-integrator-0.1.5-1.i386.rpm
  2. Once this RPM is installed, double clicking any Office 2007 file will open the corresponding file in OpenOffice.

How it works

  1. It basically registers a script – a python script – called odf-converter-integrator (found in /usr/bin directory) which is associated with the MIME (Multipurpose Internet Mail Extensions) types of Office 2007 files.
  2. This script uses the same OdfConverter binary which I used before and converts the Office 2007 file on the fly.

Shortcomings

  1. While this will open an Office 2007 file using double click, you cannot open an Office 2007 file using File->Open in OpenOffice.
  2. Don’t expect to be able to save the file in Office 2007 format. You will have to choose one of the OpenOffice supported file formats (like ODT, DOC, ODS, XLS, ODP, PPT etc.).

Update (Oct 20, 2008): The convertor documents do not show SmartArt (if used) in the Office 2007 files, not even as an embedded image.

GD Star Rating
loading...
GD Star Rating
loading...
  • Share/Bookmark

Discussion

2 comments for “Open Office 2007 files in Linux”

  1. I had installed an earlier version 0.1.3 and found a peculiar thing happening, if I try and open the file from within OpenOffice it does not seem to recognise the file type and pops up a file type selection list, same thing happened in 0.1.5 but if I open a file browser and double-click the file it opens it fine!

    Have you had a similar experience?

    Cheers…Kishore

    GD Star Rating
    loading...

    Posted by Kishore Bhargava | August 11, 2008, 12:26 pm
  2. Same experience.

    OpenOffice opens the Filter Selection dialog if you use the File>Open, browse and select a docx (or Office 2007) file and try to open it.

    The reason for this is odf-convertor-integrator is an external script (and not an OpenOffice filter). This script is associated with all the Office 2007 extensions (to be precise MIME types) during the RPM installation. It is like – for 2007 files, “Open With” > odf-convertor-integrator.

    This script in turn converts the 2007 files into OpenDocument files and invokes OpenOffice to open the converted file. OpenOffice does not even know the existence of this script and the script does not plug-into OpenOffice.

    It is interesting to see the mapping of Office 2007 file extensions to OpenDocument file extensions at line 177 in the odf-convertor-integrator script.

    On the other hand, Ubuntu seems to have some OpenOffice filters for reading 2007 file. But the link to odf-convertor-integrator mentions these filters to be of Alpha quality and recommends itself to be better :-)

    GD Star Rating
    loading...

    Posted by Shekhar | August 11, 2008, 12:58 pm

Post a comment

Overslept last night to keep my eyes open for a long meeting at UNESCO. But still wish to have a power nap before the meeting ;)
6 hours ago, comment
Your brain may be overflowing with new ideas today and your se... More for Leo http://twittascope.com/twittascope/?sign=5
6 hours ago, comment
For the fans RT @wordpress WordPress personas for Firefox: http://short.to/1goju
9 hours ago, comment
Hit by Twitter rate limit in a project. Requested client 2 fill http://tinyurl.com/ye6zwrh Within 24 hrs got mail: 20K requests/hr in 48 hrs
9 hours ago, comment
New blog post: Drupal 6: Different Page Templates for different Content Types http://bit.ly/bfX1yc
9 hours ago, comment