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 2016/04/06 10:37:10 UTC

[Bug 59278] New: Inconsistent behavior for Cell.getErrorCellValue on blank cells

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

            Bug ID: 59278
           Summary: Inconsistent behavior for Cell.getErrorCellValue on
                    blank cells
           Product: POI
           Version: 3.15-dev
          Hardware: PC
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: onealj@apache.org

Consistency between HSSFCell, XSSFCell, and SXSSFCell:

HSSFCell throws an error on blank cells despite the javadocs saying 0 is
returned. 
XSSFCell throws an error on blank cells.
SXSSFCell returns 0 on blank cells.

If we upgrade getErrorCellValue() from returning a byte to a FormulaError enum,
then we would either need to add an enum value corresponding to "no error" or
make the functions throw type mismatch (InvalidStateException) like the other
cell types. I'm in favor of making SXSSFCell behave the same as HSSFCell and
XSSFCell here and updating the documentation.

-- 
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 59278] Inconsistent behavior for Cell.getErrorCellValue on blank cells

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement

-- 
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 59278] Inconsistent behavior for Cell.getErrorCellValue on blank cells

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

--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
I think that fetching an error value from a non-error cell should behave like
fetching a string value from a non-string cell. So, I'd vote for updating the
javadocs and having the InvalidStateException in SXSSF

-- 
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