Re: formula

From: Haroldo Stenger <harold.stenger@gmail.com>
To: Carsten Dominik <carsten.dominik@gmail.com>, emacs-orgmode@gnu.org
Subject: Re: formula
Date: Mon, 3 Aug 2009 20:53:11 -0300	[thread overview]
Message-ID: <3678e0bb0908031653v6b1ec438kda7788e0b5df36a2@mail.gmail.com> (raw)
In-Reply-To: <F3FCFB4E-66C8-4D71-8D22-1FE0288F3483@gmail.com>

[-- Attachment #1.1: Type: text/plain, Size: 2163 bytes --]

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 <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.  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
>>
>
>

[-- Attachment #1.2: Type: text/html, Size: 2958 bytes --]

[-- Attachment #2: Type: text/plain, Size: 204 bytes --]

_______________________________________________
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