/**
* Adds a merged region of cells (hence those cells form one).
*
* @param region (rowfrom/colfrom-rowto/colto) to merge
* @return index of this region
*/
public int AddMergedRegion(CellRangeAddress region)
{
region.Validate(SpreadsheetVersion.EXCEL2007);
// throw InvalidOperationException if the argument CellRangeAddress intersects with
// a multi-cell array formula defined in this sheet
ValidateArrayFormulas(region);
CT_MergeCells ctMergeCells = worksheet.IsSetMergeCells() ? worksheet.mergeCells : worksheet.AddNewMergeCells();
CT_MergeCell ctMergeCell = ctMergeCells.AddNewMergeCell();
ctMergeCell.@ref = (region.FormatAsString());
return ctMergeCells.sizeOfMergeCellArray();
}
