https://issues.apache.org/bugzilla/show_bug.cgi?id=45678
--- Comment #1 from James <[EMAIL PROTECTED]> 2008-08-25 09:29:58 PST --- Brazilian zip codes (ddddd-ddd) and taxpayer registry numbers (ddddddddd-dd) will require custom formats which you can easily add via addFormat(String, java.text.Format). See docs and source for examples of SSN, phone-number, etc. As far as the other problems, can you attach a sample xls that demonstrates the behavior? (In reply to comment #0) > When reading values from number cells, for some type of formatted numbers, > HSSFDataFormatter returns incorrect values: > 1. Simple numbers: adds an underscore after the number in the formatted > string, > using default number format, eg. a cell with the number 4455667788 is > formatted > as a string like '4455667788_'. > 2. Account numbers are formatted with different precision than in Excel, eg. > the number 0,896665 in excel, with 2 digits precision, is shown as 0,90. > HSSFDataFormatter returns 0,896665. The same number, as currency or number is > formatted as it appears in Excel (number, as reported above, adds an > underscore > in the end of the string, it returns '0,90_'. > 3. Fraction numbers always returns the string '1 ??/??'. > The XLS document was generated using Excel 2007 / portuguese, in Excel 97/2003 > format. > Other kind of number formats work fine, like currency, date, hour, percentage, > scientific and phone numbers. > Brazilian zip codes (ddddd-ddd) are formatted as dddddddd- and taxpayer > registry numbers (ddddddddd-dd) as ddddddddddd- -- 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]
