On Jul 14, 2009, at 12:45 PM, Per wrote:
Is it a sort of handling the numbers in Works, Calc and Excel that causes the round-up effect???
I think these results are more correctly called "truncation" and result from the inherently limited numerical precision of digital computers. It's not surprising that Excel and Calc exhibit the same problem if they use the same precision (i.e., single, double, whatever) for storing numbers in whatever programming language(s) they're written in. This conclusion implies that Calc per se (e.g., a bug) wasn't to blame for the problem Dotan's employer encountered. It was, instead, due to unawareness of this fundamental limitation.
Dave --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
