Bug 105312 - Writer: Update formula references when renaming referred table
Summary: Writer: Update formula references when renaming referred table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
: 145926 (view as bug list)
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
Reported: 2017-01-13 12:35 UTC by Mike Kaganski
Modified: 2021-12-15 17:56 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2017-01-13 12:35:00 UTC
If a formula in Writer table references a cell in another table, and that other table is renamed, then the reference in formula isn't updated.

Steps to reproduce:
1. Create a new Writer document.
2. Add a table (automatically named like "Table1").
3. In cell A1, put value 1.
4. Add another table below.
5. In the second table's A1, press F2 and enter formula "=<Table1.A1>".
6. Rename Table1 to Table11.

Expected: formula in second table now is "=<Table11.A1>".
Actual: the formula stays "=<Table1.A1>", value is "** Expression is faulty **".

This is inconsistent with Writer's behavior when the referred table's rows/columns are deleted/inserted. In this latter case, the formulas in other tables are automatically update their external cell references.
Comment 1 Buovjaga 2017-01-23 15:32:20 UTC

Arch Linux 64-bit, KDE Plasma 5
Build ID: 63fd4c97118a943c84ba5a666cf8c9cc54b511c7
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on January 22th 2016
Comment 2 Dieter 2021-12-15 17:53:39 UTC
*** Bug 145926 has been marked as a duplicate of this bug. ***
Comment 3 Dieter 2021-12-15 17:56:49 UTC
Still present in

Version: (x64) / LibreOffice Community
Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-GB
Calc: CL

You can use attachment 176916 [details] for testing

I don't understand, why this is an enhancement. If you recieve an error message it is clearly a bug. Mike, feel free to change it back to enhancement with a short reasoning, if you disagree.