Custom Function
Custom Function
FlexSheet allows user to add custom functions by the client addFunction method.
Features
Custom Function
FlexSheet allows user to add custom functions by the client addFunction method.FlexSheet will parse the cell reference parameter such as 'A1' or 'A1:B2' to a CellRange instance for the custom function.
FlexSheet also allows user to process non-supported functions met in cell expressions by the client unknownFuntion event.This event will pass the 'UnKnownFunctionEventArgs' to customer. This 'UnKnownFunctionEventArgs' provides the function name and the evaluated values list of the parameters.User can set the 'value' field of 'UnKnownFunctionEventArgs' to customize the missed formula result.Otherwise the missed function will return the default error message: 'The function "funcName" is not supported in FlexSheet yet.'.