Issue 79427 - Cell reference changes to area reference when dragging
Summary: Cell reference changes to area reference when dragging
Status: CLOSED DUPLICATE of issue 73766
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-07-10 09:19 UTC by gercokees
Modified: 2007-07-10 09:24 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 gercokees 2007-07-10 09:19:51 UTC 
Hi,

When dragging with your mouse, the cell reference in formulas changes to area
reference.
Steps to reproduce:
* new spreadsheet
* in cell a1 enter 1
* in cell a2 enter 2
* in cell b1 enter =$A$1
* now, in cell b1 press the {F2} button, and drag the colored box around a1 to a2

Notice the value in cell b1 now is: =$A$2:A2 
Expected result: value cell b1: =$A$2
Comment 1 frank 2007-07-10 09:24:17 UTC 
double to Issue 73766

*** This issue has been marked as a duplicate of 73766 ***
Comment 2 frank 2007-07-10 09:24:39 UTC 
closed double