https://issues.apache.org/bugzilla/show_bug.cgi?id=47490
--- Comment #1 from Jim Garrison <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
