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 can work around this. Take a look
at this example:
http://www.ode2.com/images/libreoffice_sum.tiff
The number format is currency (Polish Zloty),
the numbers in the left column are entered by
hand, the ones in the right one are calculated
by multiplying the left number by 1,22. The sum
of the numbers in the right-hand column should
be -1199,62, but it is off by 0,02 zÅ. It's
pretty obvious this is because the program sums
the numbers it has in memory and not the ones it
displays. If this behaviour is correct, how can
I work around this? I just spent 40 minutes
trying to find out why my balance is wrong only
to find out the sums I was doing were giving me incorrect amounts
As has already been suggested, if these are
currency amounts you should think twice about
multiplying by 1.22 without any extra
care. Setting the cell formatting to Currency
affects the display but not calculation. You may
want to ensure that the calculated amounts as
stored are explicitly rounded in whatever way is appropriate.
But if you prefer, you can tell LibreOffice to do
exactly what you want: to calculate using the
values displayed, not those stored. To do this,
go to Tools | Options... | LibreOffice Calc |
Calculate, and tick "Precision as shown".
I trust this helps.
Brian Barker
--
For unsubscribe instructions e-mail to: [email protected]
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
