El 12/03/12 9:35, mleikvol escribió:
mariosv wrote
Introduce:
A2: 1
A3: 2
A4: 3
Create a label range:
Menu/Insert/Names/Define/Adds:
Name: SumRange
Range: $Sheet1.$A$2:$A2
$A$2 is an absolute reference.
$A2 is a relative reference.
Introduce:
B2: =SUM(SumRange) result 1
Copy B2 to B3:
B3: =SUM(SumRange) result 3
Copy B3 to B4:
B4: =SUM(SumRange) result 6
Introduce:
B3: =SUM(SumRange) result 3
Introduce:
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
Menu/Insert/Names/Labels:
(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)*
A2:=1,B2:=0.1,C2:="=colA"
A3:=10,B3=0.01,C3:="=colB" *(note the = in front of the label name of C2 and
C3)*
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:
http://nabble.documentfoundation.org/Calc-enhancement-request-Label-ranges-tp3809978p3818694.html
Sent from the Users mailing list archive at Nabble.com.
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:
https://bugs.freedesktop.org/
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: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted