I'm trying to cause a 3rd party function (CRYPTOFINANCE()
) to update whenever I manually trigger an update. Currently it updates any time I clear the cel contents and hit Undo. So my thinking is to simply create a script that selects the cells I want to update, clears them, and hits undo.
Unfortunately I can't find any way to execute an undo via script. Mostly I find references to it not even existing as a function, however I found reference to model.undo()
which sounds like what I need. I just can't figure out how to make it work.
My other thought was maybe there is a way to just select the Undo option from the Edit menu via script, but I have a feeling that's not possible either.
Can anyone suggest a way to Undo via script that doesn't involve using a secondary sheet to store the "undo" data?
CRYPTOFINANCE()
from an add-on, or is it a function you have created?