[libreoffice-users] Re: Calc enhancement request:Label ranges

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.

-- 
For unsubscribe instructions e-mail to: users+help@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