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 […]

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

=importXml(
        "http://spreadsheets.google.com/
        pub?key=pvm6FPiylicJhtAc45XcYbg",
        "//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