Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

El 12/03/12 9:35, mleikvol escribió:

mariosv wrote

A2:  1
A3:  2
A4:  3

Create a label range:
Name: SumRange
Range: $Sheet1.$A$2:$A2
$A$2 is an absolute reference.
$A2 is a relative reference.

B2: =SUM(SumRange)          result 1
Copy B2 to B3:
B3: =SUM(SumRange)          result 3
Copy B3 to B4:
B4: =SUM(SumRange)          result 6

B3: =SUM(SumRange)          result 3
B4: =SUM(SumRange)          result 6

Can this help?

/First a typo correction in my original post:
C2="=Arow" will resolve to "a1"
should say
C2="=Arow" will resolve to "Arow"
Also, my example was a bit confusing since I used the word "row" when I
should have used "col"

Thanks, but I'm afraid this doesnt do what I need. Your example doesnt use
labels, just a named range. Maybe a lot of users isnt aware of this
function? Here is a short description how label's work.

Define the label range:
Mark range A1:B1
(make sure radiobutton "contains column labels" is selected)
Accept the current range by pushing Add, then OK

Set these cells:
A1:="colA",B1="colB" *(note these cells contain pure text)*
A3:=10,B3=0.01,C3:="=colB" *(note the = in front of the label name of C2 and
C2 will now show the value 1 and C3 will show 0.01

*I need to be able to point the labels to the column above:*
C2 should show "colA" (or "#REF!" if it's out of range)  and C3 should show
0.1 (the row above)
..and I would like this to be possible with the suggested enhancement.

View this message in context:
Sent from the Users mailing list archive at

Thanks for the information,

I have used labels, but I don like so much because there isn't possible to set like an absolute address.

To register your request for enhancement:

But seems difficult that a so special request will be attended, maybe if you get support from other users.

I think better try will named ranges or named formulas.

Miguel Ángel.

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.