How to Sync Your LibreOffice Files with Google Docs

Share on Tumblr

If you are like me, you have a love/hate relationship with Google Docs. You love that you can access your documents from anywhere and love that it auto-saves and is easy to use. You might hate, however, how it sometimes disconnects in the middle of the sentence you are typing or how you have to run it inside a browser tab or window, sometimes getting it mixed up with your websites and accidentally closing the window.

LibreOffice Splash screen

 

If you are like that, then there is a solution that you might find more palatable. It is called Ooo2gd, and it allows you to sync your LibreOffice or OpenOffice.org documents with Google Docs, Zoho Office, or any WebDav server. It is a free OpenOffice extension that you can download and get working in seconds. Thanks to our friends at UK dedicated hosting server provider 34SP.com for bringing it to our attention.

Installation

OK, what I said about installing it in seconds is only true if you already have Java installed. For Windows, you can download Java from the website and use the installer. There seem to be some problems with Mac OS X, so you should check the project’s website for updates.

For Linux, which is the primary focus of this blog, you need to install Sun’s/Oracle’s version of Java. In Ubuntu, just enable the partner repository and then install it from the Ubuntu Software Center, Synaptic, or from the command line with the following command:

1
sudo apt-get install sun-java6-jre sun-java6-plugin
sudo apt-get install sun-java6-jre sun-java6-plugin

Next, you will need to install the libreoffice-java-common package:

1
sudo apt-get install libreoffice-java-common
sudo apt-get install libreoffice-java-common

With LibreOffice closed, download ooo2gd to your Downloads folder and then run this command from a terminal:

1
unopkg add ~/Downloads/ooo2gd_3.0.0.oxt
unopkg add ~/Downloads/ooo2gd_3.0.0.oxt

Using Ooo2gd

After you have it installed, simply open LibreOffice as you normally would. There should now be a floating toolbar with five icons: “Export to Google Docs”, “Import from Google Docs”, “Export to Zoho”, “Import from Zoho”, and “Export with WebDav”. When you click on one of the options, Google Docs for example, it will ask you for your login credentials.

Ooo2gd toolbar

For “User Name”, enter your full Gmail or Google Apps email address, and use the normal password. Autoupdate will re-save the file in Google Docs when you make future changes, keeping it in sync. “Convert to Google Docs format” is the ideal choice if you later intend to edit the file remotely from within Google Docs. You can always do that within Google Docs as well.

Export to Google Docs with Ooo2gd

You might find the popup toolbar to be annoying. If so, you can drag it to the top, left, right, or bottom of LibreOffice to dock it within the window. For my window, I like to clean up the toolbar, removing some of the functions I do not use often, making space for the Ooo2gd bar. Alternatively, all of the options are available in the “File” menu for easy access. There, you will also find a configuration option, with settings to change the appearance, select the default download folder, and more.

Ooo2gd extension configuration dialog

NoteWhen I selected “GTK+” for appearance, the configuration dialog would become intermittently unresponsive, which may be a bug. Therefore, use it with caution. It will be very difficult to switch back to another theme if it freezes.

Best of Both Worlds

The “cloud” is a great platform for those of us on the go or even those who just use more than one device in the same location. Google Docs, Zoho Office, and other software as a service (SaaS) give you that flexibility. With that mobility, however, comes the uncertainty of having to trust a third party with your data and also having to rely on an Internet connection at all times. Ooo2gd gives you the ability to have the best of both worlds, local and cloud storage for your documents, all with the click of a button.


About the author:  Tavis J. Hampton is a librarian and freelance writer from Indianapolis, Indiana. He is an avid user of free and open source software and strongly believes that software and knowledge should be free and accessible to all people. He enjoys reading, writing, teaching, spending time with his family, and playing with gadgets. Read more from this author


No related posts.

10 Comments

Tavis J. Hampton (@adibudeen) (@adibudeen) (@adibudeen)No Gravatar

July 1st, 2011
at 1:20pm

How to Sync Your LibreOffice (OpenOffice) Files with Google Docs – http://bit.ly/kY6gHI

Thank you for informing me about this. One of the first things on my mind this morning was finding an add-on for Libre Office that would allow me to sync to Google Docs. Your site is one of the first hits and it explains this well.

Tavis J. HamptonNo Gravatar

July 2nd, 2011
at 12:12pm

You’re welcome. I’m glad I could help. It’s something I’ve wanted to do for a long time, but I didn’t even know Ooo2gd existed until I did a search myself the other day.

nick ruest (@ruebot)No Gravatar

July 6th, 2011
at 7:16am

♺ @ioflux: "How to Sync Your LibreOffice Files with Google Docs" by @adibudeen – http://bit.ly/qCVkRH

Nice write up. Great info.

Tavis: What a good post! I tried it and seems to work just with text documents, not spreadsheets. Is it true? Anyway, its a great finding; really a good add-on. Thanks.

E: Package ‘sun-java6-jre’ has no installation candidate
E: Unable to locate package sun-java6-plugin

unopkg add ~/Downloads/ooo2gd_3.0.0.oxt
unopkg: command not found

Not having much luck here. Running “Precise”

Tavis J. HamptonNo Gravatar

May 16th, 2012
at 4:47pm

Hi Steve,

The Sun java package is no longer in Ubuntu. You can follow the directions here to install either Open Java or the Oracle’s Java:

http://maketecheasier.com/install-java-runtime-in-ubuntu/2012/05/14

Tavis J. HamptonNo Gravatar

May 16th, 2012
at 4:49pm

@Leanardo, here is a list of supported document formats:

http://code.google.com/p/ooo2gd/wiki/SupportedDocumentFormats

Spreadsheets should work

Leave a Comment

 

show
 
close
rss Follow on Twitter facebook linkedin youtube google+ digg