public void Test49381()
{
IWorkbook wb = _testDataProvider.CreateWorkbook();
int colSplit = 1;
int rowSplit = 2;
int leftmostColumn = 3;
int topRow = 4;
ISheet s = wb.CreateSheet();
// Populate
for (int rn = 0; rn <= topRow; rn++)
{
IRow r = s.CreateRow(rn);
for (int cn = 0; cn < leftmostColumn; cn++)
{
ICell c = r.CreateCell(cn, CellType.Numeric);
c.SetCellValue(100 * rn + cn);
}
}
// Create the Freeze Pane
s.CreateFreezePane(colSplit, rowSplit, leftmostColumn, topRow);
PaneInformation paneInfo = s.PaneInformation;
// Check it
Assert.AreEqual(colSplit, paneInfo.VerticalSplitPosition);
Assert.AreEqual(rowSplit, paneInfo.HorizontalSplitPosition);
Assert.AreEqual(leftmostColumn, paneInfo.VerticalSplitLeftColumn);
Assert.AreEqual(topRow, paneInfo.HorizontalSplitTopRow);
// Now a row only freezepane
s.CreateFreezePane(0, 3);
paneInfo = s.PaneInformation;
Assert.AreEqual(0, paneInfo.VerticalSplitPosition);
Assert.AreEqual(3, paneInfo.HorizontalSplitPosition);
Assert.AreEqual(0, paneInfo.VerticalSplitLeftColumn);
Assert.AreEqual(3, paneInfo.HorizontalSplitTopRow);
// Now a column only freezepane
s.CreateFreezePane(4, 0);
paneInfo = s.PaneInformation;
Assert.AreEqual(4, paneInfo.VerticalSplitPosition);
Assert.AreEqual(0, paneInfo.HorizontalSplitPosition);
Assert.AreEqual(4, paneInfo.VerticalSplitLeftColumn);
Assert.AreEqual(0, paneInfo.HorizontalSplitTopRow);
}
public void TestCreateFreezePane()
{
IWorkbook wb = _testDataProvider.CreateWorkbook();
// create a workbook
ISheet sheet = wb.CreateSheet();
Assert.IsNull(sheet.PaneInformation);
sheet.CreateFreezePane(0, 0);
// still null
Assert.IsNull(sheet.PaneInformation);
sheet.CreateFreezePane(2, 3);
PaneInformation info = sheet.PaneInformation;
Assert.AreEqual(PaneInformation.PANE_LOWER_RIGHT, info.ActivePane);
Assert.AreEqual(3, info.HorizontalSplitPosition);
Assert.AreEqual(3, info.HorizontalSplitTopRow);
Assert.AreEqual(2, info.VerticalSplitLeftColumn);
Assert.AreEqual(2, info.VerticalSplitPosition);
sheet.CreateFreezePane(0, 0);
// If both colSplit and rowSplit are zero then the existing freeze pane is Removed
Assert.IsNull(sheet.PaneInformation);
sheet.CreateFreezePane(0, 3);
info = sheet.PaneInformation;
Assert.AreEqual(PaneInformation.PANE_LOWER_LEFT, info.ActivePane);
Assert.AreEqual(3, info.HorizontalSplitPosition);
Assert.AreEqual(3, info.HorizontalSplitTopRow);
Assert.AreEqual(0, info.VerticalSplitLeftColumn);
Assert.AreEqual(0, info.VerticalSplitPosition);
sheet.CreateFreezePane(3, 0);
info = sheet.PaneInformation;
Assert.AreEqual(PaneInformation.PANE_UPPER_RIGHT, info.ActivePane);
Assert.AreEqual(0, info.HorizontalSplitPosition);
Assert.AreEqual(0, info.HorizontalSplitTopRow);
Assert.AreEqual(3, info.VerticalSplitLeftColumn);
Assert.AreEqual(3, info.VerticalSplitPosition);
sheet.CreateFreezePane(0, 0);
// If both colSplit and rowSplit are zero then the existing freeze pane is Removed
Assert.IsNull(sheet.PaneInformation);
}
