Relative row specifications do not cross horizontal separator lines,
this is documented in the manual.
- Carsten
On Oct 17, 2008, at 11:00 PM, Sullivan, Gregory (US SSA) wrote:
The following spreadsheet behaves as expected, and every time I hit
C-c* on the "Total" row, the formula recalculates to 0.4
| Name | Percent |
| Foo | .1 |
| Bar | .3 |
| Total | 0.4 |
#+TBLFM: @4$2=vsum(@[EMAIL PROTECTED])
The following spreadsheet is exactly the same, and has exactly the
same formula for cell @4$2, except that I've added horizontal
lines. I thought horizontal lines are ignored during calculations,
but now whenever I hit C-c* on the "Total" row, the vsum seems to
include the value of @4$2, which I expected would be left out of the
"@[EMAIL PROTECTED]" range.
|-------+---------|
| Name | Percent |
|-------+---------|
| Foo | .1 |
|-------+---------|
| Bar | .3 |
|-------+---------|
| Total | 2.8 |
|-------+---------|
#+TBLFM: @4$2=vsum(@[EMAIL PROTECTED])
Is this a bug?
Thanks.
--Greg
--
Gregory T. Sullivan, Ph.D.
BAE Systems Advanced Information Technologies
6 New England Executive Park, Burlington, MA 01803
781-262-4553 (office), 978-430-3461 (cell)
[EMAIL PROTECTED]
_______________________________________________
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
_______________________________________________
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
