Version

Search Results

Remove Method (WorksheetMergedCellsRegionCollection)

Removes the specified merged cell region from the collection. Syntax Parameters region The merged cell region to remove from the collection. Return Value True if the merged cell region was successfully removed; False if the merged cell region was not in the collection. Remarks When a merged cell region is removed,...

RemoveAt Method (WorksheetMergedCellsRegionCollection)

Removes the merged cell region at the specified index from the collection. Syntax Parameters index The zero-based index of the merged cell region in the collection. Exceptions Exception Description System.ArgumentOutOfRangeException index is less than zero or index is greater than or equal to Count. Remarks When a...

WorksheetMergedCellsRegion Class Members

Public Properties Public Methods

CellFormat Property (WorksheetMergedCellsRegion)

Gets the cell formatting for the merged cell region. Syntax Property Value The cell formatting for the merged cell region.

Comment Property (WorksheetMergedCellsRegion)

Gets or sets the comment for the merged cells region. Syntax Property Value The comment for the merged cells region. Remarks The comment of the merged region can also be accessed from the top-left cell of the merged region of cells.

Formula Property (WorksheetMergedCellsRegion)

Gets the formula which has been applied to the merged region. Syntax Property Value The formula which has been applied to the merged region or null if no formula has been applied.

GetResolvedCellFormat Method (WorksheetMergedCellsRegion)

Gets the resolved cell formatting for this merged cell region. Syntax Return Value A format object describing the actual formatting that will be used when displayed this cell in Microsoft Excel. Remarks If any cell format properties are the default values on the merged cell region, the values from the owning rows ...

Value Property (WorksheetMergedCellsRegion)

Gets or sets the value of the merged cell region. Syntax Property Value The value of the merged cell region. Exceptions Exception Description System.NotSupportedException The assigned values type is not supported and cant be exported to Excel. System.InvalidOperationException The value assigned is a Formula. Inste...