Is it necessary to replace setActiveCell with getActiveCell or setActiveRange?

Question

I've been trying the new IDE that Google Apps Script provided and it seems the new editor marked one of my scripts as an error that needs fixing (in a form of suggestion).

My question is, is it necessary to replace spreadsheet.setActiveCell() with spreadsheet.setActiveRange() or spreadsheet.getActiveRange() ?

Did Google remove this command specifically? Because I couldn't find setActiveCell() on the Apps Script Reference anymore and it didn't appear as fill-in options when writing within the editor (even when I'm reverting to the legacy one).

Note that the script works fine as it is supposed to.

user_11861954 · Answer

Based on your new comment I understand that you want to know if .setActiveCell() would be removed and some alternatives if it does. As far as I can tell, there are no references to that method in the docs, so I strongly recommend you to get used to the alternatives. Some options are SpreadsheetApp.getActiveRange(), SpreadsheetApp.setActiveRange(), Spreadsheet.getCurrentCell() or Spreadsheet.setCurrentCell(). Please let me know if those choices are not enough in your implementation.

Is it necessary to replace setActiveCell with getActiveCell or setActiveRange?

1 Answers