Skip to main content

TdxSpreadSheetCell Members

Stores cell content and custom style settings in a worksheet.

Constructors

Name Description
Create(TdxDynamicItemList,Integer) Creates a new item at the specified position within the dynamic item list. Inherited from TdxDynamicListItem.

Properties

Name Description
AsBoolean Specifies the cell object’s Boolean value.
AsCurrency Specifies the cell object’s Currency value.
AsDateTime Specifies the cell object’s date/time value.
AsError Specifies the cell object’s error status.
AsFloat Specifies the cell object’s floating point value.
AsFormula Provides access to the parsed formula expression associated with the cell object.
AsInteger Specifies the cell object’s integer value.
AsSharedString This member supports the internal infrastructure and is not intended to be used directly from your code.
AsString Specifies the cell object’s string value.
AsVariant Specifies the cell object’s Variant value.
Column Specifies the column object that hosts the cell object.
ColumnIndex Specifies a zero-based index of the column that hosts the cell object.
DataType Returns the data type of the cell object’s current value.
DisplayText Returns a text string corresponding to the cell object’s actual formatted value.
DisplayValue Returns the cell object‘s actual displayed value.
HasValue Identifies if the cell object stores a value.
Index Returns the item’s zero-based index within the dynamic list. Inherited from TdxDynamicListItem.
IsEmpty Specifies if the cell object is empty.
IsFormula Identifies if the cell object as a parsed formula expression.
IsMerged Identifies if the cell object is a part of a merged cell.
Row Specifies the row object that hosts the cell object.
RowIndex Specifies a zero-based index of the row that hosts the cell object.
ShowFormula Specifies if the cell displays a source text of the cell object’s formula expression.
SpreadSheet Returns the control instance to which the cell object belongs.
Style Provides access to cell style settings.
View Provides access to the Table View worksheet to which the cell object belongs.

Methods

Name Description
Assign(TdxDynamicListItem) Copies the specified item’s content to the current dynamic list item. Inherited from TdxDynamicListItem.
Clear Deletes the cell object’s current value.
Equals(TObject) Inherited from TObject.
GetAbsoluteBounds Returns the absolute coordinates (in pixels) of the current cell object‘s boundaries in the Table View worksheet.
GetAsError protected Returns the cell object’s error status.
GetAsFloat protected Returns the cell object’s stored data as a floating point value.
GetAsFormulaObject Returns a parsed formula expression associated with the cell object.
GetAsRTF(string) Retrieves the cell object’s formatted content as an RTF string.
GetAsVariant protected Returns the cell object’s stored data as a Variant value.
GetDataType Returns the data type of the cell object’s current value.
GetHashCode Inherited from TObject.
GetIsEmpty Identifies if the cell object contains a value.
GetReference(TdxSpreadSheetCellReferenceOptions)
GetReference(Boolean,TdxSpreadSheetCellReferenceOptions) Returns a reference to the current cell object.
IsNumericValue Identifies if the cell object contains a numeric value.
QueryInterface(TGUID,Untyped) protected Provides access to the implementation of the specified interface if the current object supports it. Inherited from TcxIUnknownObject.
SetAsRTF(string) Replaces the cell object’s value with a formatted RTF string.
SetText(string,Boolean) Assigns an unformatted text string or formula expression to the cell.
ShiftIndex(Integer) protected Changes the item’s index within the dynamic list by the specified value. Inherited from TdxDynamicListItem.
ToString Inherited from TObject.
See Also