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 On Sat, Sep 29, 2018 at 3:46 AM hzmj9h <[email protected]> wrote: > 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 > java.lang.RuntimeException: Invalid arg type for SUMPRODUCT: > (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 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
