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 >> >> ------------------------------------------------------------------------ >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> > 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 Fuchs London, England Please reply *only* to [email protected]
