There are 2 ways forward, and probably in this order: A) consider whether the Google Apps Script API would help for your scenario http://code.google.com/googleapps/appsscript/class_sheet.html#hideColumn (if so, continue discussion on the relevant forum - http://www.google.com/support/forum/p/apps-script?hl=en). Scripts execute on the server-side in response to edit or open events in the sheet itself or prods from an HTTP client - http://code.google.com/googleapps/appsscript/guide_user_interfaces.html#RunDecision
B) put together a proposal about it, submit a feature request and get people to vote for it ... http://code.google.com/a/google.com/p/apps-api-issues/issues/entry?labels=Type-Enhancement,Priority-Medium,API-Spreadsheets A good proposal for option B would be interesting. Think 'spreadsheet declaration language' and you'll be on the right track ... (and then downgrade/shoehorn this to an ATOM representation). It should probably solve more than just column-hiding, but address a variety of non-cell attributes of a spreadsheet - named ranges, column widths, frozen rows, etc. good luck, David. On Thu, Jun 9, 2011 at 11:52 PM, Abdullah Akbar <[email protected]>wrote: > This is bad news. :(
