Carsten Dominik <carsten.domi...@gmail.com> wrote: > > On 28.2.2011, at 12:43, Tom wrote: > > > I have a table in which I sum the values of all rows in the last > > row: vsum(@1..@-I-1). The problem is when move a row with M-up > > before the first row (e.g. I press M-up on the second row) then > > org modifies this formula to vsum(@2..@-I-1). > > > Hi Tom, > > I have thought a bit more about this issue. I do agree that, > in particular when specifying ranges, it may not always > desirable to have the formulas automatically adapt when > rows and columns are swapped. > > I have just pushed a change that makes $< and @< refer in > a stable way to the first column and row, respectively. > You can also use @<<< to mean the second row and @>> > the second to last row. >
I hope you mean @<< above: otherwise the symmetry is spoiled :-) > I hope this will prove to be useful for such cases. > > Regards > > P.S. Nick (Dokos), I also added them to get the symmetry with > the @> and $> references :) > And a thing of beauty it is, too! ;-) Much appreciated, Nick
