|
|
|
|
|
|
by janober
3033 days ago
|
|
|
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). |
|
|