Connect Libreoffice 4.2 with Google Drive

I’ve been reading around that there is now support for Google Drive from within LibreOffice 4.2. How was this implemented and how can i use it? Im using Ubuntu 12.04 and Libreoffice 4.2 installed via PPA.

Here is how it works for me:

  1. Use a TDF release binary, unless you’re sure the the Ubuntu-shipped binaries enable the Google Drive feature as well. (–with-gdrive-client-id and --with-gdrive-client-secret configure switches.)

  2. Make sure you use the internal file picker: Tools → Options → LibreOffice → General → check “Use LibreOffice dialogs”.

  3. File → Open, then define your google drive: click the “servers…” button, then set type to CMIS, name can be e.g. gdrive, set Server Type to Google Drive, set your username, password, and that’s it.

Two notes:

  1. If you want to configure the same google drive account on multiple machines, then clicking through these steps is boring. You can edit registrymodifications.xcu in your profile – all you need is to extend FilePickerPlacesUrls and FilePickerPlacesNames. The URL for gdrive is “vnd.libreoffice.cmis://$NICK%40gmail.com@https:%2F%2Fwww.googleapis.com%2Fdrive%2Fv2%23GoogleDrive/”, (replace $NICK with your gmail login) the name is what you want, e.g. “gdrive”.

  2. gdrive integration works fine for me on master, however I get “general I/O error” when I use the TDF binaries, which is odd – if gdrive support is disabled, then you should not be able to choose gdrive as a CMIS server type at all.

As for the second note, a bugreport (and CC’ing Cédric) would be welcome. :slight_smile:

Was able to set Server Type to Google Drive and then clicked the refresh button, which opened up a dialog for me to put in my email address and password. Then it asked to set a master password for saved passwords. Then i’m back at the initial dialog and repository is empty, path is empty and login is also empty and the OK button is disabled and i cant go any further.

@Jay, getting nothing in the Repository list box isn’t normal… any additional information like the LO version and where the build comes are welcomed. I fixed an SSL certification validation problem recently for TDF builds.

@cedric - This is my build information

Version: 4.2.6.2
Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f

I tested it on Windows with version 4.2.6.2 and it worked correctly there.

Seems like it is not just me having this problem, but sophie did as well.

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=72646

This “solution” should be removed from the forum. Current versions of LO require a 6-digit verification code from Google Drive. Unfortunately, Google Drive never sends the PIN, and there is absolutely nothing in the LO Help files or in the Forums that tells you how to solve that problem. Maybe very few people are using Save to Remote, or maybe they just can’t figure out how to get past the 6-digit PIN problem.

1 Like

This is my problem as well. How do I generate the six digit pin?