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

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+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