Skip to main content

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).

Direct TdxSpreadSheetDefinedNames Class Reference

A spreadsheet control’s DefinedNames property references a TdxSpreadSheetDefinedNames object.

See Also