[Libreoffice-bugs] [Bug 118918] New: F9 does not recalculate sheet correctly

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: mike.giftrise at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180724/568ae8cd/attachment.html>