public CellType EvaluateFormulaCell(ICell cell)
{
if (cell == null || cell.CellType != CellType.FORMULA)
{
return(CellType.Unknown);
}
CellValue formulaCellValue = this.EvaluateFormulaCellValue(cell);
XSSFFormulaEvaluator.SetCellValue(cell, formulaCellValue);
return(formulaCellValue.CellType);
}
public ICell EvaluateInCell(ICell cell)
{
if (cell == null)
{
return((ICell)null);
}
XSSFCell xssfCell = (XSSFCell)cell;
if (cell.CellType == CellType.FORMULA)
{
CellValue formulaCellValue = this.EvaluateFormulaCellValue(cell);
XSSFFormulaEvaluator.SetCellType(cell, formulaCellValue);
XSSFFormulaEvaluator.SetCellValue(cell, formulaCellValue);
}
return((ICell)xssfCell);
}
