From: Michael Brand <michael.ch.brand@gmail.com>
To: Michael Bach <phaebz@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: Row formula in orgtbl mode
Date: Wed, 4 May 2011 17:26:14 +0200 [thread overview]
Message-ID: <BANLkTiniunvFp+pXEctNTjjbO30KxHtmog@mail.gmail.com> (raw)
In-Reply-To: <4dc15635.1107df0a.51c0.15c4@mx.google.com>
Hi Michael
On Wed, May 4, 2011 at 15:35, Michael Bach <phaebz@gmail.com> wrote:
> # I sent this one previously by mistake in reply to a totally unrelated post, so now
> # again.
# and also the answer again for the mail archives with this thread separate
> | | a | b | c | d |
> | Specific cost | 1 | 9 | 2 | 3 |
> | System size | 1000 | 1000 | 1000 | 1000 |
> | | | | | |
> | ... | ... | ... | ... | ... |
> #+TBLFM: @4=@2*@3
Row formulas are not supported, but the new range formulas you already
tried are even more powerful:
> I am wondering how I would need to format the #+TBLFM: line to multiply
> the respective numeric values of rows 2 and 3 in row 4. I am using org
> v.7.4. All my attempts, also trying to define ranges like
> @4$2..@4$5=@-1*@-2, fail.
Your range formula @4$2..@4$5=@-1*@-2 will work if you upgrade at
least to this commitdiff
http://orgmode.org/w/?p=org-mode.git;a=commitdiff;h=8237c9ae6d587a22646333e0315683675e2db538
and will deliver
| | a | b | c | d |
| Specific cost | 1 | 9 | 2 | 3 |
| System size | 1000 | 1000 | 1000 | 1000 |
| | 1000 | 9000 | 2000 | 3000 |
| ... | ... | ... | ... | ... |
#+TBLFM: @4$2..@4$5=@-1*@-2
For this application I would suggest
#+TBLFM: @4$<<..@4$>=@-1*@-2
Michael
next prev parent reply other threads:[~2011-05-04 15:26 UTC|newest]
Thread overview: 5+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-05-04 13:35 Row formula in orgtbl mode Michael Bach
2011-05-04 15:26 ` Michael Brand [this message]
2011-05-05 12:00 ` Michael Bach
-- strict thread matches above, loose matches on Subject: below --
2011-05-03 15:48 MobileOrg Android 0.5.4 Release - Now with Tablet support Matthew Jones
2011-05-04 13:25 ` Row formula in orgtbl mode Michael Bach
2011-05-04 13:55 ` Michael Brand
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:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
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=BANLkTiniunvFp+pXEctNTjjbO30KxHtmog@mail.gmail.com \
--to=michael.ch.brand@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=phaebz@gmail.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* 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
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
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).