diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


Google Docs Chessboard

The under posted chessboard, is basically a Google Spreadsheet embedded using the advanced publishing options, the king and rook automatically switch their places around every hour.

There’s really no use to that, it’s just a thought experiment. To reproduce this, first create a new Google Docs spreadsheet. Now for every second field use a black background color and white foreground color, and copy some nice Unicode characters, like the chess pieces, into the cells. Publish the document as webpage and copy the URL of that page. Now go back to edit the original document, hit F2 in a cell and use the new importXml formula – which can be used to reference any kind of external HTML or XML – but reference the spreadsheet you are currently working on itself using the just-published URL (line breaks added):

        "//td[@class='g s1']/text()")

Additionally, the left field’s XPath – the second parameter in above function – will grab the value from the right field, and vice versa. You guessed it: this will cause the king and rook to continuously change places!

Google, Google Docs, Google Docs & Spreadsheet, Chessboard

Source:→ Blogoscoped

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...