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

TdxSpreadSheetDefinedName Members

A defined name in a spreadsheet document.

#Constructors
Show Inherited Hide Inherited

Name Description
Create(TdxSpreadSheetObjectList) Appends a new item to the specified collection. Inherited from TdxSpreadSheetObjectListItem.

#Properties

Name Description
Caption Specifies a public name for the reference stored within the defined name object.
Comment Specifies an optional comment for the defined name.
Index Returns the defined name’s index within the collection.
Owner
Reference Specifies a reference to a cell object, cell range, formula expression, and/or constant.
Scope Specifies the scope of the defined name.
SpreadSheet Provides access to the SpreadSheet or Report Designer control to which the defined name belongs.
ValueAsText Returns the calculated value of the formula expression stored as a defined name’s reference.

#Methods
Show Inherited Hide Inherited

Name Description
EnumReferences(TdxSpreadSheetFormulaEnumReferencesProc) Extracts the technical information on the worksheet and area reference stored within the defined name object.
Equals(TObject) Inherited from TObject.
GetHashCode Inherited from TObject.
IsCellReference
IsCellReference(TRect,TdxSpreadSheetCustomView) Identifies if the defined name refers to a cell or cell range.
ToString Returns the defined name’s scope and caption as a string.
See Also