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