For your purpose you don't really need to have the entire spreadsheet functionality available, do you? If so, to easen the load when accessed via tablets, you could try serving the interactive functionality and charts outside of the spreadsheet.
This would be a combination of: - exporting the scripts to be accessed as services ( http://code.google.com/googleapps/appsscript/guide_user_interfaces.html#RunDecision ) - export the charts by embedding them into an html page of yours and accessing the spreadsheet data via queries ( http://code.google.com/apis/chart/interactive/docs/queries.html ). In this way you'd rely on Google Spreadsheets to host and manipulate your data, but not on it for the view/presentation part. Now, I'm not sure how much more complicated your case becomes if you use the above suggestions. It looks like it's approaching a complexity where you should consider whether it's worth bending Google Spreadsheets to fit your case or it might be just easier to code a small custom app for the case at hand. -- R. On 15 September 2011 15:29, Megan Cunniff <[email protected]> wrote: > Thank you both for your helpful responses! Riccardo's solution was > indeed very light on code, and easy to work out. > > Bad news was that the in-spreadsheet chart plus the script functions > ended up lagging a bit too badly on the iPads we tested with, so we'll > probably have to end up looking into other things. (If anyone knows of > any other HTML5-based slash iPad-suitable alternatives, I'd love to > hear back...though, heh, I feel bad writing that on a Google > forum...) > > Still, very good practice and now I know about the option for other > things! Thanks again! > > -M > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
