public void TestStripFields()
{
String simple = "I am a Test header";
String withPage = "I am a&P Test header";
String withLots = "I&A am&N a&P Test&T header&U";
String withFont = "I&22 am a&\"Arial,bold\" Test header";
String withOtherAnds = "I am a&P Test header&&";
String withOtherAnds2 = "I am a&P Test header&a&b";
Assert.AreEqual(simple, HSSFHeader.StripFields(simple));
Assert.AreEqual(simple, HSSFHeader.StripFields(withPage));
Assert.AreEqual(simple, HSSFHeader.StripFields(withLots));
Assert.AreEqual(simple, HSSFHeader.StripFields(withFont));
Assert.AreEqual(simple + "&&", HSSFHeader.StripFields(withOtherAnds));
Assert.AreEqual(simple + "&a&b", HSSFHeader.StripFields(withOtherAnds2));
// Now Test the default Strip flag
HSSFWorkbook wb = HSSFTestDataSamples.OpenSampleWorkbook("EmbeddedChartHeaderTest.xls");
NPOI.SS.UserModel.Sheet s = wb.GetSheetAt(0);
Header head = s.Header;
Assert.AreEqual("Top Left", head.Left);
Assert.AreEqual("Top Center", head.Center);
Assert.AreEqual("Top Right", head.Right);
head.Left = ("Top &P&F&D Left");
Assert.AreEqual("Top &P&F&D Left", head.Left);
Assert.AreEqual("Top Left", NPOI.HSSF.UserModel.HeaderFooter.StripFields(head.Left));
// Now even more complex
head.Center = ("HEADER TEXT &P&N&D&T&Z&F&F&A&G&X END");
Assert.AreEqual("HEADER TEXT END", NPOI.HSSF.UserModel.HeaderFooter.StripFields(head.Center));
}
public void TestStripFields()
{
String simple = "I am a Test header";
String withPage = "I am a&P Test header";
String withLots = "I&A am&N a&P Test&T header&U";
String withFont = "I&22 am a&\"Arial,bold\" Test header";
String withOtherAnds = "I am a&P Test header&&";
String withOtherAnds2 = "I am a&P Test header&a&b";
Assert.IsTrue(0 < HeaderFooter.Fields.AllFields.Count,
string.Format(CultureInfo.InvariantCulture, "Fields.AllFields must be initialized before the following tests are working. Fields.AllFields.Count: {0}. ",
HeaderFooter.Fields.AllFields.Count));
Assert.AreEqual(simple, HSSFHeader.StripFields(simple));
Assert.AreEqual(simple, HeaderFooter.StripFields(withPage));
Assert.AreEqual(simple, HSSFHeader.StripFields(withPage));
Assert.AreEqual(simple, HSSFHeader.StripFields(withLots));
Assert.AreEqual(simple, HSSFHeader.StripFields(withFont));
Assert.AreEqual(simple + "&&", HSSFHeader.StripFields(withOtherAnds));
Assert.AreEqual(simple + "&a&b", HSSFHeader.StripFields(withOtherAnds2));
// Now Test the default Strip flag
HSSFWorkbook wb = HSSFTestDataSamples.OpenSampleWorkbook("EmbeddedChartHeaderTest.xls");
NPOI.SS.UserModel.ISheet s = wb.GetSheetAt(0);
IHeader head = s.Header;
Assert.AreEqual("Top Left", head.Left);
Assert.AreEqual("Top Center", head.Center);
Assert.AreEqual("Top Right", head.Right);
head.Left = ("Top &P&F&D Left");
Assert.AreEqual("Top &P&F&D Left", head.Left);
Assert.AreEqual("Top Left", NPOI.HSSF.UserModel.HeaderFooter.StripFields(head.Left));
// Now even more complex
head.Center = ("HEADER TEXT &P&N&D&T&Z&F&F&A&G&X END");
Assert.AreEqual("HEADER TEXT END", NPOI.HSSF.UserModel.HeaderFooter.StripFields(head.Center));
}
