CODEWITHSUNDEEP
google-sheetsgoogle-apps-script
michaeldon
michaeldon

Reputation: 507

Rhino Runtime and V8 together?

Is there a way to have two separate script projects connected to a spreadsheet, one which runs in V8 and one which runs in Rhino?

I have a function that doesn't run in V8 because of a known V8 issue. I was able to make a separate standalone Rhino runtime script and run it from a web app but now I can't find that script anymore as it's not connected to my spreadsheet. It would be way easier if you could have rhino and V8 in two projects attached to one spreadsheet.

Upvotes: 0

Views: 148

Answers (1)

Wicket
Wicket

Reputation: 38416

As of February 26th, 2025, the current Google Apps Script IDE doesn't allow the creation of multiple Apps Script projects in a single container.

I have found an old spreadsheet with two projects that require some changes, so I tried to create a copy to keep as a backup. The copy only included the most recent project.

On the other hand, a few days ago, the Google Apps Script Release Notes page was updated to include the following (link)

As of February 20, 2025, the Rhino runtime is deprecated. Scripts running on Rhino will continue to function until January 31, 2026, after which they will no longer execute. Please migrate your scripts to the V8 runtime before this date. Refer to Migrate scripts to the V8 runtime.

Regarding this question, the above means that having two projects connected to the same spreadsheet, each using a different runtime, will soon not be viable.

Alternative

Create one or two stand-alone Apps Script projects and open(file), openById(spreasheet_id), or openByUrl(spreadsheet_url) instead of getActive() / getActiveSpreadsheet(). You might want to create a folder and to keet together the spreadsheet and the related Apps Script projects.

Upvotes: 0

Related Questions