Calling Google Spreadsheet functions from Google A

问题:

This question already has answers here:

Using built-in spreadsheet functions in a script (3 answers)

Closed 2 years ago.

Is it possible to use a Google Spreadsheet function in a Google Apps Script?

There is a ton of documentation about going the other way around, i.e. using Google Apps Script functions in Google Spreadsheets, but I haven't found an answer to this.

For example, let's say want to calculate a standard deviation on some data in a JavaScript array. Can I use Google Spreadsheets' STDEV function?

回答1:

Unfortunately not it seems. It has been discussed/suggested/requested over the years, but I have never seen any announcements from google regarding this.

(I have edited this post to be less authoritative since I cannot readily find many resources in support of my point. However, I have been following the boards for over 3 years and have come across it at times.).