Static $tStatic nextGets the number of merged cell regions in the collection. The number of merged cell regions in the collection.
Creates new merged cell region and adds it to the collection.
The new merged cell region will take its value from the first cell containing a value, starting at the top-left and going across then down in the region. The value of all other cells will be lost. Similarly, the new region will initialize its cell format from the first cell containing a non-default cell format.
InvalidOperationException 'firstRow' is greater than 'lastRow' or 'firstColumn' is greater than 'lastColumn'.
ArgumentOutOfRangeException Any row or column indices specified are outside the valid row or column ranges.
InvalidOperationException The new merged cell region overlaps with an existing merged cell region.
The newly created WorksheetMergedCellsRegion.
The index of the first row of the merged cell region.
The index of the first column of the merged cell region.
The index of the last row of the merged cell region.
The index of the last row column of the merged cell region.
Clears all merged cell regions from the collection.
When a merged cell region is removed, the top-left cell in the region will retain the region's value. All other cells in the region will have a null value. In addition, all cells in the merged region will have the region's cell format when it is removed.
Checks if any part of specified region is already a part of a merged cell region.
True if any part of specified region is a part of merged cell region; False otherwise.
The index of the first row of the merged cell region.
The index of the first column of the merged cell region.
The index of the last row of the merged cell region.
The index of the last row column of the merged cell region.
Gets the merged cell region at the specified index. The merged cell region at the specified index.
ArgumentOutOfRangeException 'index' is less than zero or 'index' is greater than or equal to count.
Removes the merged cell region at the specified index from the collection.
When a merged cell region is removed, the top-left cell in the region will retain the region's value. All other cells in the region will have a null value. In addition, all cells in the merged region will have the region's cell format when it is removed.
ArgumentOutOfRangeException 'index' is less than zero or 'index' is greater than or equal to count.
The zero-based index of the merged cell region in the collection.
Removes the specified merged cell region from the collection.
When a merged cell region is removed, the top-left cell in the region will retain the region's value. All other cells in the region will have a null value. In addition, all cells in the merged region will have the region's cell format when it is removed.
True if the merged cell region was successfully removed; False if the merged cell region was not in the collection.
The merged cell region to remove from the collection.
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic referenceStatic static
A collection of WorksheetMergedCellsRegion instances in a Worksheet.
See