[-- Attachment #1: Type: text/plain, Size: 681 bytes --] 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] | [4, 6, 8] | [4, 6, 8] | | 2 A | 4 | 6 | 8 | #+TBLFM: @2$2..@2$4=2*@1$2..@1$4::@3$2..@3$4=2*(@1$2..@1$4) What I would like to get, without having to repeat the formula for each cell in the row is: |B|4|6|8| It seems that this should be fairly simple to do. I am using the latest git version of orgmode with emacs 24.0.50 Thanks for any suggestions. [-- Attachment #2: Type: text/html, Size: 734 bytes --]

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

[-- Attachment #1: Type: text/plain, Size: 910 bytes --] 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 what I want, except that it applies the formula to every row. I would like to apply different row formulas to succeeding rows. 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 But that did not work. Thanks. On Sun, Jan 8, 2012 at 10:51 AM, Michael Brand <michael.ch.brand@gmail.com>wrote: > Hi RCY > > Do you want to do this?: > > | A | 2 | 3 | 4 | > | B | 4 | 6 | 8 | > | C | 8 | 12 | 16 | > #+TBLFM: @<<$<<..@>$> = 2 * @-1 > > > Michael > [-- Attachment #2: Type: text/html, Size: 1349 bytes --]

Hi RCY On Sun, Jan 8, 2012 at 17:12, RCY <recif@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 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

[-- Attachment #1: Type: text/plain, Size: 1271 bytes --] 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.brand@gmail.com>wrote: > Hi RCY > > On Sun, Jan 8, 2012 at 17:12, RCY <recif@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 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 > [-- Attachment #2: Type: text/html, Size: 1975 bytes --]