2010/3/5 AG <[email protected]>: > 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. >
What is the exact result on her machine if you increase the number of decimals to maximum? Is she using exactly the same version and build of OpenOffice.org as you are? On my system, OpenOffice.org 3.2 on Ubuntu 9.10, I get the correct result: 225,59000000000000000000 (I use the Swedish version, and we use a comma for decimal separator and a space for thousands separator, in case you wonder about that…). Regards Johnny Rosenberg --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
