[Libreoffice-bugs] [Bug 137817] New: Calc doesn't recalculate formulas in rows 20 and below

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137817
           Summary: Calc doesn't recalculate formulas in rows 20 and below
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ivan.mile at gmail.com

Description:
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: 7.0.2.2 (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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201028/254adf08/attachment-0001.htm>