emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Uwe Brauer <oub@mat.ucm.es>
To: emacs-orgmode@gnu.org
Subject: Re: how to add a range of columns
Date: Fri, 02 Jul 2021 12:04:27 +0200	[thread overview]
Message-ID: <8735sxghg4.fsf@mat.ucm.es> (raw)
In-Reply-To: 878s2pm4jj.fsf@ucl.ac.uk

[-- Attachment #1: Type: text/plain, Size: 1270 bytes --]

>>> "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).

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]

  reply	other threads:[~2021-07-02 10:05 UTC|newest]

Thread overview: 11+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2021-07-02  8:42 how to add a range of columns Uwe Brauer
2021-07-02  9:10 ` Eric S Fraga
2021-07-02  9:23   ` Uwe Brauer
2021-07-02  9:46     ` Eric S Fraga
2021-07-02 10:04       ` Uwe Brauer [this message]
2021-07-02 10:37         ` Eric S Fraga
2021-07-02 14:07           ` Uwe Brauer
2021-07-02 15:10             ` Eric S Fraga
2021-07-02 18:56               ` Uwe Brauer
2021-07-03  7:29                 ` Eric S Fraga
2021-07-04 12:37                   ` Uwe Brauer

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=8735sxghg4.fsf@mat.ucm.es \
    --to=oub@mat.ucm.es \
    --cc=emacs-orgmode@gnu.org \


* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox


This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).