TdxSpreadSheetFunctionInfo.IsValid Method

Identifies if the function signature is ready for use in formula expressions.

Declaration

function IsValid: Boolean;

Returns

Type
Boolean

Remarks

The spreadsheet function repository contains both implemented and reserved function signatures. Spreadsheet import and export routines use reserved functions to load and preserve all unimplemented function calls in formula expressions for subsequent document save operations, so third-party applications can open a re-saved document without errors. Note that spreadsheet controls return the ecName error as the result of all expressions with unimplemented function calls.

This function returns False if the function signature is reserved (that is, has no implementation routine); otherwise – True.

Note

The AvailableInContainerControls field value defines whether the “Expression Editor” dialog lists the valid function signature under its category.