all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* simple spreadsheet question - hlines affecting formulas
@ 2008-10-17 21:00 Sullivan, Gregory (US SSA)
  2008-10-19  9:23 ` Carsten Dominik
  0 siblings, 1 reply; 2+ messages in thread
From: Sullivan, Gregory (US SSA) @ 2008-10-17 21:00 UTC (permalink / raw)
  To: Org Mode List

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(@2..@-1)

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 "@2..@-1" range.


|-------+---------|
| Name  | Percent |
|-------+---------|
| Foo   |      .1 |
|-------+---------|
| Bar   |      .3 |
|-------+---------|
| Total |     2.8 |
|-------+---------|
#+TBLFM: @4$2=vsum(@2..@-1)


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)
gregory.sullivan@baesystems.com 

^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2008-10-19  9:23 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2008-10-17 21:00 simple spreadsheet question - hlines affecting formulas Sullivan, Gregory (US SSA)
2008-10-19  9:23 ` Carsten Dominik

Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.