Hi,
That does what I want. Thanks for taking the time to explain it. I should
have read the manual on relative cell references more carefully.
On Sun, Jan 8, 2012 at 11:23 AM, Michael Brand
wrote:
> Hi RCY
>
> On Sun, Jan 8, 2012 at 17:12, RCY wrote:
> > Sorry not to be clearer.
> > I would like to implement the formula for only one row. So entering the
> > first row shown below and implementing the formula with only B entered in
> > the first column in the second row gives the rest of the second row.
> >
> >
> > |A|2|3|4|
> > |B|4|6|8|
> >
> > Your suggestion almost does what I want, except that it applies the
> formula
> > to every row. I would like to apply different row formulas to succeeding
> > rows.
>
> So you want this:
>
> | A | 2 | 3 | 4 |
> | B | 4 | 6 | 8 |
> #+TBLFM: @2$<<..@2$> = 2 * @-1
>
> > Also I was not clear about the syntax you used, does <<$<< exclude the
> first
> > column and >$> indicate up to the last column?
> > I tried to modify your formula to restrict it to the second row:
> > @2<<$<<..@2>$> = 2 * @-1
>
> @< first row
> $<< second column
> $> last column
> @>> second last row
> [...]
>
> See also the manual here:
> http://orgmode.org/manual/References.html
>
> Michael
>