Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


Hi,
It behaves more or less the same in Excel 2003 in Win7.

http://shared.59551.x6.nabble.com/Error-or-Same-thing-in-Excel-td3.html

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! :)

/erik


On 2014-02-03 21:48, marianne-x wrote:
Interesting, if unsavoury, behaviour. I can confirm the identical results from /Curtains 7/, and LO 4.1.4.2. 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, 4.0.6.2, 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.

trj

On 3 February 2014 06:21, Erik Erlandsson (Nilhe AB) <
erik.erlandsson@nilhe.se> wrote:

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 different in
other installations.

I'm using  Version: 4.1.4.2 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: users+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.