TdxSpreadSheetCell Members
A logical cell designed to store, arrange, and process data within a Table View 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 the cell object’s appearance and behavior 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