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: lauri4...@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-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
