Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetDefinedNames Members

A defined name collection in a spreadsheet control.

#Constructors
Show Inherited Hide Inherited

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

#Properties
Show Inherited Hide Inherited

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
Show Inherited Hide Inherited

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