> -----Original Message----- > From: AG [mailto:[email protected]] > Sent: Friday, March 05, 2010 12:21 > To: [email protected] > Subject: Re: [users] Problem with sum in Calc > > 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. > I know this sounds stupid, but have you tried copying your spreadsheet to her computer and loading it there in OO. Sometimes a spreadsheet can become corrupted (power spike, etc) while you are saving it and do weird things like round down, etc.
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
