On 1/19/07, David Huynh <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm experimenting with creating an exhibit directly from a Google > spreadsheet.
I've played around a lot with the Google Spreadsheets ode of operation during the weekend, unfortunately mostly with data I can't publish (address details for my choir, for instance). It's really a great and fairly easy way of making data go live, especially with the automatic publication feature. Some surprises, gotchas and thoughts along the way: * The first column always gets to be the label property, regardless of what you name it. * You can't assign the first / label column to be the number type, so if it happens to be numerical, you get radical and unexpected sorting. * The default TileView in the prior-to-customization exhibit-view-panel is immensely useful, especially when you're working with lots of spreadsheets and haven't really committed to final names of columns. Being able to visualize and work with the data without having to freeze it like this until you're ready for it is an excellent productivity boost. * It would similarly be *very* useful to get a default TabularView as well, listing all columns available, in the order they are listed. I tried peeking at what it would take to implement that on my own, but didn't get very far into it; feel free to drop me some suggestions if you don't have the time to dig into it yourself, David. I'm polishing up the last tweaks for an "instant Google Spreadsheets Exhibit" page at the moment, where you just paste the feed URL and it loads and renders an exhibit to it, and it would be even greater with Table view in place too. -- / Johan Sundström, http://ecmanaut.blogspot.com/ _______________________________________________ General mailing list [email protected] http://simile.mit.edu/mailman/listinfo/general
