emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Bug in the org spreadsheet?
@ 2008-04-13  6:19 Nikos Apostolakis
  0 siblings, 0 replies; only message in thread
From: Nikos Apostolakis @ 2008-04-13  6:19 UTC (permalink / raw)
  To: emacs-orgmode

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

^ permalink raw reply	[flat|nested] only message in thread

only message in thread, other threads:[~2008-04-13  6:20 UTC | newest]

Thread overview: (only message) (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2008-04-13  6:19 Bug in the org spreadsheet? Nikos Apostolakis

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).