Possible to perform an “undo” via app script?

Question

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?

Answer 1

Google Apps Script hasn't the undo / redo commands.

NOTE: The Real Time API is not part of Google Apps Script and it's not included in the advanced services.

The alternative is to make the script to keep records of the changes made and if necessary use them to "undo" or "redo" the action.

Answer 2

If your objective is to refresh the function CRYPTOFINANCE() which is entered into any given cell in the sheet, your script would need to do just that.

Using the getActiveRange() method, you can programmatically target the cells that you want to refresh. Simply select the cells you want to refresh in the spreadsheet to store them in range with the getActiveRange() method.

var ss= SpreadsheetApp.getSheetById(id);
var sheet = ss.getSheets()[0];
var range = sheet.getActiveRange();

From range you can get each individual cell with this:

var cell = range.getCell(row, column);
// respectively to the range selected with 1, 1 being the upperleftmost cell.

To refresh that value, use the setValue method as follows:

cell.setValue('CRYPTOFINANCE(value)');

When that String is entered into the sheet, it will automatically trigger CRYPTOFINANCE() and refresh.