Issue 100135 - Moving formulas containing external references may result in wrong references.
Summary: Moving formulas containing external references may result in wrong references.
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks: 95768
  Show dependency tree
 
Reported: 2009-03-11 19:47 UTC by ooo
Modified: 2013-08-07 15:14 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 ooo 2009-03-11 19:47:23 UTC 
Moving formulas containing external references may result in wrong
references. Scenario:

1. Create and save a document external.ods with some data in cell
   Sheet1.A1.
2. Create a new document.
3. In cell A1 enter the formula ='external.ods'#Sheet1.A1
4. Copy cell A1 to clipboard.
5. Paste clipboard to cell A2.
6. The formula and result will be correctly adapted to point to
   external.ods Sheet1.A2
7. Move cell A2 to B3, either by Cut&Paste or dragging with the mouse.
8. Formula and result of B3 will point to external.ods Sheet1.A1 instead
   of external.ods Sheet1.A2

Note: you'll need a (not yet available) OOO310m5 (DEV300m43 does as
well) to reproduce, earlier versions already crash after having entered
the external reference..

In a non-product dbg-util build assertions pop up about a virtual dummy
ScToken::CalcAbsIfRel() being called, which essentially is related to
this.
Comment 1 ooo 2009-03-11 19:49:21 UTC 
Regression. Working on this. Nominating as 3.1 stopper.
Comment 2 ooo 2009-03-12 17:46:07 UTC 
In cws calc31stopper3:

revision 269429
sc/inc/token.hxx
sc/source/core/tool/compiler.cxx
sc/source/core/tool/token.cxx
Comment 3 ooo 2009-03-13 14:32:37 UTC 
Reassigning to QA for verification.
Comment 4 oc 2009-03-16 13:36:24 UTC 
verified in internal build cws_calc31stopper3
Comment 5 amy2008 2009-04-08 03:30:35 UTC 
Verified in OOo310m8 on WinXP
Closing
Li Meiying