Issue 94124 - Cannot mix relative and absolute addressing in one-cell range references.
Summary: Cannot mix relative and absolute addressing in one-cell range references.
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO300m7
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: oooqa, regression
: 95085 95630 96162 96445 96724 99431 (view as issue list)
Depends on:
Blocks: 93339
  Show dependency tree
 
Reported: 2008-09-21 16:15 UTC by ekolis
Modified: 2013-08-07 15:14 UTC (History)
4 users (show)

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

Attachments
Enter =SUM($b$7:b7) in cell C7 to see how it is converted to an absolute reference (13.28 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-09-21 16:18 UTC, ekolis 		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 ekolis 2008-09-21 16:15:08 UTC 
When I enter a this formula:
=SUM($b$7:b7)
in order to get a "running total", for some reason the formula is converted to this:
=SUM($B$7:$B$7)
which is completely useless as it sums a single cell!
If I leave the reference completely relative:
=SUM(b7:b7)
it stays relative, but I need one end to be absolute so I can get a running total.
Comment 1 ekolis 2008-09-21 16:18:57 UTC 
Created attachment 56671 [details]
Enter =SUM($b$7:b7) in cell C7 to see how it is converted to an absolute reference
Comment 2 Regina Henschel 2008-09-21 17:24:57 UTC 
I see the same error in OOo3.0RC1 on WinXP.

Workaround: Define a name for the start cell $B$7, for example 'start', and
write then =SUM(start,B7).
Comment 3 Regina Henschel 2008-09-21 17:45:30 UTC 
Typo: ..=SUM(start:B7)
Comment 4 Andrea Pescetti 2008-10-02 23:59:50 UTC 
Confirmed in RC3.

Title changed as the problem affects all functions operating on a range. So the
scope of this issue is much larger than that.

Old title was: "Partially absolute cell-range references turn absolute when used
in SUM function"
Comment 5 ooo 2008-10-06 16:49:41 UTC 
This is certainly a bug that should be tackled with.
Detailed summary a bit.

This is only for one-cell range references, as soon as the range encompasses
more than one cell, addressing works as expected.

The second part of the reference always inherits the addressing (relative or
absolute) from the first part.
A1:$A$1 => A1:A1, A$1:A1 => A$1:A$1, $A1:A1 => $A1:$A1, ...
Comment 6 ooo 2008-10-16 18:33:24 UTC 
In cws calc46:

sc/source/core/tool/refdata.cxx  1.7.166.1
Comment 7 ooo 2008-10-28 12:29:17 UTC 
Reassigning to QA for verification.
Comment 8 frank 2008-10-30 13:24:54 UTC 
*** Issue 95630 has been marked as a duplicate of this issue. ***
Comment 9 oc 2008-11-05 09:24:35 UTC 
verified in internal build cws_calc46
Comment 10 Regina Henschel 2008-11-12 16:13:23 UTC 
*** Issue 96162 has been marked as a duplicate of this issue. ***
Comment 11 Regina Henschel 2008-11-22 11:30:30 UTC 
*** Issue 96445 has been marked as a duplicate of this issue. ***
Comment 12 Regina Henschel 2008-11-30 13:22:17 UTC 
*** Issue 96724 has been marked as a duplicate of this issue. ***
Comment 13 Regina Henschel 2008-11-30 13:22:37 UTC 
*** Issue 96724 has been marked as a duplicate of this issue. ***
Comment 14 Joost Andrae 2009-01-13 11:13:28 UTC 
verified in OOO300_m15. closing issue
Comment 15 frank 2009-01-20 09:40:06 UTC 
*** Issue 95085 has been marked as a duplicate of this issue. ***
Comment 16 Regina Henschel 2009-02-19 21:37:31 UTC 
*** Issue 99431 has been marked as a duplicate of this issue. ***