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 2020/11/02 11:01:22 UTC
[Bug 64865] New: Sumproduct evaluation fails when there is cell
range inside formula
https://bz.apache.org/bugzilla/show_bug.cgi?id=64865
Bug ID: 64865
Summary: Sumproduct evaluation fails when there is cell range
inside formula
Product: POI
Version: 4.1.1-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: lauri4848@gmail.com
Target Milestone: ---
Sumproduct.evaluate fails with formula: SUMPRODUCT(A1:A3,--(B1:B3="a")). It
gets ErrorEval as 2. arg. Therefore sheet.autoSizeColumn(columnIndex, true)
fails to autosize column even when
XSSFFormulaEvaluator.evaluateAllFormulaCells(wb) is called just before, as
Sumproduct evaluation fails.
Example code and discussion in StackOverflow:
https://stackoverflow.com/questions/64642612/apache-poi-autosizecolumn-with-sumproduct-and-xssfformulaevaluator-is-not-workin
--
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 64865] Sumproduct evaluation fails when there is cell range inside formula
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64865
PJ Fanning <fa...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |DUPLICATE
Status|NEW |RESOLVED
--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
*** This bug has been marked as a duplicate of bug 60848 ***
--
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 64865] Sumproduct evaluation fails when there is cell range
inside formula
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64865
lauri4848@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
URL| |https://stackoverflow.com/q
| |uestions/64642612/apache-po
| |i-autosizecolumn-with-sumpr
| |oduct-and-xssfformulaevalua
| |tor-is-not-workin
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