Hi :) In Calc i get -8 for =-2^3 and for =2^3 it gives me 8. 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) There probably is an agreed standard to the way particular functions such as that are handled but proprietary products tend to break such agreements and then keep that secret so that people are confused when the standards are adhered to, hence various arguments in this mailing-list. OpenSource products can have errors and mob-rule can over-ride most things but at least they don't try to hide it either way even if it hurts them. So, it's worth checking by testing before relying on results. Regards from Tom :) ________________________________ From: Regina Henschel <[email protected]> To: [email protected] Sent: Fri, 10 June, 2011 21:02:24 Subject: [libreoffice-documentation] Re: Collecting small things in the Wiki Hi planas, planas schrieb: > Regina > > On Fri, 2011-06-10 at 19:21 +0200, Regina Henschel wrote: > >> Hi documentation members, >> >> I'm looking for a place to collect little tips and explanations, for >> example "Why results the formula =-2^3 in 9?" or "Calc calcutates wrong! >> 9.87€ + 6.54€ results in 16.42€." >> >> And also a place for HowTos, which are not a FAQ and which are to small >> for a guide, but might be useful. For example an explanation, how to get >> the coefficients of an interpolation polynomial. >> >> It should be outside of your documentation workflow and needs to be >> easily edited, but have a basic predefined structure. >> >> Kind regards >> Regina > > > > Could this be integrated with the blog. We have a few how to blogs > already. If it is "blog" as I understand blogs, then it will not be suitable. It is necessary, that it can be edited. It must be possible to correct errors, to add or remove something later on, to write mathematical content, to add pictures. I think any LO related topic could be discussed in a blog or > wiki. The difference, I believe, is the target with the blog being > straightforward how-tos or why-tos and the wiki having more depth for > topics. Please have a look at our German Wiki http://www.libreofficewiki.de/. I look for something similar in English. 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
