From: Carsten Dominik <dominik@science.uva.nl>
To: ignotus@freemail.hu
Cc: emacs-orgmode@gnu.org
Subject: Re: filling cells automatically
Date: Mon, 2 Jul 2007 12:45:18 +0200 [thread overview]
Message-ID: <1541b72dae819418616412d830bded6c@science.uva.nl> (raw)
In-Reply-To: <87hcp2636n.fsf@freemail.hu>
On Jun 20, 2007, at 17:44, ignotus@freemail.hu wrote:
> Dear Org users!
>
> I would like to have the following functionality: I have a table like
> this:
>
> | number1 | number2 | description |
> |---------+---------+-------------|
> | 1 | 1 | a |
> | 1 | 2 | b |
> | 1 | 3 | c |
> | 1 | 4 | d |
> |---------+---------+-------------|
> | 2 | 1 | aa |
> | 2 | 2 | bb |
> | 2 | 3 | cc |
> | 2 | 4 | dd |
> |---------+---------+-------------|
> | 3 | 1 | aaa |
> | 3 | 2 | bbb |
> | 3 | 3 | ccc |
> | 3 | 4 | ddd |
> |---------+---------+-------------|
>
> I would like to generate number1 and number2 rows automatically (so
> when
> I insert something the numbering will be okay), is this possible? Well
> I know it is, but is it possible within the current org table
> framework?
This is currently difficult because of a bug in org-mode
in the treatment of fields that have a field formula assigned,
but also are in a column with a column formula. This bug
will be fixed in the next version, and then you can do:
| number1 | number2 | description |
|---------+---------+-------------|
| 1 | 1 | a |
| 1 | 2 | b |
| 1 | 3 | c |
| 1 | 4 | d |
|---------+---------+-------------|
| 2 | 1 | aa |
| 2 | 2 | bb |
| 2 | 3 | cc |
| 2 | 4 | dd |
|---------+---------+-------------|
| 3 | 1 | aaa |
| 3 | 2 | bbb |
| 3 | 3 | ccc |
| 3 | 4 | ddd |
|---------+---------+-------------|
#+TBLFM:
$1=@-1::$2=1+@-1::@2$1=1::@2$2=1::@6$1=2::@6$2=1::@10$1=3::@10$2=1
Make sure that you insert new rows with Org-mode commands, not by hand.
With this setup, C-u C-c C-c will update the table and fill rows 1 and
2.
Hope this helps
- Carsten
next prev parent reply other threads:[~2007-07-02 10:45 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2007-06-20 15:44 filling cells automatically ignotus
2007-07-02 10:45 ` Carsten Dominik [this message]
2007-07-04 14:22 ` ignotus
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=1541b72dae819418616412d830bded6c@science.uva.nl \
--to=dominik@science.uva.nl \
--cc=emacs-orgmode@gnu.org \
--cc=ignotus@freemail.hu \
/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).