Re: [libreoffice-users] Error or what?

2014-02-04 Thread Mark Bourne
Brian Barker wrote: At 06:56 04/02/2014 +0100, Erik Erlandsson wrote: Still, ticking Precision as shown does no difference at all to the result even after closing and reopening. That's odd, as it's not how it behaves for me and definitely not how it is supposed to work. It may depend a bit

Re: [libreoffice-users] Error or what?

2014-02-03 Thread Sigrid Carrera
Hi Erik, could you please upload your screenshots somewhere and give us the link? Attachments are automatically removed, so we don't see what you've sent. /Sigrid On 3 February 2014 06:21, Erik Erlandsson (Nilhe AB) erik.erlands...@nilhe.se wrote: Im seeing this odd behavior in a series.

Re: [libreoffice-users] Error or what?

2014-02-03 Thread Erik Erlandsson (Nilhe AB)
Hi all, Thanks for the tip! I hope this works: http://shared.59551.x6.nabble.com/Error-or-td2.html /erik Sigrid Carrera skrev 2014-02-03 09:58: Hi Erik, could you please upload your screenshots somewhere and give us the link? Attachments are automatically removed, so we don't see what you've

Re: [libreoffice-users] Error or what?

2014-02-03 Thread marianne-x
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

Re: [libreoffice-users] Error or what?

2014-02-03 Thread Brian Barker
At 06:21 03/02/2014 +0100, Erik Erlandsson wrote: I'm seeing this odd behavior in a series. Around line 30 additional decimals are showing up What am I doing wrong? At 20:29 03/02/2014 +0100, Erik Erlandsson (Nilhe AB) wrote: I hope this works:

Re: [libreoffice-users] Error or what?

2014-02-03 Thread Erik Erlandsson (Nilhe AB)
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.

Re: [libreoffice-users] Error or what?

2014-02-03 Thread Erik Erlandsson (Nilhe AB)
Thanks Brian! I realize that it is a rounding error that adds the decimals. It actually behaves similarily with percision as shown But mystery 2 still stays, why does the function kill itself from line 50+ ? The spreadsheets are enclosed in the postings on nabble, link below image. Best /erik

Re: [libreoffice-users] Error or what?

2014-02-03 Thread Brian Barker
At 22:56 03/02/2014 +0100, Erik Erlandsson wrote: On 2014-02-03 22:20, Brian Barker wrote: At 06:21 03/02/2014 +0100, Erik Erlandsson wrote: I'm seeing this odd behavior in a series. Around line 30 additional decimals are showing up What am I doing wrong? At 20:29 03/02/2014 +0100, Erik

Re: [libreoffice-users] Error or what?

2014-02-03 Thread Erik Erlandsson (Nilhe AB)
Hi Brian, Initially I thought it was a bug, but now I understand more or less what is happening in both mysteries Still, ticking Precision as shown does no difference at all to the result even after closing and reopening. I rest my case, thank you for the education! /e On 2014-02-04

Re: [libreoffice-users] Error or what?

2014-02-03 Thread Brian Barker
At 06:56 04/02/2014 +0100, Erik Erlandsson wrote: Still, ticking Precision as shown does no difference at all to the result even after closing and reopening. That's odd, as it's not how it behaves for me and definitely not how it is supposed to work. It may depend a bit on precisely what

[libreoffice-users] Error or what?

2014-02-02 Thread 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 different in other installations. I'm using Version: 4.1.4.2 Build ID: 410m0(Build:2) in Linux debian 3.12-1-amd64