1

In VB Script of Excel Macro Module , I can call excel formula in script for example:

iRow = application.match(a,b)

But in Google Spreadsheet, How Can I call spreadsheet formula by Javascript?

Henrique G. Abreu
  • 17,406
  • 3
  • 56
  • 65
maomifadacai
  • 357
  • 2
  • 4
  • 17
  • Possible duplicate of [Is there a way to evaluate a formula that is stored in a cell?](http://stackoverflow.com/questions/16303680/is-there-a-way-to-evaluate-a-formula-that-is-stored-in-a-cell) – Rubén Dec 05 '16 at 13:08

1 Answers1

2

It's not possible. See this enhancement request on the issue tracker.

You have to either implement it yourself (e.g. a match formula is very trivial) or write the formula somewhere on the spreadsheet and fetch its result.

Henrique G. Abreu
  • 17,406
  • 3
  • 56
  • 65