To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111533
------- Additional comments from [email protected] Wed May 12 04:52:47 +0000 2010 ------- Ok. Considering all our options, I think Niklas' suggestion is probably our best compromise. I still would have liked to show trailing zeros when the number is rounded, but due to binary floating-point rounding error, supporting that reliably would probably be very difficult (I've tried). For instance, the moment you enter a value of 449.1 into a cell, that number already becomes 449.100000000000002273737 internally, represented by double-precision. There is no way of knowing whether that number is as typed by the user, or altered due to binary rounding error. We could track the number of decimals as typed, but carrying that extra information around while calculating formulas would probably affect the calculation speed negatively. I wouldn't want that. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
