https://bugs.documentfoundation.org/show_bug.cgi?id=105312
Bug ID: 105312
Summary: Writer: Update formula references when renaming
referred table
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Writer
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs