Issue 75092 - formulas with fixed location references get corrupted
Summary: formulas with fixed location references get corrupted
Status: CLOSED DUPLICATE of issue 73766
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2007-03-03 21:56 UTC by sandreas41
Modified: 2013-08-07 15:14 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
example for issue 75092 ods (15.67 KB, application/vnd.sun.xml.calc)
2007-03-03 22:00 UTC, sandreas41 		no flags Details
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 sandreas41 2007-03-03 21:56:16 UTC 
editing a formula with fixed cell references by dragging the colored square to a
new location 
causes the formula to no longer be fixed to that location.

(if moving from row 61 to row 70)
What was $C$61 becomes $C$70:C70
which when copied to numerous new cells is no longer fixed to $C$70
and the formula breaks, and must be edited by hand.

This bug introduced sometime between 2006.Aug and 2006.Nov.25

See attached spreadsheet.
Comment 1 sandreas41 2007-03-03 22:00:15 UTC 
Created attachment 43509 [details]
example for issue 75092 ods
Comment 2 sparcmoz 2007-03-04 06:41:25 UTC 
Seen in 2.2RC2 680m9(9124) on MacIntel
Reduced test case: 
Enter in an empty spreadsheet an absolute reference 
for example in Cell A2: =$A$1
Click in the Input Line to edit the cell
Drag the highlighted square from A2 to A3
Now the formula shows =$A$3:A3 which should be just $A$3
The absolute reference is now mixeed relative and absolute.
Comment 3 sparcmoz 2007-03-04 07:02:12 UTC 
reduced test case example should have started with:
"for example in Cell A1: =$A$2"
...
Comment 4 sparcmoz 2007-03-04 09:33:41 UTC 
This problem does NOT exist in 2.0.4 680m5 Build 9073. Setting keyword for
regression.
Comment 5 frank 2007-03-05 09:26:15 UTC 
Hi Eike,

please have a look at this one.

Frank
Comment 6 ooo 2007-03-05 11:38:28 UTC 
duplicate

*** This issue has been marked as a duplicate of 73766 ***
Comment 7 ooo 2007-03-05 11:38:55 UTC 
Closing dup.