|Subject:||Re: [O] Spreadsheet row formula|
|Date:||Sun, 8 Jan 2012 11:37:36 -0500|
So you want this:
On Sun, Jan 8, 2012 at 17:12, RCY <address@hidden> 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.
> 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
#+TBLFM: @2$<<address@hidden> = 2 * @-1
| A | 2 | 3 | 4 |
| B | 4 | 6 | 8 |
@< first row
> 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<<$<<address@hidden>$> = 2 * @-1
$<< second column
$> last column
@>> second last row
See also the manual here:
|[Prev in Thread]||Current Thread||[Next in Thread]|