CellArea Members
Defines the range of cells in a worksheet. Used in cell reference expressions contained in parsed formulas.Constructors
| Name | Description |
|---|---|
| CellArea(CellRange) | Initializes a new instance of the CellArea class with the specified settings. |
| CellArea(CellReferencePosition, CellReferencePosition) | Initializes a new instance of the CellArea class with the specified settings. |
| CellArea(Int32, Int32, Int32, Int32) | Initializes a new instance of the CellArea class with the specified settings. |
Properties
| Name | Description |
|---|---|
| BottomRight | Gets or sets the position of the bottom-right corner of the rectangular cell area. |
| BottomRowIndex | Gets or sets the index of the bottom row of the cell area. |
| ColumnCount | Gets the number of columns in the cell area. |
| LeftColumnIndex | Gets or sets the index of the left column in the cell area. |
| RightColumnIndex | Gets or sets the index of the rightmost column in the cell area. |
| RowCount | Gets the number of rows in the cell area. |
| TopLeft | Gets or sets the position of the top left corner of the rectangular cell area. |
| TopRowIndex | Gets or sets the index of the top row in the cell area. |
Methods
| Name | Description |
|---|---|
| Clone() | Creates a copy of the current CellArea object. |
| CopyFrom(CellArea) | Copies the appropriate properties of the specified object into the current instance of the CellArea class. |
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
| GetHashCode() | Serves as the default hash function. Inherited from Object. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| Normalize() | Validates the settings of the CellArea object and corrects them if possible. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| ToString() | Gets reference string to a range represented by the CellArea object. |
See Also