IssueTracker

Generated Metadata

• Summary: Users are reporting a "TypeError: a.keys(...).va is not a function" error when using the sort() method in Google Sheets Apps Script. The issue appears to be intermittent and may be related to specific environments.
• Tags:
  • apps-script
  • spreadsheet-service
  • typeerror
  • sort
  • intermittent-error

Additional resources:

• https://stackoverflow.com/.../google-apps-script-keeps-throwing-function-n...
• https://stackoverflow.com/.../response-getselectedbutton-is-not-a-function
• https://stackoverflow.com/.../google-apps-script-typeerror-data-foreach-is-n...
• https://stackoverflow.com/.../error-message-typeerror-spreadsheetsub-getas-...
• https://stackoverflow.com/.../push-is-not-a-function-error-in-google-app-sc...

You can subscribe to this issue by clicking the star ⭐ button.

Another user has reported that the clear() method also gets the same error.

Their script:

function save() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sell = spreadsheet.getSheetByName("銷貨單");
  var storage = spreadsheet.getSheetByName("銷售資料");
 
  var array = sell.getRange("b2:i16").getValues();
  var last = storage.getLastRow() ;
  storage.getRange(last+1,1,15,8).setValues(array);  //  method getRange(row, column, optNumRows, optNumColumns)
 
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('b2:b16').activate();
  spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
  spreadsheet.getRange('b2').activate();
}

Reference: Reply to TypeError: a.keys(...).va is not a function Error appeared today without any changes to my script.

I have reported this to the engineering team and future updates will be shared here. Thank you for your patience.

A rollback is occurring. I'll update when I have more information.

The rollback should be completed.