From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Sullivan, Gregory \(US SSA\)" Subject: simple spreadsheet question - hlines affecting formulas Date: Fri, 17 Oct 2008 17:00:28 -0400 Message-ID: <73kku8$6ti3h@dmzms99901.na.baesystems.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1KqwR4-0003Ew-JQ for emacs-orgmode@gnu.org; Fri, 17 Oct 2008 17:00:38 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1KqwR2-0003Eb-DZ for emacs-orgmode@gnu.org; Fri, 17 Oct 2008 17:00:37 -0400 Received: from [199.232.76.173] (port=60580 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1KqwR2-0003EI-6M for emacs-orgmode@gnu.org; Fri, 17 Oct 2008 17:00:36 -0400 Received: from dmzms99901.na.baesystems.com ([149.32.200.65]:1335) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1KqwR1-0001Gz-FD for emacs-orgmode@gnu.org; Fri, 17 Oct 2008 17:00:35 -0400 content-class: urn:content-classes:message List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org 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=3Dvsum(@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=3Dvsum(@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),=A0 978-430-3461 (cell) gregory.sullivan@baesystems.com=20