Re: [O] About range references in the spreadsheet

[Eric S Fraga]

Bastien <address@hidden> writes:

> Hi Xue, Eric and Dieter,
>
> address@hidden (H. Dieter Wilhelm) writes:
>
>> (I would avoid the ambiguous expression "column two" since it is a
>> relative specification) alternatively
>>
>>   The TWO REFERENCES expand to a field range from the row above the
>>   current row, starting with two columns to the left up to the current
>>   column.
>
> Yes... but this is a bit long.
>
> I finally used this:
>
> @@-1$-2..@@-1   @r{in the first row up, 3 fields from 2 columns on the left}

Concise and correct!  I'm happy with this.

-- 
: Eric S Fraga, GnuPG: 0xC89193D8FFFCF67D
: in Emacs 24.3.50.1 and Org release_7.9.3d-898-g005917