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)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Fields-Cross-Reference
  Show dependency tree / graph
 
Reported: 2014-08-28 14:10 UTC by Oliver
Modified: 2023-06-17 05:45 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
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 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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

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