1
Vote

Get Error message when Excel has STDEVPA formula

description

Dear Sir

I use OPNI 2.1 to edit excel content. if the excel has a cell with formula =stdevpa() or stdevp()
I will get error message as below, but NOPI work well when the formula change to stdev()
Could you help?

Error message:
System.NotImplementedException: Error evaluating cell XXX ---> System.NotImplementedException: STDEVPA
at NPOI.SS.Formula.Functions.NotImplementedFunction.Evaluate(ValueEval[] operands, Int32 srcRow, Int32 srcCol)
at NPOI.SS.Formula.OperationEvaluatorFactory.Evaluate(OperationPtg ptg, ValueEval[] args, OperationEvaluationContext ec)
at NPOI.SS.Formula.WorkbookEvaluator.EvaluateFormula(OperationEvaluationContext ec, Ptg[] ptgs)
at NPOI.SS.Formula.WorkbookEvaluator.EvaluateAny(IEvaluationCell srcCell, Int32 sheetIndex, Int32 rowIndex, Int32 columnIndex, EvaluationTracker tracker)
--- End of inner exception stack trace ---
at NPOI.SS.Formula.WorkbookEvaluator.EvaluateAny(IEvaluationCell srcCell, Int32 sheetIndex, Int32 rowIndex, Int32 columnIndex, EvaluationTracker tracker)
at NPOI.SS.Formula.WorkbookEvaluator.Evaluate(IEvaluationCell srcCell)
at NPOI.HSSF.UserModel.HSSFFormulaEvaluator.EvaluateFormulaCellValue(ICell cell)
at NPOI.HSSF.UserModel.HSSFFormulaEvaluator.EvaluateFormulaCell(ICell cell)
at NPOI.HSSF.UserModel.HSSFFormulaEvaluator.EvaluateAllFormulaCells(IWorkbook wb, IFormulaEvaluator evaluator)

comments

milksogo wrote Jul 11 at 10:07 AM

NA