https://bz.apache.org/bugzilla/show_bug.cgi?id=65792
--- Comment #9 from caoxj <[email protected]> --- (In reply to PJ Fanning from comment #8) > While this issue does show some issues with how POI multiplies numbers and > small rounding issues that occur - I think this would be a lot less of a > problem if the user used the ROUND function instead of INT. > > INT(1.99999) comes out as 1 but ROUND(1.99999, 0) is 2 - ROUND is more > forgiving of rounding issues. I am soory! The ROUNDDOWN function is known to solve this issue, but the Excel file is used as a contract and cannot be modified. I want a fixed version of this issue of ver3.17, is it possible? -- 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]
