Timeline for Parse and format data on Google Sheets
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 11, 2015 at 13:25 | comment | added | CalPal | It looks like I need to set the dataRange variable to only the cells I need to be overwritten in order to avoid all of the formulas on the rest of my sheet being replaced with their values? I would rather not add code to the script to setFormula for every cell that contains a formula on my sheet, as there are quite a few. | |
| May 11, 2015 at 13:13 | comment | added | CalPal | I am definitely interested in the "template" or "config" sheet idea as well, but I'm not exactly sure how that would work (might be a little over my head at this time) | |
| May 11, 2015 at 12:47 | comment | added | CalPal | Hi there! I really appreciate your suggestions. The only problem is that the sheet has many other formulas on it that are not written by the script, and your code seems to be overwriting these formulas and replacing them with plaintext values. Any workarounds? | |
| May 8, 2015 at 4:02 | comment | added | Mogsdad | @Snowbody - yep! And if feasible, it would be good to move the "template" cell definitions right out of code altogether, and make them data. Maybe in a "template" or "config" sheet, and load the control data structure from there. | |
| May 8, 2015 at 2:15 | comment | added | Snowbody | You could use this approach (which is faster) and still use a data structure to represent all the cell values being set (which would lead to cleaner, more maintainable code). | |
| May 7, 2015 at 21:22 | history | edited | Mogsdad | CC BY-SA 3.0 |
added 91 characters in body
|
| May 7, 2015 at 20:20 | history | edited | Mogsdad | CC BY-SA 3.0 |
Added helper functions referenced in original answer
|
| May 7, 2015 at 19:58 | history | answered | Mogsdad | CC BY-SA 3.0 |