public void TestAddMerged()
{
IWorkbook wb = _testDataProvider.CreateWorkbook();
ISheet sheet = wb.CreateSheet();
Assert.AreEqual(0, sheet.NumMergedRegions);
SpreadsheetVersion ssVersion = _testDataProvider.GetSpreadsheetVersion();
CellRangeAddress region = new CellRangeAddress(0, 1, 0, 1);
sheet.AddMergedRegion(region);
Assert.AreEqual(1, sheet.NumMergedRegions);
try
{
region = new CellRangeAddress(-1, -1, -1, -1);
sheet.AddMergedRegion(region);
Assert.Fail("Expected exception");
}
catch (ArgumentException)
{
// TODO Assert.AreEqual("Minimum row number is 0.", e.Message);
}
try
{
region = new CellRangeAddress(0, 0, 0, ssVersion.LastColumnIndex + 1);
sheet.AddMergedRegion(region);
Assert.Fail("Expected exception");
}
catch (ArgumentException e)
{
Assert.AreEqual("Maximum column number is " + ssVersion.LastColumnIndex, e.Message);
}
try
{
region = new CellRangeAddress(0, ssVersion.LastRowIndex + 1, 0, 1);
sheet.AddMergedRegion(region);
Assert.Fail("Expected exception");
}
catch (ArgumentException e)
{
Assert.AreEqual("Maximum row number is " + ssVersion.LastRowIndex, e.Message);
}
Assert.AreEqual(1, sheet.NumMergedRegions);
}
