To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=88429
------- Additional comments from [EMAIL PROTECTED] Tue Apr 22 18:56:21 +0000 2008 ------- > in Calc: > =ROUNDDOWN(10*(x - 8)), where x = 8.1 to 9.0 > > will always yield a number less than the expected value. Actually, I am wrong. I cannot reproduce the wrong result for every number. Calc fails only for some numbers, like 8.1 and 8.2. The matrix I have attached did demonstrate this. Calc performs extensive rounding internally, so that numbers close to integers (and sometimes even less close) are rounded to the integer value. This explains the accurate result even for 8.6 and 8.7, where other programs - even with greater precision than Calc, yield a different result. Calc's extensive rounding can be viewed both good and bad. I do not have a strong opinion (for statistics on large data sets, this may be detrimental, but for usual spreadsheet applications having an integer result is probably the better alternative). PROBLEM ======= The problem with my first calculation stems from the way Calc fills a series, see the 2nd spreadsheet attached. When using the automatic fill option, the resulting numbers (8.3 to 8.9) are computed wrongly and aren't quite the same numbers as when typed by hand. I think this is a bug in its own. I wasn't aware until now about this behaviour. It may make sense, but is very counterintuitive and creates a lot of trouble later, because most users won't suspect that these numbers are actually very different from the "should-be" numbers. --------------------------------------------------------------------- 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]