Skip to main content
10 events
when toggle format what by license comment
Jun 3, 2014 at 20:54 history edited Jacob Jan CC BY-SA 3.0
added small error handling
Jun 3, 2014 at 20:21 history edited Jacob Jan CC BY-SA 3.0
added two features: unlimited ranges and from different sheets
Jun 3, 2014 at 13:58 comment added Aaron Oh you updated the code. Thank you very much it works now!
Jun 3, 2014 at 13:54 comment added Aaron Right. The spread sheet I have is in the old version. I have to find a way to copy the sheet into the new version without destroying the format and calculations which is proving to be impossible so far.
Jun 3, 2014 at 13:45 history edited Jacob Jan CC BY-SA 3.0
this piece of code can coupe with both old and new sheets
Jun 3, 2014 at 13:11 comment added Jacob Jan @Aaron That's most probably due to the fact that you use the old Google Spreadsheets....
Jun 3, 2014 at 13:07 comment added Aaron It works on newly created documents. It must be something about the sheet I am trying to use. There was no custom code on the sheet so it can't be variable name duplicates.
Jun 3, 2014 at 13:01 comment added Aaron The code works on the example doc you showed me but will not work on the document I am attempting to use. Each time it gives me the error "This operation is not supported (line 2, file "Code")" I can't see any reason it would not work but maybe I am missing something.
May 21, 2014 at 12:15 vote accept Aaron
May 20, 2014 at 21:23 history answered Jacob Jan CC BY-SA 3.0