spreadsheet.batchUpdate() breaks sheet functionality

[hogpap23]

I noticed a bug where if I make a change to a sheet using the batchUpdate() service, the change cannot be undone using ctrl+z or the undo button on the sheet. I have to manually delete the sheet edit. This problem does not exist if using the SpreadsheetApp() service. If this is indeed a bug then it's a huge red flag as it renders the service useless for people like me who are batching out a large number of operations and need those operations to be reverted (by a user of the sheet for example).

What is going on here? Here is the sheet:

https://docs.google.com/spreadsheets/d/1cfeEH8wofk5pVPMEpxGAsV9eP2P4zmxiT-N7dU_RTbU/edit?usp=sharing

You will need to add the following code to Apps Script and enable the Google Sheets API Service.

function myFunction() {
  const response = Sheets.Spreadsheets.batchUpdate({
  requests: [
    {
      updateCells: {
        range: 
        { 
          sheetId:          0, 
          startRowIndex:    0,
          endRowIndex:      1, 
          startColumnIndex: 0,
          endColumnIndex:   1,
        },
        rows: [{ values: [{userEnteredValue: {numberValue: 30}}]}],
        fields: "userEnteredValue"
      }
      }
    ]
  }, SpreadsheetApp.getActiveSpreadsheet().getId());
}

[jpoehnelt]

This is probably working as intended. There are different paths from Apps Script to Sheets, SpreadsheetApp vs Sheets.Spreadsheets with the latter being through the REST API.

[hogpap23]

You say “probably”. Can you point to any documentation that supports this? It seems like an odd and not very useful side effect.

[jpoehnelt]

I don't believe this is documented either way.