From mboxrd@z Thu Jan 1 00:00:00 1970 From: meingbg Subject: Spreadsheet bug? Date: Thu, 23 Jul 2009 02:29:30 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0118393848==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MTmBh-0003c2-46 for emacs-orgmode@gnu.org; Wed, 22 Jul 2009 20:29:33 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MTmBg-0003bK-FV for emacs-orgmode@gnu.org; Wed, 22 Jul 2009 20:29:32 -0400 Received: from [199.232.76.173] (port=33385 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MTmBg-0003b5-78 for emacs-orgmode@gnu.org; Wed, 22 Jul 2009 20:29:32 -0400 Received: from fg-out-1718.google.com ([72.14.220.156]:25220) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MTmBf-0004v0-KA for emacs-orgmode@gnu.org; Wed, 22 Jul 2009 20:29:31 -0400 Received: by fg-out-1718.google.com with SMTP id l27so938234fgb.7 for ; Wed, 22 Jul 2009 17:29:30 -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 --===============0118393848== Content-Type: multipart/alternative; boundary=000e0cd24388bb268e046f549493 --000e0cd24388bb268e046f549493 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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. --000e0cd24388bb268e046f549493 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I have a table like this one:

| a |=A0 b | c |
|---+----+---|
= | a |=A0 2 | 2 |
| b |=A0 3 | 7 |
| c | -3 | 4 |
| d |=A0 5 | 9 |<= br>#+TBLFM: $3=3D$2+@-1::@2$3=3D$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 wr= iting 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 trie= d different formulas and values, and it seems like the incorrect cell is th= e sum of three cells instead of two as intended. @2$2 wasn't supposed t= o be part of the sum. Am I doing something incorrectly here?

//M.G.
--000e0cd24388bb268e046f549493-- --===============0118393848== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ 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 --===============0118393848==--