public void TestPageBreakFiles()
{
HSSFWorkbook wb = OpenSample("SimpleWithPageBreaks.xls");
NPOI.SS.UserModel.Sheet sheet = wb.GetSheetAt(0);
Assert.IsNotNull(sheet);
Assert.AreEqual(1, sheet.RowBreaks.Length, "1 row page break");
Assert.AreEqual(1, sheet.ColumnBreaks.Length, "1 column page break");
Assert.IsTrue(sheet.IsRowBroken(22), "No row page break");
Assert.IsTrue(sheet.IsColumnBroken((short)4), "No column page break");
sheet.SetRowBreak(10);
sheet.SetColumnBreak((short)13);
Assert.AreEqual(2, sheet.RowBreaks.Length, "row breaks number");
Assert.AreEqual(2, sheet.ColumnBreaks.Length, "column breaks number");
wb = HSSFTestDataSamples.WriteOutAndReadBack(wb);
sheet = wb.GetSheetAt(0);
Assert.IsTrue(sheet.IsRowBroken(22), "No row page break");
Assert.IsTrue(sheet.IsColumnBroken((short)4), "No column page break");
Assert.AreEqual(2, sheet.RowBreaks.Length, "row breaks number");
Assert.AreEqual(2, sheet.ColumnBreaks.Length, "column breaks number");
}
public void TestShiftRowBreaks()
{
HSSFWorkbook b = new HSSFWorkbook();
NPOI.SS.UserModel.Sheet s = b.CreateSheet();
Row row = s.CreateRow(4);
row.CreateCell(0).SetCellValue("Test");
s.SetRowBreak(4);
s.ShiftRows(4, 4, 2);
Assert.IsTrue(s.IsRowBroken(6), "Row number 6 should have a pagebreak");
}