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

            Bug ID: 150766
           Summary: Incomplete recalculate
           Product: LibreOffice
           Version: 7.4.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
With the steps specified below, cal fails to properly recalculate.

The demo sheet will be provided, but here are the steps to create it:
- column a: sequential numbers from 1 to 9, but swap 4 and 5
(1,2,3,5,4,6,7,8,9)
- b1: 1
- c1: =sum(b$1:b1)
- copy b1:c1 to b2:c9

Steps to Reproduce:
1. Select rows 3 to 6
2. Data -> Sort ascending. The sort completes as expected
3. Change b4 from 1 to 10


Actual Results:
c1:c6 contains correct values. c7:c9 don't
Forcing a recalculate (F9) don't resolve the situation.
Forcing a hard recalculate (ctrl-shift-F9) resolves it.

Expected Results:
Correct auto-recalculation of all cells.


Reproducible: Always


User Profile Reset: No



Additional Info:
Initially observed on the version provided by linux/debian.
Formally tested on Windows 10 in safe mode, after deleting the LibreOffice
folder in appdata/roaming.
No idea if OpenGL is enabled.

Info from help-about:
Version: 7.4.0.3 (x64) / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; 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.

Reply via email to