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