https://bugs.documentfoundation.org/show_bug.cgi?id=95578
Bug ID: 95578
Summary: A dispersion chart show totally wrong data after
updating formulas with F9
Product: LibreOffice
Version: 5.0.3.2 rc
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 120266
--> https://bugs.documentfoundation.org/attachment.cgi?id=120266&action=edit
The sheet is now Ok, but press F9 twice and the chart goes berserk
Open the attached file. It contains a simulation of random numbers extraction
from a bivariate normal distribution. the simulated data are shown in a chart
(dispersion type) to the right of the data columns.
Being simulated data based on pseudo-random functions, everything is changed
and updated anytime you insert, delete or edit anything in the spreadsheet.
Everything is well in this case, in the sense that the single points of course
change but the general shape of the data cloud stays the same, as a rough
increasing quasi-line as it is expected, since you have a 0.98 correlation
coefficient.
Also, if you press CRTL+SHIFT*F9, everything is updated correctly as above.
Now press F9, first time the update seems Ok, but... from the 2nd time and on,
the chart changes shape abruptly, and shows a different data cloud, which does
NOT mirrors the data it is supposed to show! And the shape of the cloud now
looks like the 2 variables were uncorrelated (points spread everywhere). You
can go on as much as you like to press F9, the chart changes but the data shown
never are those in the linked columns.
However, if you go back to press ctrl+shift+F9, the chart goes back to normal.
But use again F9 twice, and you end up AGAIN WITH A WRONG CHART.
I had the knowledge that the difference between F9 and ctrl+shift+F9 was that
the first updated the active sheet, while the second updated all sheets in the
file, and updated also formulas whose inputs did not change. These have clearly
nothing to do with this case, since there is just one sheet here, and the
random function is rand() which is updated by F9 as well.
So I have no way to explain the erratic behaviour you get pressing F9, and I
think it is a bug.
I discovered this during a lecture to my students, and it was quite
embarassing, unfortunately.... thanks for the attention
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
