Hi :)
Ok, this is probably not what you are looking for but just to clear the idea out of the way ... Can
you just open the google-docs spreadsheet and save it onto your computer? Then just
double-clicking on it should open it in Calc.
Google-docs uses the same native format as LO but both can save as .xls or .xlsX (MS formats) and
Google-docs might do that by default. If Google-docs does that instead of saving in native .odS
then you can probably choose "OpenDocument Format" from Google-doc's "Save As ... " menu.
Double-clicking on the .ods almost definitely opens the file in Calc.
Alternatively if it has saved as .xls or .xlsX then right-click the file and choose "Open With" and
then try to find Calc or LibreOffice in that menu. This approach is slightly different in
different OSes but is roughly the same in all except Apples.
A similar alternative is to open Calc (or just LibreOffice) and then drag&drop the file onto it.
This approach will definitely work whatever format it's in unless something really weird is going
on in which case tells us and we might be able to figure it out.
However i have a feeling that you don't want to download the file at all and just want LO to
dynamically read the Google-docs spreadsheet while other people are editing the google-docs
spreadsheet. If so then i think there is a far better answer but it involves using Base at your
end and having a proper database on a server somewhere.
So, the question is do you want to do this with static data (as in my first 4 paragraphs), or
dynamically changing data?
Regards from
Tom :)
________________________________
From: Michael Reich <reich.mikey@gmail.com>
To: users@global.libreoffice.org
Sent: Thursday, 27 September 2012, 18:24
Subject: [libreoffice-users] Can Calc read/import data from Google Docs?
I'm trying to figure out if I can have a Calc (OpenOffice or LibreOffice) spreadsheet "import"
data from a Google Docs spreadsheet. The online assistance via google search is very confusing and
seems mostly oriented toward importing data to Google Docs. What I want is a local sheet that can
pull several cells of info (like names and addresses) from a Google Docs spreadsheet, but I can't
figure out what function and syntax, if any, can do this in OO or LO. Is this possible to do? If
so, I apparently need the "idiot's instructions."
-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.