From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: formula Date: Mon, 3 Aug 2009 12:51:29 +0200 Message-ID: References: <3678e0bb0908021558y35e887d2r481a7eb5a8ab7280@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v935.3) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MXv8l-0005G5-AB for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 06:51:39 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MXv8g-00058a-NL for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 06:51:38 -0400 Received: from [199.232.76.173] (port=36594 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MXv8g-00058Q-JG for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 06:51:34 -0400 Received: from mail-ew0-f211.google.com ([209.85.219.211]:59804) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MXv8g-00006r-4n for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 06:51:34 -0400 Received: by ewy7 with SMTP id 7so1235646ewy.42 for ; Mon, 03 Aug 2009 03:51:32 -0700 (PDT) In-Reply-To: <3678e0bb0908021558y35e887d2r481a7eb5a8ab7280@mail.gmail.com> 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: Haroldo Stenger Cc: emacs-orgmode@gnu.org Hi Haroldo, You cannot copy a formula easily from one field t the next with shifting the reference like you would do in a normal spreadsheet. However, you can use relative references (see the manual) in order to write formulas in an invariant way, and then use basic editing commands in the C-c ' buffer to define the formula for many fields. Even better, use a column formula which allows you to write a single formula for an entire column. - Carsten On Aug 3, 2009, at 12:58 AM, Haroldo Stenger wrote: > hi , I wonder how can a formula in a table be "copied" to a location > below, and its references be shifted alongwise automatically. I > checked every documentation I've found , but that "feature" does not > show up. I'm forced to copy the formula in in the C-c ' and then go > to each of the references and type S-downarrow as many times. I'd > thank any idea here. > > best regards, haroldo. > (thanks for org-mode, it's great) > _______________________________________________ > Emacs-orgmode mailing list > Remember: use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode