Skip to main content

TdxSpreadSheetDefinedName Members

A defined name in a spreadsheet document.

Constructors

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

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