Bug 64865 - Sumproduct evaluation fails when there is cell range inside formula
Summary: Sumproduct evaluation fails when there is cell range inside formula
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 4.1.1-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL: https://stackoverflow.com/questions/6...
Keywords:
Depends on:
Blocks:
 
Reported: 2020-11-02 11:01 UTC by lauri4848
Modified: 2020-11-02 11:02 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description lauri4848 2020-11-02 11:01:22 UTC
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