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]
