Calling Google Spreadsheet functions from Google Apps Scripts

google-apps-script, google-sheets

Solution

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.).

Problem

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?

Original source

Related problems