[libreoffice-users] Calc enhancement request:Label ranges

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.

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