TdxSpreadSheetFunctionsRepository Class

Stores all function signatures available to the spreadsheet formula engine.

Declaration

delphi

TdxSpreadSheetFunctionsRepository = class(
    TcxObjectList
)

Remarks

The spreadsheet formula engine parses, evaluates, and calculates Microsoft Excel-compatible formula expressions and expression-based conditional formatting rules (“Cell Is“ and “Expression“) both in spreadsheet and container controls.

The TdxSpreadSheetFunctionsRepository class implements a repository that stores all function signatures (both implemented and reserved) available to the spreadsheet formula engine. The class has the following members that you can use to:

Access individual function signatures (GetInfoById, GetInfoByName, and Items).
Manage function signatures (Add!f----), AddUnknown, and Remove).
Clear the repository (Clear).
Identify if the repository contains at least one implemented function that belongs to a specified category (HasFunction).
Update name tokens from resource strings for all stored function signatures (TranslationChanged).

Call the dxSpreadSheetFunctionsRepository global function to access and manage the spreadsheet function repository.

Inheritance

TObject TList TcxObjectList TdxSpreadSheetFunctionsRepository