El 08/03/12 16:34, mleikvol escribió:
Background:
Im doing a state machine simulation with libreoffice where I would like to
reference the row above the with a label, to get to the previous state (row
above). Now I have to do that with cell reference.
Please dont suggest to use functions like offset. The number of label
references in each cell can be large, and doing a offset lookup on every
access would end up extremely dirty.
This enhancement would save me many hours of manual lookup work.
Current limitation:
The current (->3.5.0) label range limits you to have a lookup to the same
row (or col I guess) as the referencing cell.
Action:
I suggest to remove current "for data range" and replace it with these two
parameters
-Label valid range
-start offset cell
Example:
Defined label range: column labels="$A$1:$A$2", for data range="$A$2:$B$3"
A1="Arow",B1="Brow"
A2="a2",B2="b2"
A3="a3",B3="b3"
C2="=Arow" will always resolve to "a2"
C3="=Brow" will always resolve to "b3"
Goal:
Defined label range: column labels="$A$1:$A$2", label valid
range="$A$2:$B$3", start offset="$A$1"
C2="=Arow" will resolve to "a1"
C3="=Brow" will resolve to "b2"
Challenge:
Can this be done without loosing backward compatibilty for the sheets not
using the new feature?
PS:I'm willing to conditionally donate if this gets implemented :)
--
View this message in context:
http://nabble.documentfoundation.org/Calc-enhancement-request-Label-ranges-tp3809978p3809978.html
Sent from the Users mailing list archive at Nabble.com.
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?
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
