Skip to main content

TdxSpreadSheetDefinedNames Members

A defined name collection in a spreadsheet control.

Constructors

Name Description
Create(TdxCustomSpreadSheet) Creates a new persistent object for the specified Spreadsheet or Report Designer control. Inherited from TdxSpreadSheetPersistentObject.

Properties

Name Description
Count Returns the number of collection items. Inherited from TdxSpreadSheetObjectList.
Items Provides indexed access to individual defined names declared in the document opened in a spreadsheet control.
SpreadSheet Provides access to the Spreadsheet or Report Designer control to which the persistent object belongs. Inherited from TdxSpreadSheetPersistentObject.

Methods

Name Description
Add(string,string,TdxSpreadSheetCustomView) Adds a new defined name to the collection.
AddFromSelection Creates new defined names from the cell selection in the active worksheet.
AddFromSelection(TdxSpreadSheetTableView,TdxRectList,TcxBorders) Creates new defined names from the specified cell ranges in a target worksheet.
AddFromSelection(TdxSpreadSheetTableView,TRect,TcxBorders) Creates new defined names from the specified cell range in a target worksheet.
AddFromSelection(TdxSpreadSheetTableView) Creates new defined names from the cell selection in a target worksheet.
AddFromStream(TcxReader) Adds a defined name to the collection from a stream object.
AddOrSet(string,string,TdxSpreadSheetCustomView) Declares a new defined name or assigns another caption, scope, and/or reference to an existing defined name.
Assign(TPersistent) Inherited from TPersistent.
AssignTo(TPersistent) Inherited from TPersistent.
BeginUpdate Stops all redraw operations in a spreadsheet control until an EndUpdate call.
Clear Clears the collection. Inherited from TdxSpreadSheetObjectList.
Contains(TdxSpreadSheetCustomView)
Contains(string,TdxSpreadSheetCustomView) Identifies if the specified defined name belongs to the collection.
Delete(Integer) Destroys the specified collection item. Inherited from TdxSpreadSheetObjectList.
EndUpdate Applies all pending defined name changes to a spreadsheet control after a BeginUpdate procedure call.
Equals(TObject) Inherited from TObject.
GetHashCode Inherited from TObject.
GetItemByName(string,TdxSpreadSheetCustomView) Returns the defined name by its caption.
GetNamePath Inherited from TPersistent.
GetOwner Inherited from TPersistent.
IndexOf(string,TdxSpreadSheetCustomView) Returns an index of the specified defined name in the collection.
IndexOf(string) Returns an index of specified defined name in the opened document.
QueryInterface(TGUID,Untyped) Inherited from TInterfacedPersistent.
Remove(TdxSpreadSheetObjectListItem) Removes the specified item from the collection. Inherited from TdxSpreadSheetObjectList.
ToString Inherited from TObject.
See Also