TdxSpreadSheetDefinedNames Class
A defined name collection in a spreadsheet control.
Declaration
TdxSpreadSheetDefinedNames = class(
TdxSpreadSheetObjectList
)Remarks
The class members allow you to do the following:
Create and modify defined names (Add, AddFromStream, and AddOrSet).
Create defined names from the active cell selection (AddFromSelection).
Improve application performance in case of batch changes made to defined names in a document (BeginUpdate and EndUpdate).
Identify the total number of defined names (Count);
Access individual defined names (Items and GetItemByName).
Delete a specific defined name or remove it from the collection (Delete and Remove).
Obtain the index of an individual defined name by its caption and scope (IndexOf).
Identify if the specified defined name is in the collection (Contains).
Delete all defined names in the collection (Clear).
Access the spreadsheet control to which the defined name collection belongs (SpreadSheet).
A spreadsheet control’s DefinedNames property references a TdxSpreadSheetDefinedNames object.