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