Hi.
I am trying to figure out how to evaluate a formula string. If I have
selected a single cell I can get to the formula via
ThisComponent.GetCurrentSelection.Formula but I haven't been able to
find a way to evaluate that formula.
Excel VBA has the Evaluate() function - what is the equivalent in the
OpenOffice API ? I did look at com.sun.star.sheet.FunctionAccess but
that works only for a single function name and requires you to feed in
all parameters manually.
I am using this to build a function that can return more descriptive
error messages to the user when a formula returns "#VALUE!" - at least
when the formula involves code in my add-in.
Cheers
-- Jan Holst Jensen
