Love seeing Google Spreadsheets used like this. Many MVP 'products' would do well to be a 'simple' spreadsheet first.
sheetsee.js is great for visualizing data in these spreadsheets too (can make a graph on a website from data in a google spreadsheet in a few lines) https://github.com/jlord/sheetsee.js
And Google Sheets would do well to improve the add-on development experience. It's absolutely awful and the documentation rarely tells you what you actually need to know
Totally agree! Did run into a lot of problems developing the Add-On. For some issues, even bug reports exist that are many years old. So for me, it sadly kind of seems like Google totally lost interest.
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
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).
sheetsee.js is great for visualizing data in these spreadsheets too (can make a graph on a website from data in a google spreadsheet in a few lines) https://github.com/jlord/sheetsee.js