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

--
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