2012 Archives by date, by thread · List index

# 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:
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
(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
```