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: address@hidden + @-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 <address@hidden>
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.
address@hidden
http://lists.gnu.org/mailman/listinfo/emacs-orgmode