Re: [libreoffice-users] Re: LOcalc shows an inaccurate output when use cells autofill function

On 10/5/2011 9:59 AM, Pedro wrote:
> That is not a bug. As someone told me long ago:  "This is a natural
> consequence of doing calculations with finite precision. (And, in this case,
> using base 2.)"
>
> If you try the same in Excel, Gnumeric or any other spreadsheet you will get
> the same (or similar) errors around 4.1 or 4.0
>
> You can do a workaround but I think there is no solution...
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/LOcalc-shows-an-inaccurate-output-when-use-cells-autofill-function-tp3397081p3397167.html
> Sent from the Users mailing list archive at Nabble.com.
Perhaps the attached XNumbers spreadsheet can help.
Joe Conner, Poulsbo, WA USA

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