Google Blogoscoped

Forum

Spreadsheets Update  (View post)

Luka [PersonRank 10]

Thursday, September 6, 2007
10 years ago8,834 views

3 new functions in Spreadsheets with a cool one that uses Google Sets to auto fill data in cells, another pretty good to import data from allmost every (web) data format and one useless to sum numbers...

I seems that Google mades a mistake in their snapshoot (you can see the bug here : docs.google.com/support/spread ...)


google.com/help/hc/images/docs ...



Post in french with pictures : zorgloob.com/2007/09/nouveauts ...

James Xuan [PersonRank 10]

10 years ago #

Nice!

Above 2 comments were made in the forum before this was blogged,

Pau Tomàs [PersonRank 10]

10 years ago #

Google should add a Translate function :)

spreadsheets.google.com/ccc?ke ...

Pau Tomàs [PersonRank 10]

10 years ago #

Oh! Seems like there are some problems with international characters when using the importHTML functions. Try to use the previous spreadsheet to translate from english (en) to japanese (ja).

ranon [PersonRank 1]

10 years ago #

Google spreadsheets is a work in progress. It is not as good as Excel. Though with the autofill and the options for locale it is getting better.

Philipp Lenssen [PersonRank 10]

10 years ago #

MagicFill is still mostly broken here today.
I enter

   ibm
   google
   microsoft

and it returns...

   ibm
   google
   microsoft
   design
   webdesign
   ajax
   css
   tools
   software

No desert for Google Spreadsheets! Google Sets is much better than this, even though it's supposed to be the data source.

André H Banen (a.k.a. Ahab) [PersonRank 1]

10 years ago #

'the functions for importing are called importRSS, importHTML and importData, but googleReader instead of the more obvious “importFeed”'

The GoogleReader function still is recognized, but in the help and the function reference it has been replaced by identically(?) working ImportFeed (sic).

ImportRSS is not recognized as a function by Google Spreadsheets, but ImportXML is.

The GoogleGeoCode function that appeared for a short time (as a function name only) in the function reference is not recognized by Google SPreadsheets. It was never recognized b.t.w. but was described by the short description GoogleGeocode(location, latOrLng) which makes one wonder what arguments this function should use.

Mrrix32 [PersonRank 10]

10 years ago #

[put at-character here] Philipp : For this query I now get

ibm
google
microsoft
apple
intel
linux
adobe
yahoo
oracle
sun

This thread is locked as it's old... but you can create a new thread in the forum. 

Forum home

Advertisement

 
Blog  |  Forum     more >> Archive | Feed | Google's blogs | About
Advertisement

 

This site unofficially covers Google™ and more with some rights reserved. Join our forum!