setActiveSelection() does not work on Android

K G 0
Viewed 38

This code works fine on the computer sheets but does not work on android sheets.

  var range = sheet.getRange("A1");
  sheet.setActiveSelection(range);

So basically, I want cell A1 Alway to be selected even if I click any other cells. When I select the different cells on the computer google sheet, it takes me to Cell A1 and selected after a few seconds, which works fine. But when I select the different cell on Android Sheet, it doesn't take me to cell A1 and is not selected. Any suggestion would be helpful, and thank you in advance.
The whole code is

    function onEdit(e) 
{
  var s = SpreadsheetApp.getActiveSheet();
  var data = s.getDataRange().getValues();
  var data_len = data.length;
   
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];

  var range = sheet.getRange("A1");
  sheet.setActiveSelection(range);
   
  for(var i=0; i<data_len; i++) 
  {
    if(data[i][0] == "HERE!") 
    {
      s.getRange(i+1,2).setValue("Yes");

    }
  }
}
mobile triggers google-sheets google-apps-script
1 Answers

There does not seem to be any need for it as it is not currently being used for anything and it serves no real purpose.

function onEdit(e) {
  const sh = e.range.getSheet();
  var vs = sh.getRange(1,1,sh.getLastRow(),2).getValues();
  vs.forEach((r,i) => {
    if(r[0] == "HERE!") {
      sh.getRange(i + 1, 2).setValue("Yes");
    }
  });
  sh.getRange("A1").activate();
}
user30hu0
Related