Invalid arg type for SUMPRODUCT: (org.apache.poi.ss.formula.eval.ErrorEval)

Yegor Kozlov

2018-09-29 12:31:08 UTC

What does this formula evaluate to in Excel and what is the value in the
cell B9?
POI complains that the first argument is of type ErrorEval which is not
supported in the current implementation. If SUMPRODUCT in Excel returns an
error if the first argument is an error then POI should do so . It's not
evident from the spec and might change over the time, i.e. Excel 2010 could
evaluate it differently than Excel 2016.

Yegor

Post by hzmj9h
Here I have a scenario like below
[9/28/18 13:58:09:815 CDT] 000000af SystemOut O Cell
VLOOKUP(B9,'Scaling'!A2:B801,2,FALSE)
*==> Above formula executed*
[9/28/18 13:58:09:870 CDT] 000000af SystemOut O CellC12
*==> Failed*
Where C12 is having a value as "'Out Scaling'!B2" and its failing
Below is the error
9/28/18 13:58:09:895 CDT] 000000af SystemErr R
(org.apache.poi.ss.formula.eval.ErrorEval)
[9/28/18 13:58:09:897 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.functions.Sumproduct.evaluate(Sumproduct.java:82)
[9/28/18 13:58:09:898 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132)
[9/28/18 13:58:09:899 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:514)
[9/28/18 13:58:09:900 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:278)
[9/28/18 13:58:09:901 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:722)
[9/28/18 13:58:09:902 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:48)
[9/28/18 13:58:09:902 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.SheetRangeEvaluator.getEvalForCell(SheetRangeEvaluator.java:74)
[9/28/18 13:58:09:903 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:39)
[9/28/18 13:58:09:904 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.eval.OperandResolver.chooseSingleElementFromRef(OperandResolver.java:179)
[9/28/18 13:58:09:907 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62)
[9/28/18 13:58:09:908 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.eval.TwoOperandNumericOperation.singleOperandEvaluate(TwoOperandNumericOperation.java:29)
[9/28/18 13:58:09:909 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.eval.TwoOperandNumericOperation.evaluate(TwoOperandNumericOperation.java:35)
[9/28/18 13:58:09:910 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.functions.Fixed2ArgFunction.evaluate(Fixed2ArgFunction.java:33)
[9/28/18 13:58:09:911 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:119)
[9/28/18 13:58:09:912 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:514)
[9/28/18 13:58:09:913 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:278)
[9/28/18 13:58:09:915 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:722)
[9/28/18 13:58:09:916 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:48)
[9/28/18 13:58:09:917 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.SheetRangeEvaluator.getEvalForCell(SheetRangeEvaluator.java:74)
[9/28/18 13:58:09:918 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:39)
[9/28/18 13:58:09:919 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.eval.OperandResolver.chooseSingleElementFromRef(OperandResolver.java:179)
[9/28/18 13:58:09:920 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62)
[9/28/18 13:58:09:921 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.dereferenceResult(WorkbookEvaluator.java:589)
[9/28/18 13:58:09:924 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:536)
[9/28/18 13:58:09:925 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:278)
[9/28/18 13:58:09:926 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateReference(WorkbookEvaluator.java:722)
[9/28/18 13:58:09:927 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:48)
[9/28/18 13:58:09:927 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.SheetRangeEvaluator.getEvalForCell(SheetRangeEvaluator.java:74)
[9/28/18 13:58:09:937 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:39)
[9/28/18 13:58:09:938 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.eval.OperandResolver.chooseSingleElementFromRef(OperandResolver.java:179)
[9/28/18 13:58:09:941 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:62)
[9/28/18 13:58:09:942 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.dereferenceResult(WorkbookEvaluator.java:589)
[9/28/18 13:58:09:943 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:536)
[9/28/18 13:58:09:944 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:278)
[9/28/18 13:58:09:945 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:220)
[9/28/18 13:58:09:945 CDT] 000000af SystemErr R at
org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:64)
[9/28/18 13:58:09:946 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateFormulaCellEnum(BaseFormulaEvaluator.java:192)
[9/28/18 13:58:09:947 CDT] 000000af SystemErr R at
org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateFormulaCell(BaseFormulaEvaluator.java:164)
[9/28/18 13:58:09:948 CDT] 000000af SystemErr R at
sf.auto.web.cri.bean.ModelExcelHelper.triggerFormula(ModelExcelHelper.java:289)
[9/28/18 13:58:09:949 CDT] 000000af SystemErr R at
sf.auto.web.cri.bean.ModelExcelHelper.recalcualteFormula(ModelExcelHelper.java:256)
[9/28/18 13:58:09:950 CDT] 000000af SystemErr R at
sf.auto.web.cri.bean.ModelExcelHelper.validateModelVariableTOAuditExcel(ModelExcelHelper.java:130)
--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html
---------------------------------------------------------------------