https://bz.apache.org/bugzilla/show_bug.cgi?id=65915
Bug ID: 65915
Summary: BooleanFunction.OR evaluateArray not working properly
Product: POI
Version: unspecified
Hardware: Macintosh
OS: Mac OS X 10.1
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
With POI version 4.1.2
This formula failed to evaluate
```
=INDEX({1},1,
IF(OR(FALSE,FALSE),1,1))
```
Stacktrace
[POI.FormulaEval]W - evaluateFormula('Sheet1'/A1): [[ArrayPtg] nRows = 1
nCols = 1 {1}, IntPtg [1], BoolPtg [FALSE], BoolPtg [FALSE], FuncVarPtg [OR
nArgs=2], AttrPtg [if dist=7], IntPtg [1], AttrPtg [skip dist=10], IntPtg [1],
AttrPtg [skip dist=3], FuncVarPtg [IF nArgs=3], FuncVarPtg [INDEX nArgs=3]]
[POI.FormulaEval]I * ptg 0: [ArrayPtg] nRows = 1 nCols = 1 {1}, stack: []
[POI.FormulaEval]I = org.apache.poi.ss.formula.CacheAreaEval[A1:A1]
[POI.FormulaEval]I * ptg 1: org.apache.poi.ss.formula.ptg.IntPtg [1],
stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1]]
[POI.FormulaEval]I = org.apache.poi.ss.formula.eval.NumberEval [1]
[POI.FormulaEval]I * ptg 2: org.apache.poi.ss.formula.ptg.BoolPtg [FALSE],
stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1]]
[POI.FormulaEval]I = org.apache.poi.ss.formula.eval.BoolEval [FALSE]
[POI.FormulaEval]I * ptg 3: org.apache.poi.ss.formula.ptg.BoolPtg [FALSE],
stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.BoolEval [FALSE]]
[POI.FormulaEval]I = org.apache.poi.ss.formula.eval.BoolEval [FALSE]
[POI.FormulaEval]I * ptg 4: org.apache.poi.ss.formula.ptg.FuncVarPtg [OR
nArgs=2], stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.BoolEval [FALSE],
org.apache.poi.ss.formula.eval.BoolEval [FALSE]]
[POI.FormulaEval]I = org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!]
[POI.FormulaEval]I * ptg 5: org.apache.poi.ss.formula.ptg.AttrPtg [if
dist=7], stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!]]
[POI.FormulaEval]I * ptg 6: org.apache.poi.ss.formula.ptg.IntPtg [1],
stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!]]
[POI.FormulaEval]I = org.apache.poi.ss.formula.eval.NumberEval [1]
[POI.FormulaEval]I * ptg 7: org.apache.poi.ss.formula.ptg.AttrPtg [skip
dist=10], stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!],
org.apache.poi.ss.formula.eval.NumberEval [1]]
[POI.FormulaEval]I * ptg 8: org.apache.poi.ss.formula.ptg.IntPtg [1],
stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!],
org.apache.poi.ss.formula.eval.NumberEval [1]]
[POI.FormulaEval]I = org.apache.poi.ss.formula.eval.NumberEval [1]
[POI.FormulaEval]I * ptg 9: org.apache.poi.ss.formula.ptg.AttrPtg [skip
dist=3], stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.NumberEval [1]]
[POI.FormulaEval]I * ptg 10: org.apache.poi.ss.formula.ptg.FuncVarPtg [IF
nArgs=3], stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.NumberEval [1]]
[POI.FormulaEval]I = org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!]
[POI.FormulaEval]I * ptg 11: org.apache.poi.ss.formula.ptg.FuncVarPtg
[INDEX nArgs=3], stack: [org.apache.poi.ss.formula.CacheAreaEval[A1:A1],
org.apache.poi.ss.formula.eval.NumberEval [1],
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!]]
[POI.FormulaEval]I = org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!]
[POI.FormulaEval]I finshed eval of A1:
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!]
[org.apache.poi.ss.formula.WorkbookEvaluator]D Evaluated Sheet1!A1 to
org.apache.poi.ss.formula.eval.ErrorEval [#VALUE!]
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
