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
