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/12/29 16:16:02 UTC

[Bug 65040] New: Cell IFERROR don't work with other formula cells with POI

https://bz.apache.org/bugzilla/show_bug.cgi?id=65040

            Bug ID: 65040
           Summary: Cell IFERROR don't work with other formula cells with
                    POI
           Product: POI
           Version: 4.1.2-FINAL
          Hardware: PC
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: sunyiao1994@gmail.com
  Target Milestone: ---

Created attachment 37667
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37667&action=edit
IFERROR Example

When I want to evaluate the formula cell with IFERROR cell, it don't work.

I attached a example Excel File                 
Ex.
In sheet 1 I got
A2 Cell with IFERROR
=IFERROR(SUM(B2,B3,"Some Error Here",aetezt);0)

In sheet2 
I use this IFERROR cell to do a SUM in cell A2:
=SOMME(Sheet1!A2,Sheet1!C2,Sheet1!C3)

POI can't return the result of sheet2 A2 correctly:
Value Actual with POI : 0
Expected Value : 7


Could you please check this and correct it please ?


Best regards,
Yiao SUN

-- 
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 65040] Cell IFERROR don't work with other formula cells with POI

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65040

--- Comment #1 from Yiao SUN <su...@gmail.com> ---
my college added tests and example in ticket
https://bz.apache.org/bugzilla/show_bug.cgi?id=65058
and 
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059

-- 
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 65040] Cell IFERROR don't work with other formula cells with POI

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65040

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

-- 
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 65040] Cell IFERROR don't work with other formula cells with POI

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65040

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|blocker                     |major
                 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