In a spreadsheet I can enter =SIN(45)+123
in a cell, and it will be evaluated.
How can I evaluate spreadsheet functions within a custom function, something like an "eval" function that would work like this :
function myFunc() {
return Sheet.eval("=SIN(45)+123")
}
is it possible ?
Note that I don't care about the SIN
function in particular, what I want is to have access to the complete arsenal of spreadsheet functions (PMT
, QUERY
, NPER
, etc..)