Cell
|
The CellRange type exposes the following members.
| Name | Description | |
|---|---|---|
| Alignment | Property that represents cell alignment for the cell range. This property can be one of the following: Name Value Description TopLeft 1 Left-justified text at a point specified for the top of the text within a text table cell. TopCenter 2 Centers text at a point specified for the top of the text within a text table cell. TopRight 3 Right-justified text at a point specified for the top of the text within a text table cell. MiddleLeft 4 Left-justifies text at a point specified for the middle of the text within a text table cell. MiddleCenter 5 Centers text at a point specified for the middle of the text within a text table cell. MiddleRight 6 Right-justifies text at a point specified for the middle of the text within a text table cell. BottomCenter 7 Left-justifies text at a point specified for the bottom of the text within a text table cell. BottomLeft 8 Centers text at a point specified for the bottom of the text within a text table cell. BottomRight 9 Right-justifies text at a point specified for the bottom of the text within a text table cell. | |
| BackgroundColor | Property that represents background color for the cell range. | |
| Borders | Property that represents cell borders for a cell range. | |
| BottomRight | Property that represents a bottom-right cell in a cell range. | |
| BottomRightPlusOne | Property that represents a cell that is one row down from the last row and one column right from the last column in a cell range. | |
| BottomRow | Property that represents an index of a bottom row. | |
| CanDeleteColumns | Property that indicates whether all columns can be deleted from the cell range. | |
| CanDeleteRows | Property that indicates whether all rows can be deleted from the cell range. | |
| CanInsertColumn | Property that indicates whether a cell range can insert a column at the left column index. | |
| CanInsertRow | Property that indicates whether a cell range can insert a column at the top row index. | |
| ContentColor | Property that represents content color for the cell range. | |
| ContentLayout | Property that represents content layout of a cell range. This property can be one of the following: Name Value Description Flow 1 Contents flow from left to right and top to bottom. StackedHorizontal 2 Contents are stacked horizontally. StackedVertical 3 Contents are stacked vertically. | |
| DataFormat | Property that represents data format of the cell range. | |
| DataType | Property that represents a DataTypeParameter instance encapsulating data type and unit type of a cell range. | |
| IsBackgroundColorNone | Property that indicates whether background color is disabled for the cell range. | |
| IsContentEditable | Property that indicates whether all cells in this cell range are editable. | |
| IsEmpty | Property that indicates whether all cells in this cell range are empty. | |
| IsFormatEditable | Property that indicates whether cell format can be edited for all cells in the cell range. | |
| IsLinked | Property that indicates whether all cells in the cell range are linked to their data sources. | |
| IsMergeAllEnabled | Property that indicates whether the merge-all flag is enabled for the cell range. | |
| IsMerged | Property that indicates whether all cells in the cell range are merged. | |
| IsNull | Property that indicates whether the cell range is NULL. | |
| IsSingleCell | Property that indicates whether the cell range contains single cells and not merged cells. Top-left cell is a target cell that is tested whether its a part of merged cell. | |
| Item | ||
| LeftColumn | Property that represents an index of a left column. | |
| Parent | Property that represents a parent object (table) of this cell range. | |
| ParentTable | Property that represents a parent object (table) from which this cell range is taken. | |
| RightColumn | Property that represents an index of a right column. | |
| State | Property that represents state for a cell range. This property can be one of the following: Name Value Description None 0 No defined state. ContentLocked 1 Cell's content is locked. ContentReadOnly 2 Cell's content is read-only. Linked 3 Cell is linked to a data source. ContentModifiedAfterUpdate 4 Cell's content has been modified since last update. FormatLocked 5 Cell's format is locked. Can be unlocked by user. FormatReadOnly 6 Cell's format is read-only. FormatModifiedAfterUpdate 7 Cell's format has been modified since last update. | |
| Style | Property that represents cell style of the cell range. | |
| TextHeight | Property that represents text height of the cell range. | |
| TextStyleId | Property that represents Object ID of the text style for the cell range. | |
| TopLeft | Property that represents a top-left cell in a cell range. | |
| TopRow | Property that represents an index of a top row. |
| Name | Description | |
|---|---|---|
| ClearStyleOverrides | Clears the table style overrides from the cells. | |
| Create | Creates a range of cells in a table. | |
| DeleteContent | Deletes content from the cells. | |
| Equals | Checks objects for equality. (Overrides ObjectEquals(Object)) |
|
| Finalize | (Inherited from Object) |
|
| GetCustomData | Returns the custom data value of the currently enumerated cell. | |
| GetDataLink | Returns the data links for this range of cells. | |
| GetEnumerator | Returns the enumerator for this range of cells. | |
| GetHashCode | Retrieves the object hash code. (Overrides ObjectGetHashCode) |
|
| GetStyleOverrides | Returns the cell style overrides for this cell range. | |
| GetType | (Inherited from Object) |
|
| IEnumerableGetEnumerator | Returns the enumerator for this range of cells. | |
| MemberwiseClone | (Inherited from Object) |
|
| SetCustomData | Sets the custom data value for this cell range. | |
| SetDataLink | Sets the data link for this cell range. | |
| ToString | (Inherited from Object) |
| Name | Description | |
|---|---|---|
| Equality(CellRange, CellRange) | Equality operator for the CellRange class. Checks whether cell ranges are equal. | |
| Inequality(CellRange, CellRange) | Inequality operator for the CellRange class. Checks whether cell ranges are not equal. |
| © Bricsys NV. All rights reserved. |