[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: how to add a range of columns
From: |
Uwe Brauer |
Subject: |
Re: how to add a range of columns |
Date: |
Fri, 02 Jul 2021 12:04:27 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) |
>>> "ESF" == Eric S Fraga <e.fraga@ucl.ac.uk> writes:
> On Friday, 2 Jul 2021 at 11:23, Uwe Brauer wrote:
>> No I only want to add the parts of column $1 and $2 that are between the
>> two hlines
> Okay; problem 1 is that org formulas are not really vector based: a
> range on the left hand side says that each element in the range will be
> assigned the outcome of the right hand side so the right hand side
> should not be a vector.
>> (I wanted to use hline @I and @II and not the explict row
>> numbers, since this is more convenient. But it does to work with
>> explicit row numbers
> Yes, you cannot use @I etc. in the range definition for the target.
> I can think of 2 options. First, you can use relative addressing, i.e.:
> #+TBLFM: @<<$3..@>>$3=$1+$2
> where @<< means the second row and @>> the second last row.
Thanks, that was helpful
> Alternatively, you can introduce a new column at the start and use the
> "Advanced Features" of the spreadsheet described in the info manual
> section
> (org) Advanced features
> which will allow you to specify which rows should be evaluated (see the
> * option).
I will have a look thanks (I already thought about commenting out
unwanted rows, but that looked ugly).
smime.p7s
Description: S/MIME cryptographic signature
- how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns, Eric S Fraga, 2021/07/02
- Re: how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns, Eric S Fraga, 2021/07/02
- Re: how to add a range of columns,
Uwe Brauer <=
- Re: how to add a range of columns, Eric S Fraga, 2021/07/02
- Re: how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns, Eric S Fraga, 2021/07/02
- Re: how to add a range of columns, Uwe Brauer, 2021/07/02
- Re: how to add a range of columns, Eric S Fraga, 2021/07/03
- Re: how to add a range of columns, Uwe Brauer, 2021/07/04