Re: [libreoffice-users] Can Calc read/import data from Google Docs?

But it's so easy!

In Google Docs open the spreadsheet and select File, Download as, ODS.
That's it!

John

On 27 September 2012 20:57, Tom Davies <tomdavies04@yahoo.co.uk> wrote:

> 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

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