Class CellsRange
Abstract base class for ranges that represent a rectangular area of cells.
Inherited Members
Namespace: DRIT.Spreadsheet
Assembly: DRIT.Spreadsheet.dll
Syntax
public abstract class CellsRange : SimpleRange, INotifyPropertyChanged, IEnumerable<object>, IEnumerableRemarks
CellsRange serves as the base class for ranges that span a specific rectangular area
defined by a starting and ending cell address. This includes standard cell ranges like "A1:B10".
This class inherits from SimpleRange and provides common functionality for cell-based range operations such as value setting, formula application, and formatting.
Constructors
CellsRange()
Abstract base class for ranges that represent a rectangular area of cells.
Declaration
protected CellsRange()Remarks
CellsRange serves as the base class for ranges that span a specific rectangular area
defined by a starting and ending cell address. This includes standard cell ranges like "A1:B10".
This class inherits from SimpleRange and provides common functionality for cell-based range operations such as value setting, formula application, and formatting.
Properties
BottomLeft
Gets the bottom-left cell of this range.
Declaration
public abstract Cell BottomLeft { get; }Property Value
| Type | Description |
|---|---|
| Cell |
Remarks
CellsRange serves as the base class for ranges that span a specific rectangular area
defined by a starting and ending cell address. This includes standard cell ranges like "A1:B10".
This class inherits from SimpleRange and provides common functionality for cell-based range operations such as value setting, formula application, and formatting.
BottomRight
Gets the bottom-right cell of this range.
Declaration
public abstract Cell BottomRight { get; }Property Value
| Type | Description |
|---|---|
| Cell |
Remarks
CellsRange serves as the base class for ranges that span a specific rectangular area
defined by a starting and ending cell address. This includes standard cell ranges like "A1:B10".
This class inherits from SimpleRange and provides common functionality for cell-based range operations such as value setting, formula application, and formatting.
IsFullColumn
Indicates whether the full column condition is true for the CellsRange.
Declaration
public override sealed bool IsFullColumn { get; }Property Value
| Type | Description |
|---|---|
| bool | The is full column returned by the operation. |
Overrides
Remarks
CellsRange serves as the base class for ranges that span a specific rectangular area
defined by a starting and ending cell address. This includes standard cell ranges like "A1:B10".
This class inherits from SimpleRange and provides common functionality for cell-based range operations such as value setting, formula application, and formatting.
IsFullRow
Indicates whether the full row condition is true for the CellsRange.
Declaration
public override sealed bool IsFullRow { get; }Property Value
| Type | Description |
|---|---|
| bool | The is full row returned by the operation. |
Overrides
Remarks
CellsRange serves as the base class for ranges that span a specific rectangular area
defined by a starting and ending cell address. This includes standard cell ranges like "A1:B10".
This class inherits from SimpleRange and provides common functionality for cell-based range operations such as value setting, formula application, and formatting.
TopRight
Gets the top-right cell of this range.
Declaration
public abstract Cell TopRight { get; }Property Value
| Type | Description |
|---|---|
| Cell |
Remarks
CellsRange serves as the base class for ranges that span a specific rectangular area
defined by a starting and ending cell address. This includes standard cell ranges like "A1:B10".
This class inherits from SimpleRange and provides common functionality for cell-based range operations such as value setting, formula application, and formatting.
Methods
ApplySharedFormula(string)
Applies a shared formula to all cells in this range.
Declaration
public void ApplySharedFormula(string formula)Parameters
| Type | Name | Description |
|---|---|---|
| string | formula | The formula string to apply to the top-left cell, which will be shared with all other cells in the range. |
Remarks
This method creates a shared expression that is referenced by all cells in the range, allowing for efficient calculation and storage of identical formulas.