https://bz.apache.org/bugzilla/show_bug.cgi?id=65792
--- Comment #4 from caoxj <[email protected]> --- (In reply to PJ Fanning from comment #2) > Use DataFormatter to format the cell - the result is stored in double format > and that can lead to rounding issues (but this is also required to match how > Excel works) The problem does not occur when getting the value, but after calculating the sheet and saving the Excel file, when opening Excel file with Micro Excel, the invalid value calculated by POI is displayed. 1. calculating all cell of sheet(POI) 2. saving the Excel file(POI) 3. opening Excel file with Micro Excel(Micro Excel) 4. invalid value of a cell(value:2490399) 5. Double-click on the cell and press enter and the value is displayed correctly(value:2490400) So the formatting method is not available. -- 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]
