From mboxrd@z Thu Jan 1 00:00:00 1970 From: Karl Voit Subject: Re: org-table-duplicate-column Date: Mon, 30 Sep 2013 13:43:36 +0200 Message-ID: <2013-09-30T13-29-05@devnull.Karl-Voit.at> References: <2013-09-29T10-33-04@devnull.Karl-Voit.at> <2013-09-29T21-49-38@devnull.Karl-Voit.at> Reply-To: news1142@Karl-Voit.at Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:59633) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VQbtL-0005LI-9W for emacs-orgmode@gnu.org; Mon, 30 Sep 2013 07:44:00 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VQbtG-0008RM-4I for emacs-orgmode@gnu.org; Mon, 30 Sep 2013 07:43:55 -0400 Received: from plane.gmane.org ([80.91.229.3]:33145) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VQbtF-0008RH-TO for emacs-orgmode@gnu.org; Mon, 30 Sep 2013 07:43:50 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1VQbtE-0002Iw-Bn for emacs-orgmode@gnu.org; Mon, 30 Sep 2013 13:43:48 +0200 Received: from mail.michael-prokop.at ([88.198.6.110]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 30 Sep 2013 13:43:48 +0200 Received: from news1142 by mail.michael-prokop.at with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 30 Sep 2013 13:43:48 +0200 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org * Michael Brand wrote: > Hi Karl Hi Michael! > On Sun, Sep 29, 2013 at 9:56 PM, Karl Voit 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