From: Karl Voit <devnull@Karl-Voit.at>
To: emacs-orgmode@gnu.org
Subject: Re: org-table-duplicate-column
Date: Mon, 30 Sep 2013 13:43:36 +0200 [thread overview]
Message-ID: <2013-09-30T13-29-05@devnull.Karl-Voit.at> (raw)
In-Reply-To: CALn3zogu8xrfcbURQuhA0Wj4K=NkCEQxjpC72Z3nnU2Z5pj1Dw@mail.gmail.com
* Michael Brand <michael.ch.brand@gmail.com> wrote:
> Hi Karl
Hi Michael!
> On Sun, Sep 29, 2013 at 9:56 PM, Karl Voit <devnull@karl-voit.at> wrote:
>> | *Option* | *Evaluation 123* | *Evaluation 234* |
>> |----------+------------------+------------------|
>> | Option 1 | 27 | 26 |
>> | Option 2 | 22 | 24 |
>> | Option 3 | 16 | 16 |
>> | Option 4 | 16 | 13.5 |
>> | Option 5 | 8 | 9 |
>> | Option 6 | 2 | 4 |
>> |----------+------------------+------------------|
>> | | 91 | 92.5 |
>> #+TBLFM: @8$2=vsum(@I$2..@II$2)::@8$3=vsum(@I$3..@II$3)
>
> I would use
>
> #+TBLFM: @>$<<..@>$> = vsum(@I$0..@II$0)
> or the shorter
> #+TBLFM: @>$<<..@>$> = vsum(@I..@II)
Never used this kind of reference yet.
What about alternating data (no summary value at bottom row) and
evaluation columns?
| Data 1 | Eval 1 | Data 2 | Eval 2 |
What about moving columns:
Switching two columns from:
| Eval 1 | Eval 2 | foo | bar |
to:
| Eval 1 | foo | Eval 2 | bar |
("foo" and "bar" do not have those formula fields like Eval columns)
Besides the fact that I personally prefer single column
formulas for legibility and maintainability. I had to spend a minute
to understand "@>$<<..@>$> = vsum(@I..@II)" and I am afraid that I
have to re-spend this minute in three weeks when I have to add data
to the table.
So, yes you clearly helped with the example I posted. However, I
have got the feeling that this method is not able to solve my issue
in all cases. I still tend to think that org-table-duplicate-column
would be handy in many cases.
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
next prev parent reply other threads:[~2013-09-30 11:44 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2013-09-29 8:35 org-table-duplicate-column Karl Voit
2013-09-29 9:42 ` org-table-duplicate-column Michael Brand
2013-09-29 19:56 ` org-table-duplicate-column Karl Voit
2013-09-29 20:51 ` org-table-duplicate-column Michael Brand
2013-09-30 11:43 ` Karl Voit [this message]
2013-09-30 19:30 ` org-table-duplicate-column Michael Brand
2013-10-01 15:50 ` org-table-duplicate-column Karl Voit
2013-10-01 16:25 ` org-table-duplicate-column Michael Brand
2013-10-01 19:33 ` org-table-duplicate-column Karl Voit
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=2013-09-30T13-29-05@devnull.Karl-Voit.at \
--to=devnull@karl-voit.at \
--cc=emacs-orgmode@gnu.org \
--cc=news1142@Karl-Voit.at \
/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).