Posted 8 September 2017, 2:58 pm EST
I am trying to access instance of the CustomFunction associated with a cell. For that I found I can use FunctionExpression.
But for CustomFunction FunctionExpression's Function property is Null - whereas if its not a custom function, I can access Function property.
I read in another forum post that Farpoint uses late binding for Custom Function. My question is, is there any way I can have this Function property set to correct instance for the custom function as well ?
FarPoint.CalcEngine.Expression ex = fpSpread1.ActiveSheet.GetExpression(rowIndex, columnIndex);
if (ex != null && ex is FarPoint.CalcEngine.FunctionExpression)
FarPoint.CalcEngine.FunctionExpression fex = ex as FarPoint.CalcEngine.FunctionExpression;
// fex.Function is null here for CustomFunctions.