From mboxrd@z Thu Jan 1 00:00:00 1970 From: Haroldo Stenger Subject: Re: formula Date: Tue, 4 Aug 2009 03:28:19 -0300 Message-ID: <3678e0bb0908032328j379f2f66xffc2f05baebc271b@mail.gmail.com> References: <3678e0bb0908021558y35e887d2r481a7eb5a8ab7280@mail.gmail.com> <3678e0bb0908031653v6b1ec438kda7788e0b5df36a2@mail.gmail.com> <92686641-229C-43A6-9D9A-F49BD3EEB12B@gmail.com> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0878817036==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MYDVZ-0002eJ-JS for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 02:28:25 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MYDVU-0002ZD-Lh for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 02:28:24 -0400 Received: from [199.232.76.173] (port=46127 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MYDVU-0002Z4-IB for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 02:28:20 -0400 Received: from mail-yw0-f189.google.com ([209.85.211.189]:58277) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MYDVU-00027p-2n for emacs-orgmode@gnu.org; Tue, 04 Aug 2009 02:28:20 -0400 Received: by ywh27 with SMTP id 27so4723567ywh.26 for ; Mon, 03 Aug 2009 23:28:19 -0700 (PDT) In-Reply-To: <92686641-229C-43A6-9D9A-F49BD3EEB12B@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: Carsten Dominik , emacs-orgmode@gnu.org --===============0878817036== Content-Type: multipart/alternative; boundary=0016e646527c164e5804704afe02 --0016e646527c164e5804704afe02 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Sure, sorry, that's what text is for :) | in | out | balance | |-----+-----+---------| | | | | | 30 | | 30 | | | 25 | 5 | | 100 | | 105 | | 500 | | | | | 400 | | | | | | #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2 That's how the table looks like after - creating the table - filling columns 1 and 2 with numbers - creating the column formula in column 3, and - typing C-c * in @3$3 , @4$3 and @5$3 The complete filling of the $3 column doesn't take place by issuing the commands in http://orgmode.org/org.html#Updating-the-table. If I go to @6$3 , @7$3 and @8$3 and type C-c * I obtain what I want, being: | in | out | balance | |-----+-----+---------| | | | | | 30 | | 30 | | | 25 | 5 | | 100 | | 105 | | 500 | | 605 | | | 400 | 205 | | | | 205 | #+TBLFM: $3=@-1$3 + @+0$1 - @+0$2 I know that what I'm asking should be of easy achievement on my own, but I got somewhat frustrated when I use the commands and the filling doesn't happen. Thanks for helping me. best, haroldo 2009/8/4 Carsten Dominik > > Hi Haroldo, > > instead of keeping us guessing what your table might look like, > maybe you can just post it.... > > - Carsten > > On Aug 4, 2009, at 1:53 AM, Haroldo Stenger wrote: > >> 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 >> >> > --0016e646527c164e5804704afe02 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Sure, sorry, that's= what text is for :)
| =A0in | out | balance |
|-----+-----+---------|=
| =A0 =A0 | =A0 =A0 | =A0 =A0 =A0 =A0 |
| =A030 | =A0 =A0 | =A0= =A0 =A030 |
| =A0 =A0 | =A025 | =A0 =A0 = =A0 5 |
| 100 | =A0 =A0 | =A0 = =A0 105 |
| 500 | =A0 =A0 | =A0 =A0 =A0 = =A0 |
| =A0 =A0 | 400 | =A0 = =A0 =A0 =A0 |
| =A0 =A0 | =A0 =A0 | =A0 = =A0 =A0 =A0 |
#+TBLFM: $3=3D@-1$3 + @= +0$1 - @+0$2

That's how the table looks like after
- creating the table
- filling columns 1 and 2 with numbers
- creating the column formula in column 3, and<= br style=3D"font-family: courier new,monospace;"> - typing C-c * in @3$3 = =A0, @4$3 =A0and =A0@5$3

The complete filling of the $3 column does= n't take place by issuing the commands in http://orgmode.org/org.html#Updating-the-tabl= e. If I go to @6$3 , @7$3 and @8$3 and type C-c * =A0I obtain what I wa= nt, being:

| =A0in | out | balance |
|-----+-----+---------|
| =A0 =A0 | =A0 =A0 | = =A0 =A0 =A0 =A0 |
<= span style=3D"font-family: courier new,monospace;">| =A030 | =A0 =A0 | =A0 = =A0 =A030 |
| =A0 =A0 | =A025 | =A0= =A0 =A0 5 |
| 100 | =A0 =A0 | =A0 =A0 105= |
| 500 | =A0 =A0 | =A0 = =A0 605 |
| =A0 =A0 | 400 | =A0 =A0 205 |<= /span>
| =A0 =A0 | =A0 =A0 | = =A0 =A0 205 |
#+TBLFM: $3=3D@-1$3 + @+0$1 = - @+0$2

I know that what I'm asking should be of easy achievemen= t on my own, but I got somewhat frustrated when I use the commands and the = filling doesn't happen. Thanks for helping me.

best,
haroldo




2009/8/4 Carsten Dominik <= ;carsten.dominik@gmail.com= >
>
> Hi Haroldo,
>
> instead of keeping us gues= sing what your table might look like,
> maybe you can just post it....
>
> - Carsten
>
&g= t; On Aug 4, 2009, at 1:53 AM, Haroldo Stenger wrote:
>
>> D= ear Carsten ,
>>
>> Thanks ! That's exactly what I wa= s 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= another line into the bus, I go to the empty field in the same column in a= nother 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 r= esult. Recalc line works perfectly, but that does not seem what I'm loo= king for, which would be a recalculation of all the fields in the column th= at holds my column-formula. =A0I'll continue reading until I find out, = but if you come up with an answer earlier I'd be grateful in advance ! = =A0:-)
>>
>> best ,
>>
>> haroldo
>>
= >> 2009/8/3 Carsten Dominik <carsten.dominik@gmail.com>
>> Hi Haroldo,
>&g= t;
>>
>> 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 fo= r
>> many fields. =A0Even better, use a column formula which allow= s
>> 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 documentati= on I've found , but that "feature" does not show up. I'm = forced to copy the formula in in the C-c ' =A0and then go to each of th= e references and type S-downarrow as many times. I'd thank any idea her= e.
>>
>> best regards, haroldo.
>> (thanks for org-mod= e, 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
>>
&g= t;>
>

--0016e646527c164e5804704afe02-- --===============0878817036== 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 --===============0878817036==--