Bug 83196

Summary: TABLE: reference from one table to another is broken, when renaming the table
Product: LibreOffice Reporter: Oliver <oliver.mailings>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: ilmari.lauhakangas, iplaw67, robert
Priority: medium    
Version: Inherited From OOo   
Hardware: Other   
OS: All   
Whiteboard: BSA
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107905    
Attachments: example with 2 table with reference from table2 to cell in table1

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

Oliver
Operating System: Ubuntu
Version: 4.3.0.4 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 3.3.0.1 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 4.2.5.2 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: 5.1.0.0.alpha1+
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 
Version: 5.2.4.2
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 6.0.5.1 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 6.2.4.2 on OpenSUSE 15, 64bit rpm Linux
Comment 12 QA Administrators 2021-06-16 03:56:04 UTC Comment hidden (obsolete)
Comment 13 QA Administrators 2023-06-17 03:15:25 UTC Comment hidden (obsolete)
Comment 14 Robert Großkopf 2023-06-17 05:45:29 UTC 
Bug still exist in LO 7.5.4.2 on OpenSUSE 15.4 64bit rpm Linux