Issue 95630 - Range reference including same cell always converts to absolute
Summary: Range reference including same cell always converts to absolute
Status: CLOSED DUPLICATE of issue 94124
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO300m9
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-30 10:27 UTC by cheros
Modified: 2008-10-30 13:25 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 cheros 2008-10-30 10:27:42 UTC 
What I did:

Cell A9, formula "=max(a$8:a8)+1", aim was to copy it down the column (hence the
absolute reference).  When copied, did not work.  Inspection showed that Calc
had changed "=MAX(A$8:A8)" to "=MAX(A$8:A$8)".  This is impossible to change, as
soon as edit is saved Calc changes it back.  Behaviour is consistent and
repeatable and appears to be triggered by the range reference being the same cell).

Tested on OOo 3.0.0m9 build 9358 on Win XP Pro Intel dual core.
Comment 1 Stefan Weigel 2008-10-30 12:10:29 UTC 
Can confirm with OOo 3.0.0 stable (OOO300m9). Worked in 2.4.1 --> regression

Whenever a range is referenced, that starts and ends with the same cell (A1:A1),
Calc takes over relative/absolute references from the starting cell to the
ending cell.

Edit =SUM(A1:$A$1) would become =SUM(A1:A1)
Edit =SUM(A1:$A1)  would become =SUM(A1:A1)
Edit =SUM(A1:A$1)  would become =SUM(A1:A1)
Edit =SUM($A$1:A1) would become =SUM($A$1:$A$1)
Edit =SUM(A$1:A1) would become =SUM(A$1:A$1)

and so on.

Note: In some use cases it *does* make sense to enter references like
=SUM(A1:$A$1), in order to control some behaviour of references while filling or
copying.
Comment 2 stefan.baltzer 2008-10-30 12:27:31 UTC 
SBA: Confirmed. Reassigned to OC.
Set keyword "regression".
Comment 3 frank 2008-10-30 13:24:56 UTC 
double to Issue 94124

*** This issue has been marked as a duplicate of 94124 ***
Comment 4 frank 2008-10-30 13:25:16 UTC 
closed double