Description: Excuse my poor English LibreOffice writer fails in calculations inside table cells when the origin cells are spanned between pages. The bug is easily reproducible: Look this two screenshots. Look the marked cells. The cell in the left column is a formula adding the the nine cells at right column. In the first screenshot, all the cells are in the same page and the calculations is fine. In the second screenshot I had to move the table few lines down and now the cells used for the calculation are spanned in two pages, As you can see, now the formula for a strange reason is adding only the cells in the firs page. This is unexpected behavior Steps to Reproduce: 1.Create a table with two columns and many rows, Merge the cells of the left column. 2. Write numbers in the right cells. Add a Table formula in the left cell adding all the right cells. 3. The result is fine, but if you move the table down in the way that some rows are in firs page and some rows are in second page, the formula only adds the rows in one page Actual Results: If the table rows to add are spanned in two pages, it only add the rows of one page Expected Results: If the table rows to add are spanned in two pages, still should add all the rows of the formula Reproducible: Always User Profile Reset: Yes Additional Info: LibreOffice 24.2.3.2 3 june 2024 Linux Debian Testing amd64 I can send you screenshots where you see clearly the bug
Created attachment 194523 [details] The cells to add are spanned in two pages. The result should be 38 but only adds 16 (the cells tha remains in first page)
Created attachment 194524 [details] The same table. I just added some lines at the start of the page. Now the cells to add are in the same page. The result is fine, 38
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Created attachment 194527 [details] file with a table . The cells to add are spanned in two pages. The formula at left cell add all 10 cells at right.
Created attachment 194541 [details] Sample file The case when not updating is notice is after undo [Ctrl+Z], that is recalculated after click on the cell.
The result is recalculated and updated after click on the cell, but if the cells included in the calculus are spanned in two pages, the result isn't correct.
Thanks for the report. That was a 7.3 regression that is already fixed in the upcoming 24.8 version, see bug 159027. *** This bug has been marked as a duplicate of bug 159027 ***