Bug 137817 - Calc doesn't recalculate formulas in rows 20 and below
Summary: Calc doesn't recalculate formulas in rows 20 and below
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-10-28 12:29 UTC by Ivan Milosavljevic
Modified: 2020-10-28 12:38 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Ivan Milosavljevic 2020-10-28 12:29:20 UTC
Calc recalculates formulas only in the first 19 rows of a sheet. Formulas in rows 20, 21 etc. aren't recalculated.

Steps to Reproduce:
1. Enter 100 in cell A5
2. Enter 3 in cell A18
3. Enter formula =A18-A5 in cell A19
4. Enter formula =A19 in cell A20
5. Enter formula =A18-A5 in cell A21
6. Change value in A5 from 100 to 1000

Actual Results:
After step 5, cells A19, A20 and A21 all show -97. After step 6, cell A19 shows -997, but cells A20 and A21 still show -97.

Expected Results:
After step 6, cells A20 and A21 should also show -997 (i.e. formulas should be recalculated).

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64)
Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 [REDACTED] 2020-10-28 12:38:48 UTC

*** This bug has been marked as a duplicate of bug 137248 ***