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

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

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
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

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

Yegor Kozlov-4
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 <[hidden email]> 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: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>