sum cells in frozen rows and columns are not always updated

[ferdiga]

CODE - Collabora Office 22.05.10.1 Describe the bug sum cells in frozen rows and columns are not updated, if rows/columns between sum cell and changed data cell are invisible due to scrolling To Reproduce Steps to reproduce the behavior:

1. create a sheet with sum cells in frozen rows
2. lines or columns between data entry cells and sum cells must be "invisible" because of scrolling
3. change a cell content in the sum area (rows 43-45 in the test.xlsx) - some rows must be invisible due to scrolling.
   the row sum is updated, the column sum not - can also be tested with zoom in/out
4. the content of sum cells wich are "separated" by hidden rows/columns due to scrolling are not updated
5. close the sheet and reopen - the sum is correct.

Expected behavior sum cells must always be updated

Actual behavior certain sum cells are not updated - see above

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information)

• OS: maxOS 13.1
• Browser: Brave
• Version: 1.47.186 test.xlsx

Additional context Add any other context about the problem here.

[Ezinnem]

Reproducible in:

COOLWSD version: 22.05.10.1 git hash: 23082d8(E)

However, the sum updates once the Save button is clicked.

https://user-images.githubusercontent.com/54344301/217481901-4a12a85c-af28-4ed9-917e-5e9d3efda257.mp4

[ferdiga]

thanks - nevertheless clicking the save button is a (strange) workaround for those how know the problem

[GulsahKose]

I can reproduce too. Working on this now. Thanks @ferdiga