public void TestAddNameX()
{
HSSFWorkbook hwb = new HSSFWorkbook();
InternalWorkbook wb = TestHSSFWorkbook.GetInternalWorkbook(hwb);
Assert.IsNotNull(wb.GetNameXPtg("ISODD", UDFFinder.GetDefault()));
FreeRefFunction1 NotImplemented = new FreeRefFunction1();
/**
* register the two test UDFs in a UDF Finder, to be passed to the Evaluator
*/
UDFFinder udff1 = new DefaultUDFFinder(new String[] { "myFunc", },
new FreeRefFunction[] { NotImplemented });
UDFFinder udff2 = new DefaultUDFFinder(new String[] { "myFunc2", },
new FreeRefFunction[] { NotImplemented });
UDFFinder udff = new AggregatingUDFFinder(udff1, udff2);
Assert.IsNotNull(wb.GetNameXPtg("myFunc", udff));
Assert.IsNotNull(wb.GetNameXPtg("myFunc2", udff));
Assert.IsNull(wb.GetNameXPtg("myFunc3", udff)); // myFunc3 is unknown
hwb.Close();
}
public void TestRecalcId()
{
HSSFWorkbook wb = new HSSFWorkbook();
Assert.IsFalse(wb.ForceFormulaRecalculation);
InternalWorkbook iwb = TestHSSFWorkbook.GetInternalWorkbook(wb);
int countryPos = iwb.FindFirstRecordLocBySid(CountryRecord.sid);
Assert.IsTrue(countryPos != -1);
// RecalcIdRecord is not present in new workbooks
Assert.AreEqual(null, iwb.FindFirstRecordBySid(RecalcIdRecord.sid));
RecalcIdRecord record = iwb.RecalcId;
Assert.IsNotNull(record);
Assert.AreSame(record, iwb.RecalcId);
Assert.AreSame(record, iwb.FindFirstRecordBySid(RecalcIdRecord.sid));
Assert.AreEqual(countryPos + 1, iwb.FindFirstRecordLocBySid(RecalcIdRecord.sid));
record.EngineId = (/*setter*/ 100);
Assert.AreEqual(100, record.EngineId);
Assert.IsTrue(wb.ForceFormulaRecalculation);
wb.ForceFormulaRecalculation = (/*setter*/ true); // resets the EngineId flag to zero
Assert.AreEqual(0, record.EngineId);
Assert.IsFalse(wb.ForceFormulaRecalculation);
wb.Close();
}
public void TestFontStuff()
{
InternalWorkbook wb = TestHSSFWorkbook.GetInternalWorkbook(new HSSFWorkbook());
Assert.AreEqual(4, wb.NumberOfFontRecords);
Assert.AreEqual(68, wb.Records.Count);
FontRecord f1 = wb.GetFontRecordAt(0);
FontRecord f4 = wb.GetFontRecordAt(3);
Assert.AreEqual(0, wb.GetFontIndex(f1));
Assert.AreEqual(3, wb.GetFontIndex(f4));
Assert.AreEqual(f1, wb.GetFontRecordAt(0));
Assert.AreEqual(f4, wb.GetFontRecordAt(3));
// There is no 4! new ones go in at 5
FontRecord n = wb.CreateNewFont();
Assert.AreEqual(69, wb.Records.Count);
Assert.AreEqual(5, wb.NumberOfFontRecords);
Assert.AreEqual(5, wb.GetFontIndex(n));
Assert.AreEqual(n, wb.GetFontRecordAt(5));
// And another
FontRecord n6 = wb.CreateNewFont();
Assert.AreEqual(70, wb.Records.Count);
Assert.AreEqual(6, wb.NumberOfFontRecords);
Assert.AreEqual(6, wb.GetFontIndex(n6));
Assert.AreEqual(n6, wb.GetFontRecordAt(6));
// Now remove the one formerly at 5
Assert.AreEqual(70, wb.Records.Count);
wb.RemoveFontRecord(n);
// Check that 6 has gone to 5
Assert.AreEqual(69, wb.Records.Count);
Assert.AreEqual(5, wb.NumberOfFontRecords);
Assert.AreEqual(5, wb.GetFontIndex(n6));
Assert.AreEqual(n6, wb.GetFontRecordAt(5));
// Check that the earlier ones are unChanged
Assert.AreEqual(0, wb.GetFontIndex(f1));
Assert.AreEqual(3, wb.GetFontIndex(f4));
Assert.AreEqual(f1, wb.GetFontRecordAt(0));
Assert.AreEqual(f4, wb.GetFontRecordAt(3));
// Finally, add another one
FontRecord n7 = wb.CreateNewFont();
Assert.AreEqual(70, wb.Records.Count);
Assert.AreEqual(6, wb.NumberOfFontRecords);
Assert.AreEqual(6, wb.GetFontIndex(n7));
Assert.AreEqual(n7, wb.GetFontRecordAt(6));
}