You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2017/05/03 13:40:05 UTC
[Bug 61063] New: Use of arrays of values leads to non empty stack
https://bz.apache.org/bugzilla/show_bug.cgi?id=61063
Bug ID: 61063
Summary: Use of arrays of values leads to non empty stack
Product: POI
Version: 3.16-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
Assignee: dev@poi.apache.org
Reporter: smear1@gmx.de
Target Milestone: ---
Created attachment 34971
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34971&action=edit
Very simple example with rank function
When a cell contains a formula with an array of values, the evaluation of the
cell is not completed and an exception is thrown.
Here is an example formula: =RANK(A3;(B1;B4;B6);1) (Please see attachment)
Exception in thread "main" java.lang.IllegalStateException: evaluation stack
not empty
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:290)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:232)
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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 61063] Use of arrays of values leads to non empty stack
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61063
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 61063] Use of arrays of values leads to non empty stack
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61063
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |FIXED
Status|NEW |RESOLVED
--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
This should be fixed in r1795963, there may be other functions where this is
not yet fully supported, but I could not yet find a description of where else
it is possible to specify a list of references, if you happen to find one,
please open a separate bug so we can try to implement it there as well.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 61063] Use of arrays of values leads to non empty stack
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61063
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Initial assessment: The list of values as 2nd argument is not supported right
now and thus leads to this exception. We likely need some new handling of the
resulting UnionPtgs in WorkbookEvaluator.evaluateFormula()
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org