Issue 109757 - Absolute Reference turns to mixed absolute/relative array when moved
Summary: Absolute Reference turns to mixed absolute/relative array when moved
Status: CLOSED DUPLICATE of issue 73766
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2
Hardware: Unknown Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-03-03 09:12 UTC by zapane
Modified: 2010-03-03 09:34 UTC (History)
2 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 zapane 2010-03-03 09:12:16 UTC 
Open a new spreadsheet.
Write some text in cells B1, B2, B3.
Insert an absolute reference to B1 in A1 eg. [=$B$1]
Doubleclick on A1.
Move the colored frame around B1 to B2.
The reference now changes to [=$B$2:B2] while it should be [=$B$2].
Drag and fill cell A1 to A2.
A2 now contains the reference [=$B$2:B3] which is a reference to an array of
cells rather than a single cell.
Comment 1 Regina Henschel 2010-03-03 09:31:08 UTC 
That is an old bug. You might vote for issue 73766?

*** This issue has been marked as a duplicate of 73766 ***
Comment 2 Regina Henschel 2010-03-03 09:34:59 UTC 
closing, duplicate