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"); }