poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hzmj9h <karthick.smi...@gmail.com>
Subject Invalid arg type for SUMPRODUCT: (org.apache.poi.ss.formula.eval.ErrorEval)
Date Fri, 28 Sep 2018 19:20:53 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message