Issue 26431 - Named cell references not updated after row insertion
Summary: Named cell references not updated after row insertion
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.1RC
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: peter.junge
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-03-13 13:55 UTC by odmdt
Modified: 2013-08-07 15:15 UTC (History)
1 user (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 odmdt 2004-03-13 13:55:58 UTC 
Any cell containing a reference to another cell by name (e.g. =TEST1) is 
not updated when a row is inserted before the referenced named cell and when 
the named value is changed.

To reproduce :
- Put some value into cell A1 (say 44) and name that cell "TEST1".
- Put into cell B1 the formula "=TEST1". The expected value appears : 44.
- Select the very first row and insert a new row. 
- Put into cell TEST1 (which is now in A2) the value 55. B2 doesn't reflect
the change and still says 44.

Same problem with OOo 1.1.0. 
Works fine with OOo 1.0.x.
Comment 1 frank 2004-03-13 21:44:40 UTC 
Hi Niklas,

confirmed.

Frank

PS Press CTRL+SHIFT+F9 and you get the correct result
Comment 2 niklas.nebel 2004-07-30 16:39:11 UTC 
nn->er: See also issue 1843. My guess is that to make direct references and
named ranges work with insertion and deletion, we have to change
ScFormulaCell::UpdateReference so it only calls EndListening and sets a flag,
and call StartListening at the end, after inserting/deleting.
Comment 3 ooo 2004-08-02 15:58:37 UTC 
Accepted.
Comment 4 ooo 2004-08-11 16:25:07 UTC 
On branch cws_src680_referr:
sc/inc/cell.hxx 1.13.84.1
sc/inc/column.hxx 1.9.104.1
sc/inc/table.hxx 1.23.106.1
sc/inc/tokenarray.hxx 1.4.86.1
sc/source/core/data/cell.cxx 1.21.84.1
sc/source/core/data/cell2.cxx 1.20.106.2
sc/source/core/data/column3.cxx 1.12.104.1
sc/source/core/data/document.cxx 1.57.8.1
sc/source/core/data/table2.cxx 1.27.104.1
sc/source/core/tool/token.cxx 1.20.86.1
Comment 5 ooo 2004-08-17 13:13:27 UTC 
Reopen to reassign.
Comment 6 ooo 2004-08-17 13:14:59 UTC 
Reassign to QA.
Comment 7 ooo 2004-08-17 13:17:01 UTC 
Restore status.
Comment 8 oc 2004-08-18 08:01:04 UTC 
reopened for reassigning
Comment 9 oc 2004-08-18 08:01:43 UTC 
Hi Peter, one4you
Comment 10 oc 2004-08-18 08:02:07 UTC 
reset resolution to fixed
Comment 11 peter.junge 2004-08-25 17:15:33 UTC 
works as intended in CWS 'referr'
-> verified
Comment 12 peter.junge 2004-10-11 11:59:09 UTC 
OK in master src680m56