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

            Bug ID: 123120
           Summary: Bug: Calc fails to recalculate dependent cells
           Product: LibreOffice
           Version: 6.2.0.2 rc
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
Calc fails to recalculate dependent cells (see steps to reproduce below).
Version: 6.2.0.2
Build ID: 2ce5217b30a543f7666022df50f0562f82be0cff
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-GB (en_GB); UI-Language: en-GB
Calc: threaded

Steps to Reproduce:
1. Open bug 3 (attached)
2. Delete contents of g.X6 (note g.X16 remains =16, which is incorrect)
3. Select c.W281 (it equals 35, which is incorrect)
4. Press F9 (nothing happens)
5. Press F9 again c.W281 changes to 34 (which is correct)

I attach the spreadsheet bug 3 (also the macro code which is not executed in
the steps above but which you might need).
6. g.X16=13 (which is correct).

Actual Results:
See above

Expected Results:
See above


Reproducible: Always


User Profile Reset: Yes



Additional Info:
This appeared only when I upgraded to 6.2. I had a similar problem about five
years ago (I've looked for and can't find the bug report). Both the current and
old problem seemed to occur with the very complex spreadsheet attached.

I ran it in safe mode, the same bug appeared except that only one, not two,
presses of F9 were needed to perform the recalculation.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to