[Bug 61116] Formula evaluation fails when using matrix addition within index function call with RuntimeException

2017-12-30 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61116

Yegor Kozlov  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |FIXED

--- Comment #4 from Yegor Kozlov  ---
Fixed in r1819596

I added your file in our collection of test cases. 

The main difficulty was to identify when addition should operate on matrices vs
single operands. Normally, the array mode is used if the formula was saved as
an array, i.e. using Ctrl-Shift-Enter. The INDEX function seems to be special,
if evaluates the first arguments as a matrix even if the formula itself is
single-value.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61116] Formula evaluation fails when using matrix addition within index function call with RuntimeException

2017-10-26 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61116

--- Comment #3 from Mario  ---
Created attachment 35466
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35466=edit
Patch with JUnit testcase for example workbook

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61116] Formula evaluation fails when using matrix addition within index function call with RuntimeException

2017-10-26 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61116

Mario  changed:

   What|Removed |Added

 Resolution|FIXED   |---
 Status|RESOLVED|REOPENED

--- Comment #2 from Mario  ---
I just checked with 3.16.final with applied patch of bug 61469 - the result is
still the same exception with same error message

java.lang.RuntimeException: Incomplete code - cannot handle first arg of type
(org.apache.poi.ss.formula.eval.NumberEval)
at
org.apache.poi.ss.formula.functions.Index.convertFirstArg(Index.java:107)
at org.apache.poi.ss.formula.functions.Index.evaluate(Index.java:75)
at org.apache.poi.ss.formula.functions.Index.evaluate(Index.java:116)
at
org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:139)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:524)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:291)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:233)
at
org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:65)
at
org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluate(BaseFormulaEvaluator.java:101)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61116] Formula evaluation fails when using matrix addition within index function call with RuntimeException

2017-09-20 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61116

PJ Fanning  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61116] Formula evaluation fails when using matrix addition within index function call with RuntimeException

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61116

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from Dominik Stadler  ---
Can you check if the changes done in bug 61469 solve this?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61116] Formula evaluation fails when using matrix addition within index function call with RuntimeException

2017-06-16 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61116

Dominik Stadler  changed:

   What|Removed |Added

 OS||All

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org