Issue 100639 - Calc: formulas referring to table name are not updated
Summary: Calc: formulas referring to table name are not updated
Status: RESOLVED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0.1
Hardware: PC Linux 32-bit
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-03-29 10:15 UTC by quantentunnel
Modified: 2013-02-23 17:49 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description quantentunnel 2009-03-29 10:15:20 UTC 
Formulas referring to table name are not updated (neither automatically nor
manually) when the table is renamed.
To reproduce error: create a new calc file, rename the first table to 'Tab',
save the file as test.ods. Enter in cell A1 a formula referring to the table
name (in my German version: '=ZELLE("filename")'). This cell now displays 
something like 'file:///C:/Dokumente und Einstellungen/.../test.ods'#$Tab.
Rename the table to 'renamedTab' (i.e., right click on table name then choose
rename). Now the bug is apparent: cell A1 still shows .../test.ods'#$Tab'
instead of .../test.ods'#$renamedTab.
Function key F9 does not help, nor the corresponding menu command (in German:
Extras|Zellinhalte|Neu berechnen).
Workaround 1: save file, close file, reopen file.
Workaround 2: pseudo-modify ("touch") the formula, e.g., replace the closing
bracket by a closing bracket; then press Enter.
Comment 1 quantentunnel 2009-04-30 11:09:12 UTC 
I checked the bug I orginally reported and have to confirm that it still exists
in the newest version (OpenOffice 3.0.1).
Comment 2 Edwin Sharp 2013-02-19 20:27:29 UTC 
How do you rename a table in Calc???
Comment 3 quantentunnel 2013-02-22 21:03:13 UTC 
(In reply to comment #2)
> How do you rename a table in Calc???

In all honesty, a bugtracker is not the appropriate forum for such questions. Nevertheless: double click on the tab at the bottom left of the calc window that displays the table name you like to change (if you have never changed it, it will likely read 'Table 1' or so). Or you right click on it and choose 'rename table' (or something the like, my Office is in German).
Comment 4 quantentunnel 2013-02-22 21:09:11 UTC 
Still persists in LibreOffice  3.5.7.2, Build-ID: 350m1(Build:2). Tested on Ubuntu (3.2.0-36-generic-pae #57-Ubuntu)
Comment 5 Edwin Sharp 2013-02-23 17:49:33 UTC 
@quantentunnel:
Bitte lernen Sie Englisch.
You mean "sheet", not "table"!
File - Reload updates cell A1.