Issue 105647 - formula with absolut references and drag and drop action
Summary: formula with absolut references and drag and drop action
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m19
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-06 13:07 UTC by sunclag
Modified: 2014-01-02 12:07 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
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 sunclag 2009-10-06 13:07:50 UTC 
Hello OOo Team,

I think there is a problem with cells, wich include formulas with absolut
references, 
and the drag and drop action of cells they are referenced f.e.

the formula in A1="B1" 
now I drag and drop the cell B1 to H3 
the formula in A1 change to "=H3" that's ok 

but if I use absolute refereces in the cell
the formula in A1"=$B$1" 
and I drag and drop the cell B1 to H4, 
the formula in A1 also change, now to "=$H$1" I think that's not ok 
I think the formula in A1 has to remain "=$B$1"

greets
sunclag
Comment 1 sunclag 2009-10-06 14:44:11 UTC 
Hi
I saw I wrote wrong 
this "$H$1"
"the formula in A1 also change, now to "=$H$1" I think that's not ok"
must be "$H$4"
"the formula in A1 also change, now to "=$H$4" I think that's not ok" 
 
sorry 
sunclag
Comment 2 Edwin Sharp 2014-01-02 12:07:37 UTC 
Dragging of a single cell is impossible.

AOO410m1(Build:9750)  -  Rev. 1552994
Rev.1552994
Win 7