Undocumented cell cache and non-deterministic functions

[kAlvaro]

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.:

="XYZ" & RANDBETWEEN(100, 100000)
="Updated on " & TEXT(NOW(), "d/mm/yyyy hh:mm:ss")

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.