Carsten, Nick,
I finally could solve the issue. I got confused by what I consider are two
typos in the mails, I was mislead by 'filed formula' which I thought was
something new to me, when it was really a simple 'field formula'. Moreover,
column formulas (as the docs say, since I checked) start li
Haroldo Stenger wrote:
>
> Carsten ,
>
> I take for granted that a filed formula is a column formula , like the one I
> was using.
>
That's incorrect: look at Carsten's modification of your TBLFM line:
> #+TBLFM: $...@-1$3 + @+0$1 - @+0$2::@2$3=0
^^---
On Aug 4, 2009, at 4:23 PM, Haroldo Stenger wrote:
Carsten ,
I take for granted that a filed formula is a column formula , like
the one I was using.
No. A column formula starts like %3=... and applies to all fields
in column 3. A field formula starts like @2$3=... and applies to a
sing
Carsten ,
I take for granted that a filed formula is a column formula , like the one I
was using.
I upgraded to the las org-mode version.
I must be doing something really wrong, since C-u C-c * doesn't recalculate
the column, it just moves the point to the first row after the hline.
What can b
Hi Haroldo,
Well, I am using the newest version of Org-mode for which you'd have
to use a filed formula for the first field in the balance column.
Then using your
formulas, `C-u C-c *' does fill the entire table:
| in | out | balance |
|-+-+-|
| | | 0 |
| 3
Sure, sorry, that's what text is for :)
| in | out | balance |
|-+-+-|
| | | |
| 30 | | 30 |
| | 25 | 5 |
| 100 | | 105 |
| 500 | | |
| | 400 | |
| | | |
#+TBLFM: $...@-1$3 + @+0$1 - @+0$2
That's
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
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: $...@-1$5 + @-0$3 - @-0$4
and the very line I typed the formula gets calculated fine. If I want
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 '
Indeed, thank you very much.
Fixed in the GIT repo.
- Carsten
On Dec 22, 2008, at 5:06 PM, henry atting wrote:
Since the last upgrade of org-mode (now 6.16) when I do a `C-c C-c' on
`=' in a table field I am always prompted like this:
replace field formula with column formula (y or n)
Th
10 matches
Mail list logo
