Re: formula

From: Carsten Dominik <carsten.dominik@gmail.com>
To: Haroldo Stenger <harold.stenger@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: formula
Date: Tue, 4 Aug 2009 08:07:04 +0200	[thread overview]
Message-ID: <92686641-229C-43A6-9D9A-F49BD3EEB12B@gmail.com> (raw)
In-Reply-To: <3678e0bb0908031653v6b1ec438kda7788e0b5df36a2@mail.gmail.com>

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