// 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

Email This Post Email This Post Print This Post Print This Post Post A Comment Post A Comment Tweet your comments/question to me @shekharg

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

shekharg: RT @aseemsood: Good news today - Delhi Metro Link between C-Sec and Qutub Minar opens today. http://bit.ly/bCXTbw
15 hours ago, comment
shekharg: I disagree, Twidroyd is the best RT @TweetDeck: New Android TweetDeck Beta is so great that we've skipped v6 & gone straight to 7!
11:05 AM Sep 02, 2010, comment
shekharg: Check out this UI http://nyti.ms/cr0Wcg
10:38 AM Sep 02, 2010, comment
shekharg: Let's declare Gurgaon a part of Pakistan till #CWG2010, to keep away the visitors from seeing the condition of roads here
9:34 AM Sep 02, 2010, comment
shekharg: RT @TechCrunch: Google Making Extraordinary Counteroffers To Stop Flow Of Employees To Facebook - http://tcrn.ch/bpdbYT by @arrington
2:18 PM Sep 01, 2010, comment