https://issues.apache.org/bugzilla/show_bug.cgi?id=45593
Josh Micich <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
--- Comment #12 from Josh Micich <[EMAIL PROTECTED]> 2008-08-19 01:14:42 PST
---
(In reply to comment #10)
Note that there is a difference between a text cell with value "5" and a
numeric cell with value 5.0. In the excel UI, the user can choose either text
or numeric format when entering cell values. Text values can be forced by
prepending a single quote (') to the entered text. For example '5 will create
a text value "5".
The sample code I added in comment #1 uses numeric cells:
cell.setCellValue(5.0);
... which Excel/SUM() handles 'normally'.
Your sample code (from attachment id=22415) uses text cells:
cell.setCellValue(new HSSFRichTextString("5"));
... which Excel/SUM() ignores.
I am still sure that POI is consistent with Excel's behaviour
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
