https://bugs.documentfoundation.org/show_bug.cgi?id=163441
Bug ID: 163441
Summary: Calc: RECells don't recalculate in some a sheet with
800 random cells, selecting cell affects the issue!
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bugzi...@xqp.co.uk
Description:
Bug relates Calc - automatic and manual recalculation does not recalculate all
cells.
The video https://www.youtube.com/watch?v=i4VqXRRXi68 is a maths problem -
"what is the average distance between two random points in a square?"
I put the equations in and noticed that some cells in a couple of rows at the
bottom of the spreadsheet did not recalculate when changed a cell or when I hit
F9.
I put sum/average checks in, and found that a cell being "selected" affected
whether the affected cells were recalculated.
I reduced the number of rows from 100 to 10 and all cells recalculated as
normal.
I restored the lines and played around; reducing the number of lines by 1 or 5.
The bug reappeared and disappeared.
I couldn't pin down an exact number of lines because that seems to vary, but
it's unaffected by undo/redo edit cycles, and most of the test failures above
were replicated on a duplicated sheet in the same document.
Steps to Reproduce:
--- setup
01. Add headings x1, y1, x2, y2, dx, dy, d
02. Set A1:D1 of =rand() [x1, x2, y1, y2]
03. Set E1=C1-A1 and F1=D1-B1 [dx, dy]
04. Set G1 = SQRT(E1*E1 + F1*f1) [d]
05. Copy row A a further 99 times.
06. Make A102 =SUM(B2:B101), and A103 =AVERAGE(A2:A101)
07. Copy A102:A103 across to column G
08. Set E104 to =E102/E103 and copy across to column G
--- test 1 - cells dont' recalculate
09. All of E104:G104 should be 100
10. Hit F9: All cells update, E102:G103 DO NOT recalculate.
--- test 2 - clicking into an affected cell fixes the recalculate
11. Click any cell in E102:G103
12. Hit F9: The clicked cell updates, the rest of E102:G103 DO NOT
13. The check in row 104 below the clicked cell is NOT 100
--- test 3 - clicking out of the affected cell breaks the recalculate
14. Click elsewhere, eg E104
15. Hit F9: All cells update, E102:G103 DO NOT recalculate.
--- test 4 - deleting rows fixes the recalculate
16. Delete 5-10 rows from the top of the sheet.
17. Hit F9. All cells update and E102:G103 DO recalculate.
18. All of E104:G104 should be 95
--- test 5 - replacing the rows breaks the recalculate
19. Press Ctrl-Z
20. Hit F9. All cells update and E102:G103 DO recalculate, but this only
happens once.
21. All of E104:G104 should be 100
22. Hit F9: All cells update, E102:G103 DO NOT recalculate.
--- test 6 - ctrl-Y, ctrl-Z fixes/breaks the recalculate
23. Hit Ctrl-Y, F9 works as expected. Hit Ctrl-Y, F9 works once then it doesn't
--- end of tests
Actual Results:
Some of the cells in the spreadsheet do not recalculate.
Expected Results:
I expected all of the cells in the spreadsheet to recalculate.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
I opened another instance of Calc and followed the instructions under setup in
"Steps to Reproduce".
The erroneous behaviour was present in that sheet too, so I am confident this
is a real bug in spite of the fact that it's the first time I've seen such
behaviour in ~35 years.
I will attach the original .ods file and the one I used to test my
instructions. The latter is "clean" - no edits other than those required to
enter the data.
I "restarted in safe mode"; the faulty behaviour *is* present in the 2nd file.
--
You are receiving this mail because:
You are the assignee for the bug.
