[Libreoffice-bugs] [Bug 95578] A dispersion chart show totally wrong data after updating formulas with F9

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=95578

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jbfaure at libreoffice.org

--- Comment #23 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
Not reproducible for me with LibreOffice 6.0.4 under Ubuntu x86-64 without
OpenCL.

Note: on opening the attachment, the chart does not look the same as attachment
120375. I get a cloud of points roughly aligned. To get the same picture I need
to change to formula in the column C
from 
=F$20*(G$19*A3+SQRT(1-G$19^2)*NORM.S.INV(RAND()))+E$20
to
=F$20*(G$19*A3+SQRT(1-G$19^2)*A3)+E$20
where A3 = NORM.S.INV(RAND())

Each time I hit the F9 key the columns A, B and C are uptaded, then the chart
is updated too. It keeps always the same look of a cloud of points roughly
aligned (an very flat ellipsoid). 

Best regards. JBF

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180617/972b9b48/attachment.html>