https://bugs.documentfoundation.org/show_bug.cgi?id=153598
Bug ID: 153598
Summary: Recalculate does not recalculate all cells
Product: LibreOffice
Version: 6.1.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When there is a large amount of data (hence a lot of recalculation is needed),
Calc is sometimes "lazy" to recalculate all the formulas. Instead of attaching
a large spreadsheet, here is a description to make one quick:
>From A1 to AD500 (1500) cells) put =RAND().
>From A502 to AD502 put =AVERAGE(A..AD1:A..AD500) (i.e. the average of the cells
above it)
>From AJ1 to AJ500 put =AVERAGE(A1..500,AD1..500) (i.e. the average of the cells
on its left)
AF502 should be =AVERAGE(A502:AD502) (i.e. the average of the vertical
averages)
AJ502 should be =AVERAGE(AJ1:AJ500) (i.e. the average of the horizontal
averages)
AH502 should be =+AF502-AJ502 (i.e. always ZERO)
Now pressing F9 repeated times, depending which cell is active, only some of
the averages are recalculated and AH502 gets non-zero values.
If I click into the big part of the spreadsheet then the A502..AD502 cells are
recalculated and AF502 and AH502, but not AJ1..AJ500 and AJ502.
If I click into the A502..AD502 range then it is the same as above.
If I click into an empty cell it is again the same as above.
BUT
If I click into AJ1..AJ500 then everything is recalculated as it should be and
AH502 is always zero.
Thanks for looking into it.
P.S: I know it is not the latest Calc, but Debian 10 has it as the latest.
--
You are receiving this mail because:
You are the assignee for the bug.
