It behaves more or less the same in Excel 2003 in Win7.
The formula is from a book on chaos, it describes a way to simulate a
controlled chaotic sequence:
" take a number, a fraction between zero and one, and double it. Then
drop the integer part, the part to the left of the decimal point. Then
repeat the process. Since most numbers are irrational and unpredictable
in their fine detail, the process will just produce an unpredictable
sequence of numbers."
I expected something unpredictable, but not this! :)
On 2014-02-03 21:48, marianne-x wrote:
Interesting, if unsavoury, behaviour. I can confirm the identical
results from /Curtains 7/, and LO 18.104.22.168. Line 28 marks the spot.
On a second /Curtains 7/ machine, LO deficiencies do not permit
installation of main-line LO, but the "portable" version, 22.214.171.124,
behaves in the same way.
Since LO is not allowed on that 2nd machine, routine work there is
done with OO 3.3.0, and it, too, behaves identically on this test.
Perhaps someone with access to M$ will try the experiment there, to
see how universal this phenomenon is.
On 3 February 2014 06:21, Erik Erlandsson (Nilhe AB) <
Im seeing this "odd" behavior in a series. Around line 30 additional
decimals are showing up
What am I doing wrong?
Enclosing both screen-shot and spreadsheet as it might look
I'm using Version: 126.96.36.199 Build ID: 410m0(Build:2) in Linux debian
3.12-1-amd64 #1 SMP Debian 3.12.6-2 (2013-12-29) x86_64 GNU/Linux
With kind regards Erik Erlandsson
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy