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.
