From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicholas S-A Subject: Re: Orgtbl-mode questions Date: Mon, 3 Nov 2008 07:32:07 -0500 Message-ID: <20081103123207.GA16048@Edwards.local> References: <20081102161350.GA554@Edwards.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1KwybQ-0001w0-AX for emacs-orgmode@gnu.org; Mon, 03 Nov 2008 07:32:16 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1KwybP-0001ua-9c for emacs-orgmode@gnu.org; Mon, 03 Nov 2008 07:32:15 -0500 Received: from [199.232.76.173] (port=57814 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1KwybP-0001uN-6I for emacs-orgmode@gnu.org; Mon, 03 Nov 2008 07:32:15 -0500 Received: from yx-out-1718.google.com ([74.125.44.152]:65022) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1KwybO-0005BU-Ty for emacs-orgmode@gnu.org; Mon, 03 Nov 2008 07:32:15 -0500 Received: by yx-out-1718.google.com with SMTP id 34so944121yxf.66 for ; Mon, 03 Nov 2008 04:32:14 -0800 (PST) Content-Disposition: inline In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Carsten Dominik Cc: emacs-orgmode@gnu.org Hi, * Carsten Dominik [2008-11-03 12:16:56 +0100]: > However, since you are summing in the column, all $-row references > are optional, i.e. you can write the formula as > > :=vsum(@-II+1..-I-1) > > or even as > > :=vsum(@-II..-I) > > Since this is the same expression for all columns, you can copy it > into the kill ring and then move with > > C-y TAB C-y TAB ..... > > pretty quickly through the row where you want the formulas. That works very nicely. Thank you for the clear response and prompt reply! Nicholas