IssueTracker

function onEdit() doesn't perform the range activate() method when calling form onEdit event. Calling it from menu works as expected.


Sample script that reproduces the issue:

function onOpen(){
                                                       
  SpreadsheetApp.getActive().getSheetByName('Sheet2').activate();
}

What steps will reproduce the problem?
 1. Open a Spreadsheet with at least two sheets and one of them (not the first) called 'Sheet2' with the above onOpen script function into its script
or...
 2. Refresh (F5) the above Spreadsheet with at least two sheets and one of them called 'Sheet2' when not 'Sheet2' is activated and with the above onOpen script function into its script


Expected output:
 Spreadsheet sheet 'Sheet2' get active.

Instead:
 Nothing happen out of the normal behavior, as the activate() method was not called.

BUT...

If you call the onOpen function from a menu or assigning the function to a drawing on the sheet, the activate() works fine (Sheet2 get 'focus', is activated)

The function is called, execution transcript shows that and if you place two logs (one before, one after) both logs are shown in "Logging output".

(In this case) I'm quite sure that last week this works fine into the event call (I'm using this set focus into a specific sheet on... open, of course)


To subsequent readers: If you are also experiencing this issue, please
click the star next to the issue number. We prioritize issues with the
most stars.