public void TestMissingHeaderFooterRecord_bug47244() { // noHeaderFooter47244.xls was Created by a slightly modified POI // which omitted the HEADER/FOOTER records IWorkbook wb = HSSFTestDataSamples.OpenSampleWorkbook("noHeaderFooter47244.xls"); ISheet sheet = wb.GetSheetAt(0); HSSFFooter footer; try { footer = (HSSFFooter)sheet.Footer; } catch (NullReferenceException) { throw new AssertionException("Identified bug 47244a"); } Assert.AreEqual("", footer.RawText); HSSFHeader header = (HSSFHeader)sheet.Header; Assert.AreEqual("", header.RawText); // make sure header / footer is properly linked to underlying data HSSFHeader header2 = (HSSFHeader)sheet.Header; header.Center = (/*setter*/ "foo"); Assert.AreEqual("foo", header2.Center); HSSFFooter footer2 = (HSSFFooter)sheet.Footer; footer.Center = (/*setter*/ "bar"); Assert.AreEqual("bar", footer2.Center); }
public void TestSpecialChars() { Assert.AreEqual("&U", HSSFHeader.StartUnderline); Assert.AreEqual("&U", HSSFHeader.EndUnderline); Assert.AreEqual("&P", HSSFHeader.Page); Assert.AreEqual("&22", HSSFFooter.FontSize((short)22)); Assert.AreEqual("&\"Arial,bold\"", HSSFFooter.Font("Arial", "bold")); }