Re: [libreoffice-users] The way SUM works

2012-02-21 Thread CHAILLET Jacques
Le 20/12/2011 22:28, Dominik Wnęk a écrit : Hello, I have a problem with the way SUM works. At first I thought this was a bug, but then I saw Numbers on my iPad doing the same thing, so now I believe this is by design, but I have no idea why and how I can work around this. Take a look at

Re: [libreoffice-users] The way SUM works

2011-12-21 Thread Steve Edmonds
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

Re: [libreoffice-users] The way SUM works

2011-12-21 Thread Don Myers
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

Re: [libreoffice-users] The way SUM works

2011-12-21 Thread Steve Edmonds
On 22/12/11 1:41 AM, Don Myers wrote: 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

Re: [libreoffice-users] The way SUM works

2011-12-21 Thread Don C. Myers
On 12/21/2011 03:33 PM, Steve Edmonds wrote: On 22/12/11 1:41 AM, Don Myers wrote: 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

Re: [libreoffice-users] The way SUM works

2011-12-20 Thread nvrk
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

Re: [libreoffice-users] The way SUM works

2011-12-20 Thread Jay Lozier
On 12/20/2011 05:32 PM, 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

Re: [libreoffice-users] The way SUM works

2011-12-20 Thread James Knott
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

Re: [libreoffice-users] The way SUM works

2011-12-20 Thread Brian Barker
At 22:28 20/12/2011 +0100, Dominik Wnek [sorry: plain text won't do your ogonkiem] wrote: I have a problem with the way SUM works. At first I thought this was a bug, but then I saw Numbers on my iPad doing the same thing, so now I believe this is by design, but I have no idea why and how I

Re: [libreoffice-users] The way SUM works

2011-12-20 Thread Don Myers
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