Harold Fuchs wrote:
On 3 March 2010 19:36, AG <[email protected]> wrote:
JOE Conner wrote:
On 3/3/2010 10:52 AM, AG wrote:
11.73 + 7 + 15.75 + 24.68 + 17.5 + 21.18 + 20.65 + 17.85 + 19.25 + 23.1 +
12.6 + 10.5 + 23.8
TOOLS -> OPTIONS -> OPENOFFICE.ORG CALC -> CALCULATE -> Right Panel, do
you have PRECISION AS SHOWN checked on one of the machines?
Joe Conner, Poulsbo, WA USA
<snip>
Joe
Cheers for the rapid response. Neither of our machines had that option
enabled. However, even after enabling the "precision as shown" the error
persists on my partner's version of Calc.
Thanks
AG
Were the numbers entered directly from the keyboard or are they the results
of calculations based on other data within the spreadsheet? If the latter,
the chances are it's a rounding error. Try increasing the number of decimal
places shown in the columns/rows in which the numbers apppear. That will
show how your numbers have been rounded, if at all. Adding the more precise
values and rounding the result may reveal the problem.
Harold
Apologies for the delay in responding. Thanks for the idea - my partner
was ahead of me there and had already tried it to five decimals in an
attempt to track it. The numbers were entered manually - i.e. not
copied and pasted - so there should not have been any chance of a
formatting error creeping in.
Still drawing a blank - and it appears to be happening as well on other
spreadsheets she is using, both for work as well as for testing these
problems. Again, on my machine, all of the sheets add up to what they
should do, so the problem is local to either her machine (perhaps the
motherboard system clock is off, which may impact) or the build of the
OOo is corrupted (although this seems such a minor corruption to have
gotten through). In short, we are both still stumped, so further ideas
and suggestions are most welcomed.
