[]
Adds a new CellRange object to the collection.
public int Add(int topRow, int leftCol, int bottomRow, int rightCol)
Public Function Add(topRow As Integer, leftCol As Integer, bottomRow As Integer, rightCol As Integer) As Integer
| Type | Name | Description |
|---|---|---|
| int | topRow | Top row in the range. |
| int | leftCol | Left column in the range. |
| int | bottomRow | Bottom row in the range. |
| int | rightCol | Right column in the range. |
| Type | Description |
|---|---|
| int | The index of the object in the collection. |
Adds a new CellRange object to the collection.
public int Add(CellRange value)
Public Function Add(value As CellRange) As Integer
| Type | Name | Description |
|---|---|---|
| CellRange | value | Object to add to the collection. |
| Type | Description |
|---|---|
| int | The index of the object in the collection. |
Adds a new CellRange object to the collection, optionally removing other overlapping ranges from the collection.
public int Add(int topRow, int leftCol, int bottomRow, int rightCol, bool clearOverlappingRanges)
Public Function Add(topRow As Integer, leftCol As Integer, bottomRow As Integer, rightCol As Integer, clearOverlappingRanges As Boolean) As Integer
| Type | Name | Description |
|---|---|---|
| int | topRow | Top row in the range. |
| int | leftCol | Left column in the range. |
| int | bottomRow | Bottom row in the range. |
| int | rightCol | Right column in the range. |
| bool | clearOverlappingRanges | Whether to remove overlapping ranges from the collection before adding the new range. |
| Type | Description |
|---|---|
| int | The index of the object in the collection. |
Adds a new CellRange object to the collection, optionally removing other overlapping ranges from the collection.
public int Add(CellRange value, bool clearOverlappingRanges)
Public Function Add(value As CellRange, clearOverlappingRanges As Boolean) As Integer
| Type | Name | Description |
|---|---|---|
| CellRange | value | Object to add to the collection. |
| bool | clearOverlappingRanges | Whether to remove overlapping ranges from the collection before adding the new range. |
| Type | Description |
|---|---|
| int | The index of the object in the collection. |