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 enhancement
Assignee: Not Assigned
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
Reported: 2017-01-13 12:35 UTC by Mike Kaganski
Modified: 2019-01-16 13:24 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


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