IssueTracker

Hello,

Thank you for the details. This has been forwarded internally.

Best regards

Also getting this, but I can narrow it down to one line.

I have tried different workarounds based on other responses. This is a simplified script, basically, if I comment out setNumberFormat and setNumberFormats then it works, but no matter which one I use, the moment I use it I get the error.

Sep 14, 2020, 7:06:14 PM Error Service Spreadsheets failed while accessing document with id 1w-U7-Zh6bcY9_d0EARN8qes6k72zJy5Q2Nw-70tkYOM.

function onEdit_projections_UsageUnit(e) {
  // the sheet that we are generating the dropdowns on
  const range_check = (row, column) => (column === 2 && 1 <= row && row < 10);

  if (!(
    e.value != null
    // value has changed
    && e.oldValue !== e.value
    && e.source.getSheetName() === SHEET_PROJECTIONS
    && range_check(e.range.getRow(), e.range.getColumn())
  )) {
    return;
  }
  Logger.info('onEdit_projections_UsageUnit activate');
  
  // Option i
  // const sheet = e.range.getSheet();
  // Option ii
  const sheet = e.source.getSheetByName(SHEET_PROJECTIONS);
  
  // const sheet = SpreadsheetApp.getActiveSpreadsheet();
  
  Logger.info(`onEdit_projections_UsageUnit sheet ${sheet.getSheetName()}`);
  
  const mapRange = sheet.getRange('D3:9');
  const mapColumns = mapRange.getNumColumns();
  Logger.info(`onEdit_projections_UsageUnit mapRange ${mapRange.getNumRows()}:${mapColumns}`);
  
  const modelRange = sheet.getRange('C3:C9');  //mapRange.offset(0, -1, mapRange.getNumRows(), 1);
  const models = modelRange.getValues();
  
  Logger.info(`onEdit_projections_UsageUnit models (${models.join(', ')})`);
  
  for (const [index, [model, ]] of models.entries()) {
    Logger.info(`onEdit_projections_UsageUnit each:${index} model:${model}`);
    
    if (model === '') { 
      // wipe out formatting.
    } else if (true) {
      
      // option A:
      //const rowRange = mapRange.offset(index, 0, 1, mapColumns);
      // option B:
      const rowRange = sheet.getRange(`D${3 + index + 1}:${3 + index + 1}`);
      
      Logger.info(`onEdit_projections_UsageUnit each:${index} range:${rowRange.getA1Notation()}`);
      
      // option 1:
      //rowRange.setNumberFormat(`0.## blah`);
      // option 2:
      const sploosh = [new Array(mapColumns).fill(`0.## blah`)];
      rowRange.setNumberFormats(sploosh);
      Logger.info(sploosh);
    }
  }

  Logger.info(`onEdit_projections_UsageUnit done done`);
}

Any news on this?
I am experiencing the same issue.
The last notification mentions a timeout in the Drive service (not in Spreadsheet service):
Drive service timed out opening the document with ID ...
(This is my own translation since I receive notifications in Dutch).

I'm having the same issue.

(Every 1 minutes trigger)

function myFunction() {
  // create data
  let data = [];
  for(let i = 0;i < 1000;i++){
    data.push([1,2,3,4,5,6,7,8,9,0]);
  }

  //write spreadsheet
  const spreadsheet = SpreadsheetApp.openById("**************");
  const sheet = spreadsheet.getSheets()[0];
  sheet.clear();
  sheet.getRange("A:A").setNumberFormat('@');
  sheet.getRange(1, 1, data.length, data[0].length).setValues(data);

  console.log("complete");
}

Recently I get this error with charts, similar as reported above here and here. This only happens for charts which have a right vertical axis. This is a very recent issue (started last week) for me in daily run scripts, as such I believe it to be a different bug from what has been reported here originally. I have created a detailed bug report here. Please star my report if you experience the same issue.

Temporary workaround: change any right vertical axes to left vertical axes (obviously this won't work if you need both axes).

I am receiving the same error in multiple script implementations anytime I call sheet.insertChart().

Here is the sample sheet to reproduce the error

To reproduce the error, from the custom menu item select LAD Options/Build Dashboards/Build Simple Dashboard

The error is thrown on line 797 of the Dashboards/DashboardBuilder.gs file

What should happen is that 4 charts should be created on the Simple Dashboard Sheet, but instead it is throwing the exception described above

This script has been working for years, but has suddenly started producing this error within the last month