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...
tobydimmick
Mar 27, 2025Copper Contributor
This is a fairly substantial shortcoming compared to the `Application.Evaluate` function available in the COM API. This can make updating a COM addin to Office.js much trickier than necessary.