Re: Re: Question on spreadsheet formula

From: Carsten Dominik <carsten.dominik@gmail.com>
To: RC <recif@yahoo.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: Re: Question on spreadsheet formula
Date: Mon, 28 Sep 2009 07:51:36 +0100	[thread overview]
Message-ID: <9DB01350-3DB9-43B0-9D88-D5AAB687B179@gmail.com> (raw)
In-Reply-To: <loom.20090927T210029-625@post.gmane.org>

Hi RC,

On Sep 27, 2009, at 8:35 PM, RC wrote:

> Thank you benny and Andreas for your solutions to my question.
>
> I did notice a couple of things I did not expect and would  
> appreciate if someone
> could tell me what I am missing.
>
> In the following table, if I change the value in @2$4, I have to run  
> C-c C-c
> twice for the change to be propagated. Turning on formula debugging,  
> the first
> time the first formula gets executed starting only from @3$4 until  
> the end of
> the table, then the second substitution formula is executed for cell  
> @2#4.  This
> happens even if cells @2$2 and @2$3 have values in them. Does the  
> presence of
> the substitution formula later in the #+TBLFM line, cause execution  
> of the first
> formula to start only from the succeeding row?
> |-----+------+------+-------|
> | No. |    P |    E |     B |
> |-----+------+------+-------|
> |     |      |      |   300 |
> |   1 | 5000 | 2000 |  3200 |
> |   2 | 7000 | 1000 |  9200 |
> |   3 | 5000 | 1000 | 13200 |
> #+TBLFM: $4=@-1$4+$2-$3::@2$4=300

Filed formulas are applied after column formulas, because
often these reference fields that have been changed by column formulas.
You have here a case where this assumption doe not apply.

Note that there is a command org-table-iterate that recomputes
the table until it is stable.   `C-u C-u C-c C-u' does call this
command when the cursor is in table.

So far this did not work when the cursor is on the TBLFM line, but
I just changed that.  C-u C-u C-c C-c from the TBLFM line now also
iterates.

>
>
> For the table above, or the following, having a ! in the first  
> column of the
> first row (which I thought was a way to label columns) causes the  
> calculation
> formulas not to be executed.
> |---+-----+------+------+-------|
> | ! | No. |    P |    E |     B |
> |---+-----+------+------+-------|
> |   |   1 | 5000 | 2000 |  3000 |
> |   |   2 | 7000 | 1000 |  9000 |
> |   |   3 | 5000 | 1000 | 13000 |
> |   |   4 | 5000 | 2000 | 16000 |
> #+TBLFM: $5=vsum(@-I$3..@0$3)-vsum(@-I$4..@0$4)

If you are using a special first column, only lines with # or * in the
first column will be touched by column formulas.  This is in the docs,
right where you can read about the "!" rows as well.  Here is the
relevant passage:

 > Important: please note that for these special tables, recalculating
 > the table with C-u C-c * will only aﬀect rows that are marked  
‘#’
 > or ‘*’, and ﬁelds that have a formula assigned to the ﬁeld  
itself.
 > The column formulas are not applied in rows with empty ﬁrst ﬁeld.

HTH

- Carsten

>
> Thanks,
> RC
>
>
>
> _______________________________________________
> 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