You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When reading spreadsheets, there is apparently a file cache somewhere, that I couldn't find referenced in the documentation. This is normally great, but it can be a problem for non-deterministic formulas, e.g.:
If you process the same exact file several times, in different script executions, you get the same random integer and the same (outdated) current time.
It'd be great if documents would warn about this, and maybe even have a flag to skip cache whenever needed.
The text was updated successfully, but these errors were encountered:
When reading spreadsheets, there is apparently a file cache somewhere, that I couldn't find referenced in the documentation. This is normally great, but it can be a problem for non-deterministic formulas, e.g.:
If you process the same exact file several times, in different script executions, you get the same random integer and the same (outdated) current time.
It'd be great if documents would warn about this, and maybe even have a flag to skip cache whenever needed.
The text was updated successfully, but these errors were encountered: