https://bugs.documentfoundation.org/show_bug.cgi?id=118918
Bug ID: 118918
Summary: F9 does not recalculate sheet correctly
Product: LibreOffice
Version: 6.0.5.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mike.giftr...@btinternet.com
Description:
I have a spreadsheet in which Sheet1 is mostly about calculating random numbers
for x-y coordinates and Sheet2 analyses them and plot then on a graph.
This is attached.
when I press F9 in sheet2 it looks like all the numbers in the sheet are
updated. They all change. I assume this is because Sheet1 changed.
1) I though F9 should not change Sheet1 when I am looking at Sheet 2.
At least that is what is indicated by
https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets
2) Far worse. The data is changed but incorrectly.
Normally I would be hard pressed to spot this but the graph I am drawing is
clearly wrong after pressing F9 but correct after pressing shift-ctrl-F9.
I know it is wrong because light coloured dots should not fall next to dark
dots. Dark dots should not appear at the edge of the graph.
Sadly this is a complex sheet for debugging purposes. I tried a simple sheet
dosing some trivial calc with random numbers but could reproduce the effect.
Steps to Reproduce:
1. open attached sheet
2. switch to sheet2 (plot)
3. press shift-ctrl-F9 to see a correct plot
4. press F9 (best done 4 or 5 times) to see an incorrect plot
5. compare with pressing shift-ctrl-F9 5 times to see a correct plot each time
Actual Results:
light coloured dots and dark dots spread out over graph
light and dark dots next to each other
Expected Results:
light coloured dots at edge of graph - dark dots clustered around (-1,1) (1,1)
(-1,-1) (1,-1). No light dots near dark dots.
Reproducible: Always
User Profile Reset: No
Additional Info:
Sheet was designed to trial a simple algorithm for colour coding dots depending
on how closely clustered they are.
Operating system is Opensuse Leap 42.3
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
