Download it now!
Bug 83196 - TABLE: reference from one table to another is broken, when renaming the table
Summary: TABLE: reference from one table to another is broken, when renaming the table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Fields-Cross-Reference
  Show dependency treegraph
Reported: 2014-08-28 14:10 UTC by Oliver
Modified: 2019-06-16 06:24 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

example with 2 table with reference from table2 to cell in table1 (9.92 KB, application/vnd.oasis.opendocument.text)
2014-08-28 14:10 UTC, Oliver

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver 2014-08-28 14:10:58 UTC
Created attachment 105385 [details]
example with 2 table with reference from table2 to cell in table1

Problem description: 
renaming table1 breaks references to other table which refers to table1

Steps to reproduce:
1. create a table and fill in a cell a number
2. create a second table and fill in a cell a reference to the cell with number in table1
3. rename table1

Current behavior:
the reference in table 2 to the cell in table 1 get lost

Expected behavior:
reference to cell in table1 shall refer to cell in renamed table1

Operating System: Ubuntu
Version: release
Comment 1 Robert Großkopf 2014-08-28 14:55:52 UTC
I could confirm the bug.

Set the value from the first table to '25'.
Set the cursor in the second table. Changes to '25'.
Connection works.

Put the cursor in the first table.
Chose properties of the table and rename it.
Set the cursor to the second table, where '25' is shown now.
'25' changes to '0', connection to <table1.c3> is shown, which doesn't exist any more.
This doesn't work in any LO-version. 
The first versions up to the first release gives an error:
** Expression is faulty **
This is a little bit better than only writing '0' in a field, where no content could appear.
All other versions will return '0'.
Comment 2 GwenDragon 2014-08-28 15:32:33 UTC
Confirmed for LO Build-ID: 61cb170a04bb1f12e77c884eab9192be736ec5f5 on Windows 7
Comment 3 Alex Thurgood 2014-08-29 08:28:11 UTC
As far as I can remember, this was always so, even in the days of StarOffice, so it might well be that the code path for dealing with this has never existed.
Comment 4 QA Administrators 2015-09-04 02:47:50 UTC Comment hidden (obsolete)
Comment 5 Buovjaga 2015-11-18 11:02:17 UTC
Still repro.

Win 7 Pro 64-bit Version:
Build ID: b216cc1b8096eb60c27f67e8c27b7cd756c75e38
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-11-12_00:06:20
Locale: fi-FI (fi_FI)
Comment 6 QA Administrators 2017-01-03 19:35:22 UTC Comment hidden (obsolete)
Comment 7 Robert Großkopf 2017-01-04 06:50:58 UTC
Bug still exist in 
Build-ID: 3d5603e1122f0f102b62521720ab13a38a4e0eb0
CPU-Threads: 4; BS-Version: Linux 4.1; UI-Render: Standard; VCL: kde4; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Comment 8 QA Administrators 2018-06-09 02:40:32 UTC Comment hidden (obsolete)
Comment 9 Robert Großkopf 2018-06-15 06:37:06 UTC
Could reproduce this bug with LO on OpenSUSE 42.3, 64bit rpm Linux.
The second table gives
** Expression is faulty **
when renaming the first table of the Writer-document.
Comment 10 QA Administrators 2019-06-16 02:58:23 UTC Comment hidden (obsolete)
Comment 11 Robert Großkopf 2019-06-16 06:24:50 UTC
Same buggy behaviour in LO on OpenSUSE 15, 64bit rpm Linux