From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nikos Apostolakis Subject: Bug in the org spreadsheet? Date: Sun, 13 Apr 2008 02:19:56 -0400 Message-ID: <87tzi6e0oj.fsf@Sullivan.bcc.cuny.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1JkvZT-0002Jx-7m for emacs-orgmode@gnu.org; Sun, 13 Apr 2008 02:20:11 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1JkvZR-0002J0-QT for emacs-orgmode@gnu.org; Sun, 13 Apr 2008 02:20:10 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1JkvZR-0002IU-BZ for emacs-orgmode@gnu.org; Sun, 13 Apr 2008 02:20:09 -0400 Received: from main.gmane.org ([80.91.229.2] helo=ciao.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1JkvZR-0003sA-Dx for emacs-orgmode@gnu.org; Sun, 13 Apr 2008 02:20:09 -0400 Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JkvZL-0001uK-26 for emacs-orgmode@gnu.org; Sun, 13 Apr 2008 06:20:03 +0000 Received: from 199.219.160.30 ([199.219.160.30]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 13 Apr 2008 06:20:03 +0000 Received: from nikos.ap by 199.219.160.30 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 13 Apr 2008 06:20:03 +0000 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 Hello group, it seems that algebraic entries on tables are not always parsed correctly by org mode, or is it calc's fault? For example in the following table the the entry @2$4 should be -a^4 - a^2 b^2 | Term | Components | vac | Contribution | |------+------------+------------+-------------------------------| | a a | 2 | -a^2 - b^2 | -a^4 - b^2 | | a b | 1 | 1 | a b | | b a | 1 | 1 | b a | | b b | 2 | -a^2 -b^2 | -(b^2 a^2) - b^2 | |------+------------+------------+-------------------------------| | | | | 2 a b - a^4 - a^2 b^2 - 2 b^2 | #+TBLFM: $4=$1*$3::@6$4=simplify(expand(vsum(@-I..@-II))) I can get the spreadsheet to do what I mean by using parentheses as in the following table, but IMHO it shouldn't be necessary. | Term | Components | vac | Contribution | |------+------------+--------------+-------------------------------| | a a | 2 | (-a^2 - b^2) | -(a^2 (b^2 + a^2)) | | a b | 1 | 1 | a b | | b a | 1 | 1 | b a | | b b | 2 | (-a^2 -b^2) | -(b^2 (b^2 + a^2)) | |------+------------+--------------+-------------------------------| | | | | 2 a b - a^4 - b^4 - 2 a^2 b^2 | #+TBLFM: $4=$1*$3::@6$4=simplify(expand(vsum(@-I..@-II))) ,----[ M-x version ] | GNU Emacs 23.0.60.1 (i486-pc-linux-gnu, GTK+ Version 2.12.9) of | 2008-04-07 on elegiac, modified by Debian `---- ,----[ M-x org-version ] | Org-mode version 5.23a `---- Thanks, Nikos