Issue 79035 - Absolute cell reference becomes a range when draged
Summary: Absolute cell reference becomes a range when draged
Status: CLOSED DUPLICATE of issue 73766
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.2
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-06-30 06:43 UTC by eduardojrobledo
Modified: 2013-08-07 15:14 UTC (History)
4 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 eduardojrobledo 2007-06-30 06:43:57 UTC 
When a cell is edited, if an absolute referenced cell is draged, it becomes a
range reference.

Say you have: a1 = $b$1 + b2
Double click on it to edit formula
Drag the b1 reference to c1 and confirm edit
You should have a1 = $c$1 + b2, but have a1 = $c$1:c1 + b2

Although the answer is still correct, if the cell gets copied, say to a2, it
will become a2 = $c$1:c2 + b3 which is equal to c2 + b3, instead of the correct
a2 = $c$1 + b3

Since dragging to edit part of formulas is a very important feature, this should
be a show stopper
Comment 1 frank 2007-06-30 22:42:39 UTC 
not a p1 Issue lowered to P3
Comment 2 helenrussian 2007-07-03 16:46:39 UTC 
Confirming with OOo 2.2.1 on Linux
Comment 3 kpalagin 2007-07-03 18:44:35 UTC 
Confirming with 2.2 on WinXP - as described.

Helen, Eduardojrobledo,
thanks a lot for your help!
Comment 4 frank 2007-07-03 20:46:24 UTC 
*** Issue 79175 has been marked as a duplicate of this issue. ***
Comment 5 eduardojrobledo 2007-07-07 18:43:21 UTC 
This is really annoying. Working with large spreadsheets without using the
dragging feature is taking too long (and using it is too risky!)

Is there any thing I can help with in order to solve the issue?
Comment 6 frank 2007-07-09 08:13:49 UTC 
Hi Eike,

seems to be yours.

Frank
Comment 7 ooo 2007-07-09 11:20:00 UTC 
.

*** This issue has been marked as a duplicate of 73766 ***
Comment 8 ooo 2007-07-09 11:20:26 UTC 
Closing dup.