Hi Tom,
this is not about the reason, but about where document the reasons, so
that they can be found by users.
Tom Davies schrieb:
Hi :)
In Calc i get -8 for
=-2^3
and for =2^3
it gives me 8.
My default, try =-3^2
Also the
= 9.87 + 6.54
gives me 16.41. My locale is not set to allow euros at the moment.
I think the Euros problem is likely to be a rounding error if the 9.87 and/or
the 6.54 are the results of calculations. It is possible to bracket
calculations and use functions such as "Round" to round-off extra digits rather
than just using formatting to hide them. Often the "Round" functions tend to
drop numbers such as 9.869 to 9.860, well 9.86 so it's wise to test it and then
maybe add 0.005 before rounding-off. For example
=SUM(D6:D8)/3
would become
=ROUND((SUM(D6:D8))+0.005)
The point here is, where to put such explanations.
Kind regards
Regina
--
Unsubscribe instructions: E-mail to [email protected]
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted
