问题:

Is it possible to use Google Apps Scripts offline? I have a Google Spreadsheet with scripts to keep things updated as I add data. I do not need to edit the scripts, but I need to be able to run them for my spreadsheet to make sense.

If not, are there any speadsheets applications, that would allow for easy porting of scripts?

回答1:

You can not because Google Apps Script run in Cloud. But you can use New Google Sheets offline.

回答2:

I don't think so. The new Google Sheets work offline (if you've got offline access enabled) but I've just a little experiment and the script I've attached to the sheet doesn't run (I set it up to trigger on a cell edit and display a msgBox).

回答3:

With triggers, your sheet can continue to be edited while you are offline. Once you are back you should receive the changes.

回答4:

I haven't used it yet, but it looks like clasp can help you work on the scripts offline. Once the scripts are local to your computer, you can also write targeted and directed unit and integration tests so you won't need the spreadsheet to verify your functions.