DO NOT REPLY [Bug 47490] HSSFDataFormatter.createFormat(double,int,string) does not handle '@' format

[bu...@apache.org]

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





--- Comment #1 from Jim Garrison <jg...@troux.com>  2009-07-07 14:34:57 PST ---
After more research on Excel 2003, I've discovered the following.  

If you take a numeric cell and apply the 'Text' format to it, Excel DOES NOT
change the cell's internal representation to String.  So you end up with
something POI reads as numeric but the user believes is a String, because it's
left justified.  However if you export the spreadsheet as XML at this point you
will see that the cell still has a numeric type.  

While the cell is in the weird 'display as text but really still a number'
state, Excel seems to use a left-justified version of General format, and still
performs numeric display adjustments such as rounding if the column is too
narrow for all the decimal places, or switching to scientific notation if the
column is too narrow for the magnitude.

If you make any changes to the cell, even a null change such as clicking in the
formula bar and then clicking the green checkmark (or pressing Enter), then
Excel converts the stored value to text and attaches the green warning triangle
to the top left corner of the cell.  At this point the cell really contains
text.

What I think needs to happen is that a numeric cell with format '@' needs to be
formatted as "General".

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