I have a strange issue. It would be very kind of you to comment on it.
I am using your addin where i first create the AddinX object which looks something like the following
static AddinX xai_create_handle( Function12().Arg().Uncalced().category().FunctionHelp() );
then the actual c++ function (lets call it Cfunc() )is called which does the computation.
The computation takes a little time and eventually creates a object. The object handle is the output of the Cfunc().
In excel whenever i hit the little funciton wizard button it opens up the GUI with the function arguemts listed. Now as I am trying to input
the arguments of the function in that GUI box the control goes through the Cfunc() routine trying to do the computation.
As a result even before i try to put in all the arguments Cfunc() gets computed resulting in a lot of exceptions (which i throw from inside my
code when the arguments are not correct).
Also this behavior kind of slows down everything becuase the Cfunc() is trying to computed unnecessary number of times.
I thought the .Uncalced() is supposed to stop this behaviour from happening, but surely I am wrong.
I have automatic computation switched off in excel options but even then this behaviour happens.
All I want is the the function to compute only when I hit "ok" button of the GUI or when i hit enter.
Is there a way to achieve this ?