[O] Spreadsheet row formula

2012-01-08 Thread RCY
In the following table I am trying to implement a row formula for each cell to be a multiple of the corresponding cell in a preceding row, but several variations I tried do not work: | A| 2 | 3 | 4| | B| [4, 6, 8] | [4, 6, 8] | [4, 6, 8] | | C| [4, 6, 8]

Re: [O] Spreadsheet row formula

2012-01-08 Thread Michael Brand
Hi RCY Do you want to do this?: | A | 2 | 3 | 4 | | B | 4 | 6 | 8 | | C | 8 | 12 | 16 | #+TBLFM: @$..@$ = 2 * @-1 Michael

Re: [O] Spreadsheet row formula

2012-01-08 Thread RCY
Hi, 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

Re: [O] Spreadsheet row formula

2012-01-08 Thread Michael Brand
Hi RCY On Sun, Jan 8, 2012 at 17:12, RCY re...@yahoo.com 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

Re: [O] Spreadsheet row formula

2012-01-08 Thread RCY
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 michael.ch.br...@gmail.comwrote: Hi RCY On Sun, Jan 8, 2012 at 17:12, RCY re...@yahoo.com wrote: