|
| Recent
Articles |
Marissa Mayer Speaks
Google VP of Search Products & User Experience, Marissa Mayer, handled the morning keynote for SES San Jose and revealed her love for a certain social networking service. (Our on-scene WebProNews staff has...
Hitwise Internet Usage Trends Widget
Hitwise, announced the launch of a new Hitwise Widget featuring online usage trends from Hitwise To Go, an RSS-based service that provides statistics on online...
Britain's Floods Get Mapped By Google
Over the past week or so, Britain has been hit by some really nasty flooding - the worst in 60 years. Fortunately, no deaths or serious injuries have been reported, and it’s possible that Google helped bring about this...
.
Does Second Life Need Another Life?
Wired Magazine has pronounced Second Life dead. This is the inevitable backlash against anything that draws a great deal of hype, but in this case I think there...
Windows Live OneCare 2.0 Beta Launched
Participants in the beta of Windows Live OneCare 2.0 had their software updated to the new beta over the last day or so. So, what's different? Well, you're supposed to install OneCare on all your computers, then manage...
|
|
09.06.07
Google Spreadsheets Adds Import Functions, Auto-Fill
 By
Philipp Lenssen
Google Spreadsheets just got a bit more powerful. There are four new cell functions to automatically import external data: importXml, importData, importHtml and googleReader.
Another new feature in Spreadsheets is auto-filling of cells. Enter "Monday" and "Tuesday" in two cells, select them, and click the blue dot on the cell edge to drag it over subsequent cells. They will now read "Wednesday", "Thursday" and so on. You might know this from other spreadsheet applications, but what's more, if you hold down Ctrl when you perform this auto-fill, Google will poll data from Google Sets to automatically complete almost anything (at least that's the theory).
I think auto-filling based on Google Sets is a really cool idea, though during my tests that feature was very unstable, didn't show a load bar (so you won't know if there's something still being polled from Google Sets), and mostly didn't work at all... or returned results much less relevant than what Google Sets returns, incidentally.
Google seems to be in a real hurry to get these feature updates out the door; the announcement post contains broken links, and the help files are somewhat sparse and hastily formatted, and contain errors. (For instance, the screenshot showing the auto-filling for "Monday - Tuesday - Wednesday" continues with "Monday - Tuesday - Wednesday" again instead of showing what is actually filled, "Thursday - Friday - Saturday".)
And sigh, that's inconsistent: the functions for importing are called importRSS, importHTML and importData, but googleReader instead of the more obvious "importFeed" (as that's what it does). I hope the Google OS programming framework doesn't go the way of PHP, a language which puts a burden on programmers because its naming rules and parameter order changes from function to function.
[Thanks Luka!]
Comments
About the Author:
Philipp Lenssen from Germany, author of 55 Ways to Have Fun With Google, shares his views & news on the search industry in the daily Google Blogoscoped.
|
