Currently, it is not possible to pass a formula to the Office API and receive an evaluation of it. There are workarounds, like writing to an empty cell, or writing to a scoped name. Both solutions a...
This is an important method to have in our toolbox!