https://bugs.documentfoundation.org/show_bug.cgi?id=146573
Bug ID: 146573 Summary: Writer table formulas involving cells with footnotes are not recalculated consistently Product: LibreOffice Version: 7.2.4.1 release Hardware: All OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Writer Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: will.fried...@gmail.com Description: In a table with cells containing ordinary numbers, formulas involving that cell recalculate immediately upon exiting the cell. If there is a footnote in a table cell, however, formulas involving that cell don't recalculate unless the user leaves the table and returns to it OR adds an additional row to the table. If the footnote is deleted, however, the formula involving the cell is recalculated immediately! This behavior is inconsistent and confusing. Steps to Reproduce: 1. Create a table with 1 row and 2 columns. 2. Put a number in the first cell. 3. In the second cell, enter the formula =<A1>. 4. Return to the first cell and change the number. The second cell does not change. 5. Press tab or click on the second cell. The second cell is recalculated to match the first cell. 6. Return to the first cell. Insert a footnote. Change the number in the cell. 7. Press tab or click on the second cell. The second cell is *not* recalculated to match the first cell. 8. Click outside the table. Notice that the second cell is *still* not recalculated. 9. Click inside the table. Notice that the second is *finally* recalculated. 10. Change the number in the first cell again. Add a row, either by tabbing past the second cell or Table | Add Row or right-clicking and hitting Add Row. Notice that the second is recalculated. 11. Return to the first cell. Change the number again. Delete the footnote. Notice that the second cell is recalculated *immediately*. Actual Results: Changing the number in a cell with a footnote does not change an associated formula in predictable, consistent ways. Expected Results: Changing the cell with the footnote should cause a formula involving that cell to be recalculated consistently, as if the cell did not have a footnote in it. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.2.4.1 (x64) / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.