public void TestPageBreakFiles()
{
HSSFWorkbook wb = HSSFTestDataSamples.OpenSampleWorkbook("SimpleWithPageBreaks.xls");
NPOI.SS.UserModel.ISheet 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");
}