Re: [O] Spreadsheet row formula

[Michael Brand]

Hi RCY

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.
>
>
>  |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$<<address@hidden> = 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<<$<<address@hidden>$> = 2 * @-1

@< first row
$<< second column
$> last column
@>> second last row
[...]

See also the manual here:
http://orgmode.org/manual/References.html

Michael