Re: [libreoffice-users] The way SUM works

> On 21/12/11 5:18 PM, Don Myers wrote:
> > On 12/20/2011 08:27 PM, James Knott wrote:
> > > nvrk wrote:
> > > > The number displayed in a Calc cell is limited in decimal places by 
> > > > the
> > > > formatting preference.  Set the number format for the cells to show 
> > > > more
> > > > decimal places and see the results.
> > > >
> > > > In your case the sum calculation is based on the actual multiplication
> > > > result in the individual cells to a large number of decimal places, 
> > > > and
> > > > then the displayed sum shortened to show the decimal places set by the
> > > > formatting preference.
> > > >
> > > > The (sum of the original entries) multiplied by (1,22) displayed to 
> > > > two
> > > > decimal places is not likely to display exactly the same as the sum of
> > > > (individual entries) multiplied by (the same multiplier).
> > >
> > > That pretty well SUMs it up.  ;-)
> > Hi,
> >
> > There is a setting for calc where you can have the total as shown and 
> > not as calculated:
> >
> > Settings
> >
> > Go to tools, options, calc, calculate, and check the box "Precision 
> > as Shown"
> >
> > Don
> Is this saved on a per spreadsheet basis or is it global (do I need to 
> change it back and forth, if I open 2 sheets can one be "Precision as 
> Shown" and the other normal.
> steve
Steve,

That is a global setting.

Don
--

*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Phone: 814-237-6543 Fax: 814-237-6502
Visit the Farm and Rural Property Division Website at 
www.cbur-ruralproperty.com <http://www.cbur-ruralproperty.com/>_
_View Don's farm website: www.myersfarm.com <http://www.myersfarm.com/>
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted