* Spreadsheet bug?
@ 2009-07-23 0:29 meingbg
2009-07-23 9:04 ` Andreas Burtzlaff
0 siblings, 1 reply; 7+ messages in thread
From: meingbg @ 2009-07-23 0:29 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1.1: Type: text/plain, Size: 623 bytes --]
I have a table like this one:
| a | b | c |
|---+----+---|
| a | 2 | 2 |
| b | 3 | 7 |
| c | -3 | 4 |
| d | 5 | 9 |
#+TBLFM: $3=$2+@-1::@2$3=$2
Now, I want the value in column c in every row to be the sum of column b so
far. I try to achieve this by writing a column formula for column $3 and a
cell formula for cell @2$3. Note that cell @3$3 is incorrect whereas all the
other are correct. I have tried different formulas and values, and it seems
like the incorrect cell is the sum of three cells instead of two as
intended. @2$2 wasn't supposed to be part of the sum. Am I doing something
incorrectly here?
//M.G.
[-- Attachment #1.2: Type: text/html, Size: 670 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
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Spreadsheet bug?
2009-07-23 0:29 Spreadsheet bug? meingbg
@ 2009-07-23 9:04 ` Andreas Burtzlaff
0 siblings, 0 replies; 7+ messages in thread
From: Andreas Burtzlaff @ 2009-07-23 9:04 UTC (permalink / raw)
To: meingbg; +Cc: emacs-orgmode
On Thu, 23 Jul 2009 02:29:30 +0200
meingbg <meingbg@gmail.com> wrote:
> | a | b | c |
> |---+----+---|
> | a | 2 | 2 |
> | b | 3 | 7 |
> | c | -3 | 4 |
> | d | 5 | 9 |
> #+TBLFM: $3=$2+@-1::@2$3=$2
A good solution is to use
$3=vsum(@-I$-1..$-1)
as proposed in this thread:
http://thread.gmane.org/gmane.emacs.orgmode/1940/focus=1941
Nevertheless:
If @2$3 is manually set to 2 in the table, then the formulas produce
the expected outcome. So, the problem seems to be the order of
execution. If column c is cleared and the formulas are executed, @2$3
is read to be 0 for the summation and is set to 2 only afterwards.
Swapping the order in the TBLFM line doesn't help.
Is the order something like field formulas after column formulas?
Any chance to influence that?
Andy
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Spreadsheet bug?
@ 2009-07-23 10:17 meingbg
2009-07-23 10:39 ` Andreas Burtzlaff
0 siblings, 1 reply; 7+ messages in thread
From: meingbg @ 2009-07-23 10:17 UTC (permalink / raw)
To: emacs-orgmode
> A good solution is to use
> $3=vsum(@-I$-1..$-1)
> as proposed in this thread:
> http://thread.gmane.org/gmane.emacs.orgmode/1940/focus=1941
That works for me, thanks!
>
> Nevertheless:
>
> If @2$3 is manually set to 2 in the table, then the formulas produce
> the expected outcome. So, the problem seems to be the order of
> execution. If column c is cleared and the formulas are executed, @2$3
> is read to be 0 for the summation and is set to 2 only afterwards.
If that was the case, wouldn't @3$3 sum up to 3+0=3? Now it shows 7.
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Spreadsheet bug?
2009-07-23 10:17 meingbg
@ 2009-07-23 10:39 ` Andreas Burtzlaff
2009-07-24 15:20 ` meingbg
0 siblings, 1 reply; 7+ messages in thread
From: Andreas Burtzlaff @ 2009-07-23 10:39 UTC (permalink / raw)
To: meingbg; +Cc: emacs-orgmode
On Thu, 23 Jul 2009 12:17:03 +0200
meingbg <meingbg@gmail.com> wrote:
> > Nevertheless:
> >
> > If @2$3 is manually set to 2 in the table, then the formulas produce
> > the expected outcome. So, the problem seems to be the order of
> > execution. If column c is cleared and the formulas are executed, @2$3
> > is read to be 0 for the summation and is set to 2 only afterwards.
>
> If that was the case, wouldn't @3$3 sum up to 3+0=3? Now it shows 7.
I suspect @2$3 was 4 when you evaluated the formulas, hence the 7.
If you clear column c completely, what is the output of the evaluation then?
I get:
| a | b | c |
|---+----+---|
| a | 2 | 2 |
| b | 3 | 3 |
| c | -3 | 0 |
| d | 5 | 5 |
Andy
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Spreadsheet bug?
[not found] <20090723160554.5AA76324F7@mailhost.cs.tu-berlin.de>
@ 2009-07-24 9:20 ` Stephan Schmitt
2009-08-03 4:31 ` Carsten Dominik
0 siblings, 1 reply; 7+ messages in thread
From: Stephan Schmitt @ 2009-07-24 9:20 UTC (permalink / raw)
To: emacs-orgmode
Andreas Burtzlaff wrote:
> On Thu, 23 Jul 2009 02:29:30 +0200 meingbg <meingbg@gmail.com> wrote:
>> > | a | b | c |
>> > |---+----+---|
>> > | a | 2 | 2 |
>> > | b | 3 | 7 |
>> > | c | -3 | 4 |
>> > | d | 5 | 9 |
>> > #+TBLFM: $3=$2+@-1::@2$3=$2
>
> If @2$3 is manually set to 2 in the table, then the formulas produce
> the expected outcome. So, the problem seems to be the order of
> execution. If column c is cleared and the formulas are executed, @2$3
> is read to be 0 for the summation and is set to 2 only afterwards.
> Swapping the order in the TBLFM line doesn't help.
>
> Is the order something like field formulas after column formulas?
> Any chance to influence that?
Evaluating the field formulas before the column formulas is in general a bad
idea. Results of the field formulas will always be overwritten by the column
formulas (if there is a conflict).
Here you need to evaluate the spreadsheet twice to yield the intended result (I
get a 5 in field @2$3). From info:org:Updating the table:
> `C-u C-u C-c *'
> `C-u C-u C-c C-c'
> Iterate the table by recomputing it until no further changes occur.
> This may be necessary if some computed fields use the value of
> other fields that are computed later in the calculation sequence.
hth,
Stephan
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Spreadsheet bug?
2009-07-23 10:39 ` Andreas Burtzlaff
@ 2009-07-24 15:20 ` meingbg
0 siblings, 0 replies; 7+ messages in thread
From: meingbg @ 2009-07-24 15:20 UTC (permalink / raw)
To: emacs-orgmode
> I suspect @2$3 was 4 when you evaluated the formulas, hence the 7.
> If you clear column c completely, what is the output of the evaluation then?
The same. And so now I can't reproduce my original problem... that's
good, I guess.
> A good solution is to use
> $3=vsum(@-I$-1..$-1)
That works. Thanks!
Here's another thing I'm trying:
| a | b | c |
| | 7 | 210 |
|---+----+-----|
| a | 2 | 30 |
| b | 3 | 5 |
| c | -3 | 2 |
| d | 5 | 7 |
#+TBLFM: @2$2=vsum(@3$2..@6$2)::@2$3=vsum(@3$3..$LR3)
I want row 2 to contain sums for what's below. Is there a way to make
the LR-reference work here?
//meingbg
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Spreadsheet bug?
2009-07-24 9:20 ` Stephan Schmitt
@ 2009-08-03 4:31 ` Carsten Dominik
0 siblings, 0 replies; 7+ messages in thread
From: Carsten Dominik @ 2009-08-03 4:31 UTC (permalink / raw)
To: Stephan Schmitt; +Cc: emacs-orgmode
On Jul 24, 2009, at 11:20 AM, Stephan Schmitt wrote:
> Andreas Burtzlaff wrote:
>> On Thu, 23 Jul 2009 02:29:30 +0200 meingbg <meingbg@gmail.com> wrote:
>>>> | a | b | c |
>>>> |---+----+---|
>>>> | a | 2 | 2 |
>>>> | b | 3 | 7 |
>>>> | c | -3 | 4 |
>>>> | d | 5 | 9 |
>>>> #+TBLFM: $3=$2+@-1::@2$3=$2
>>
>
>> If @2$3 is manually set to 2 in the table, then the formulas produce
>> the expected outcome. So, the problem seems to be the order of
>> execution. If column c is cleared and the formulas are executed, @2$3
>> is read to be 0 for the summation and is set to 2 only afterwards.
>> Swapping the order in the TBLFM line doesn't help.
>>
>> Is the order something like field formulas after column formulas?
>> Any chance to influence that?
>
> Evaluating the field formulas before the column formulas is in
> general a bad
> idea. Results of the field formulas will always be overwritten by
> the column
> formulas (if there is a conflict).
When recomputing a table, Org evaluates field formulas first.
Then it does the column formulas, but never overwrites a field
that was filled with a field formula.
As mentioned elsewhere in this thread
>
> Here you need to evaluate the spreadsheet twice to yield the
> intended result (I
> get a 5 in field @2$3).
Indeed, this is what is needed here.
- Carsten
> From info:org:Updating the table:
>
>> `C-u C-u C-c *'
>> `C-u C-u C-c C-c'
>> Iterate the table by recomputing it until no further changes
>> occur.
>> This may be necessary if some computed fields use the value of
>> other fields that are computed later in the calculation sequence.
>
> hth,
> Stephan
>
>
> _______________________________________________
> 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
^ permalink raw reply [flat|nested] 7+ messages in thread
end of thread, other threads:[~2009-08-03 4:31 UTC | newest]
Thread overview: 7+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2009-07-23 0:29 Spreadsheet bug? meingbg
2009-07-23 9:04 ` Andreas Burtzlaff
-- strict thread matches above, loose matches on Subject: below --
2009-07-23 10:17 meingbg
2009-07-23 10:39 ` Andreas Burtzlaff
2009-07-24 15:20 ` meingbg
[not found] <20090723160554.5AA76324F7@mailhost.cs.tu-berlin.de>
2009-07-24 9:20 ` Stephan Schmitt
2009-08-03 4:31 ` Carsten Dominik
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).