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