Hacker News new | ask | show | jobs
by TremendousJudge 3033 days ago
You developed this addon? Lots of respect, my development experiences were really discouraging, and I was very happy when I didn't have to do it anymore. I can't begin to imagine what it must have taken to develop something so complex
1 comments

To be honest, was not that complex. The problem was just that Google Script made stuff that I expected to take 5 minutes to code take days in the end. For example, simply refreshing the value of a cell. I thought I simply gonna call some kind of method and it will take care of it. Sadly was quite the opposite. Took me a week to figure out that to achive that, I have to: 1. save the formula of the cell 2. remove the formula from cell 3. set the focus to another cell 4. set the formula in the cells back to their former value 5. activate the cells again And in the end, they then have such additional gimmicks like that they use different value separators in the formulas depending on your country (some use comma others semicolons).
80/20 rules sadly.