Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Spreadsheet: How can I leave the Script Editor open in another tab after refreshing a spreadsheet

Whenever I refresh a spreadsheet (after having changed some of its Apps Scripts code) with CMD - R, Safari closes the script editor tab automatically.

How can I avoid that this tab is being closed?

like image 265
AlexR Avatar asked Nov 08 '13 14:11

AlexR


People also ask

What does Spreadsheetapp flush do?

flush() Applies all pending Spreadsheet changes. Spreadsheet operations are sometimes bundled together to improve performance, such as when doing multiple calls to Range.


1 Answers

Make an edit in the script, but don't save. Refresh the spreadsheet. The tab with the script will ask you if you want to close the tab, so say no. It won't close on you anymore after that.

Also, you can use Tools > Script Manager from the spreadsheet to run functions, or even run them directly from the script editor if you don't want to refresh.

like image 152
Fred Avatar answered Nov 15 '22 09:11

Fred