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 2009/11/24 09:38:47 UTC

DO NOT REPLY [Bug 48269] New: [PATCH] Exception occurs while try getErrorCellString() from XSSFCell

https://issues.apache.org/bugzilla/show_bug.cgi?id=48269

           Summary: [PATCH] Exception occurs while try
                    getErrorCellString() from XSSFCell
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: Petr.Udalau@exigenservices.com


When we try get error code from the cell with contains formula that returns
Error we get exception:
java.lang.IllegalStateException: Cannot get a error value from a formula cell
    at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:781)
    at
org.apache.poi.xssf.usermodel.XSSFCell.getErrorCellString(XSSFCell.java:580)
    at
org.apache.poi.xssf.usermodel.XSSFCell.getErrorCellValue(XSSFCell.java:596)


It is caused by wrong type identification in method getErrorCellString().

Solution for this problem and simle test see in attachment.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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

DO NOT REPLY [Bug 48269] [PATCH] Exception occurs while try getErrorCellString() from XSSFCell

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

Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #2 from Nick Burch <ni...@torchbox.com> 2009-11-25 03:33:30 UTC ---
Thanks for this, applied to trunk in r884058.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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

DO NOT REPLY [Bug 48269] [PATCH] Exception occurs while try getErrorCellString() from XSSFCell

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

--- Comment #1 from Petr.Udalau <Pe...@exigenservices.com> 2009-11-24 00:48:05 UTC ---
Created an attachment (id=24601)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24601)
Fix.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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