public void TestEvaluateAllInWindow()
{
SXSSFWorkbook wb = new SXSSFWorkbook(5);
SXSSFSheet s = wb.CreateSheet() as SXSSFSheet;
s.CreateRow(0).CreateCell(0).CellFormula = (/*setter*/ "1+2");
s.CreateRow(1).CreateCell(1).CellFormula = (/*setter*/ "A1+10");
s.CreateRow(2).CreateCell(2).CellFormula = (/*setter*/ "B2+100");
IFormulaEvaluator eval = wb.GetCreationHelper().CreateFormulaEvaluator();
eval.EvaluateAll();
Assert.AreEqual(3, (int)s.GetRow(0).GetCell(0).NumericCellValue);
Assert.AreEqual(13, (int)s.GetRow(1).GetCell(1).NumericCellValue);
Assert.AreEqual(113, (int)s.GetRow(2).GetCell(2).NumericCellValue);
wb.Close();
}
public IEvaluationCell GetCell(int rowIndex, int columnIndex)
{
SXSSFRow row = (SXSSFRow)_xs.GetRow(rowIndex);
if (row == null)
{
if (rowIndex <= _xs.LastFlushedRowNumber)
{
throw new RowFlushedException(rowIndex);
}
return(null);
}
SXSSFCell cell = (SXSSFCell)row.GetCell(columnIndex);
if (cell == null)
{
return(null);
}
return(new SXSSFEvaluationCell(cell, this));
}
