Is there anyway to control in which order different custom functions are invoked?
I have two custom functions, MyCustomFunctionA and MyCustomFunctionB.
I know that the order of invocation is implicitly given be dependencies between cells.
For instance, if
A2 contains “=MyCustomFunctionA(A1)” and
A3 contains “=MyCustomFunctionA(A2)”
then MyCustomFunctionA in A2 will be called first, then MyCustomFunctionA in A3 will be called, because the way the cells depend on each other.
However, I want to make sure that this happens:
A2 contains “=MyCustomFunctionB(A1)” and
A3 contains “=MyCustomFunctionA(A1)”
In this case, MyCustomFunctionA in A3 should be called before MyCustomFunctionB in A2.
Or rather, all MyCustomFunctionA:s should always be called before all MyCustomFunctionB:s.
Is this possible?