Hi, everybody,
Org-mode version 6.22b
GNU Emacs 22.3.1 (i386-mingw-nt5.1.2600) of 2008-09-06 on SOFT-MJASON
I found an unexpected behaviour, a bug ?, in TBLFM
(well I've already reported it in
http://lists.gnu.org/archive/html/emacs-orgmode/2009-01/msg00252.html
but I didn't provide a report clear enough;
ah, the importance of proper bug reports ;-)
table (from manual):
|---+---------+--------+--------+--------+-------+------|
| | Student | Prob 1 | Prob 2 | Prob 3 | Total | Note |
|---+---------+--------+--------+--------+-------+------|
| ! | | P1 | P2 | P3 | Tot | |
| # | Maximum | 12 | 15 | 25 | | 52.0 |
| ^ | | m1 | m2 | m3 | mt | |
|---+---------+--------+--------+--------+-------+------|
| # | Peter | 10 | 8 | 23 | | 41.0 |
| # | Sam | 2 | 4 | 3 | | 9.0 |
|---+---------+--------+--------+--------+-------+------|
| | Average | | | | 25.0 | |
| ^ | | | | | at | |
| $ | max=10 | | | | | |
|---+---------+--------+--------+--------+-------+------|
#+TBLFM: $6=vsum($P1..$P3)::$7=10*$Tot/$max;%.1f::$at=vmean(@address@hidden
I);%.1f
BUG :
A column can't be referred with its name,
if it is left hand side of a formula.
(Please try changing $6 with $Tot in the first formula )
Well I don't know if this is a bug or a constrain in
the implementation.
This being the case I think it should be
documented in the manual in the section (Field formulas) like:
"The left hand side of a formula may also be a named field,
but not a named column"