From mboxrd@z Thu Jan 1 00:00:00 1970 From: meingbg Subject: Re: Spreadsheet bug? Date: Thu, 23 Jul 2009 12:17:03 +0200 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MTvMK-0007cy-Rh for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 06:17:08 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MTvMG-0007Tm-S7 for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 06:17:08 -0400 Received: from [199.232.76.173] (port=48057 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MTvMG-0007TQ-AN for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 06:17:04 -0400 Received: from mail-fx0-f209.google.com ([209.85.220.209]:48445) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MTvMG-0007hA-2h for emacs-orgmode@gnu.org; Thu, 23 Jul 2009 06:17:04 -0400 Received: by fxm5 with SMTP id 5so162742fxm.42 for ; Thu, 23 Jul 2009 03:17:03 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org > 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.