TdxSpreadSheetFunctionInfo.Name Field

Stores the function signature’s Microsoft Excel-compatible name token.

Declaration

Name: string

Field Value

Type
string

Remarks

An alternative function name token is required to load and preserve all “unknown” function calls in formula expressions within a loaded spreadsheet document, that is, the function tokens that have no corresponding signatures (including those without implementations) registered in the spreadsheet function repository. The spreadsheet formula engine uses the Name field value as the function signature’s name token if no pointer to a resource string is assigned to the NamePtr field.

XLS import routines call the TdxSpreadSheetFunctionsRepository.AddUnknown function to register and preserve external references and unrecognized function name tokens for subsequent document save operations, so third-party applications can open a re-saved document without errors. The function’s AName parameter value initializes the Name field of a newly created function signature.

The TdxSpreadSheetFunctionsRepository.Add procedure calls the UpdateInfo procedure for a newly created function signature to initialize the Name field to the uppercased resource string accessible via the NamePtr field.

Note

The ToString function uses the Name field value as the function signature’s name in the returned syntax prototype string.