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...
To add on to this, I would like to see something that mirrors `Evaluate` in the COM API. Not solely limited to formulas. For example if given a cell reference, it would resolve that value