From mboxrd@z Thu Jan 1 00:00:00 1970 From: Haroldo Stenger Subject: Re: formula Date: Mon, 3 Aug 2009 20:53:11 -0300 Message-ID: <3678e0bb0908031653v6b1ec438kda7788e0b5df36a2@mail.gmail.com> References: <3678e0bb0908021558y35e887d2r481a7eb5a8ab7280@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0977162244==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MY7LC-0006nT-34 for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 19:53:18 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MY7L7-0006e4-TO for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 19:53:17 -0400 Received: from [199.232.76.173] (port=48029 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MY7L7-0006dE-8S for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 19:53:13 -0400 Received: from mail-gx0-f219.google.com ([209.85.217.219]:46151) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MY7L6-00031c-Pl for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 19:53:13 -0400 Received: by gxk19 with SMTP id 19so6285943gxk.18 for ; Mon, 03 Aug 2009 16:53:11 -0700 (PDT) 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 , emacs-orgmode@gnu.org --===============0977162244== Content-Type: multipart/alternative; boundary=0016e6434466f886b0047045783a --0016e6434466f886b0047045783a Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Dear Carsten , Thanks ! That's exactly what I was in need of: a combination of a column-formula and relative references in the formula. So far, so good. Now, I have the formula line like this #+TBLFM: $5=@-1$5 + @-0$3 - @-0$4 and the very line I typed the formula gets calculated fine. If I want another line into the bus, I go to the empty field in the same column in another line, and go to the Calculate menu, and choose recalculate line, and the fine result appears there , as expected. But if I approach Calculate / Recalculate all , in fact , nothing happens. I tried many times, without result. Recalc line works perfectly, but that does not seem what I'm looking for, which would be a recalculation of all the fields in the column that holds my column-formula. I'll continue reading until I find out, but if you come up with an answer earlier I'd be grateful in advance ! :-) best , haroldo 2009/8/3 Carsten Dominik > 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 >> > > --0016e6434466f886b0047045783a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Dear Carsten ,

Thanks ! That's exactly what I was in need of: a = combination of a column-formula and relative references in the formula. So = far, so good. Now, I have the formula line like this

#+TBLFM: $5=3D= @-1$5 + @-0$3 - @-0$4

and the very line I typed the formula gets calculated fine. If I want a= nother line into the bus, I go to the empty field in the same column in ano= ther line, and go to the Calculate menu, and choose recalculate line, and t= he fine result appears there , as expected. But if I approach Calculate / R= ecalculate all , in fact , nothing happens. I tried many times, without res= ult. Recalc line works perfectly, but that does not seem what I'm looki= ng for, which would be a recalculation of all the fields in the column that= holds my column-formula.=A0 I'll continue reading until I find out, bu= t if you come up with an answer earlier I'd be grateful in advance !=A0= :-)

best ,

haroldo

2009/8/3 Carste= n Dominik <carsten.dominik@gmail.com>
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. =A0Even 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 locat= ion 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 ' =A0and the= n 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@gn= u.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode


--0016e6434466f886b0047045783a-- --===============0977162244== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ 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 --===============0977162244==--