From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carsten Dominik <carsten.dominik@gmail.com>
Subject: Re: Bug: table calculation broken again
Date: Sun, 4 Nov 2007 08:36:52 +0100
Message-ID: <12527B72-F48A-494C-9950-F308BB3F1EA1@science.uva.nl>
References: <m37il2gt8d.fsf@norvel.baumann-gauting.site>
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1Ioa2Z-0003mv-NG
	for emacs-orgmode@gnu.org; Sun, 04 Nov 2007 02:37:03 -0500
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1Ioa2W-0003lw-Vh
	for emacs-orgmode@gnu.org; Sun, 04 Nov 2007 02:37:03 -0500
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Ioa2W-0003lq-QU
	for emacs-orgmode@gnu.org; Sun, 04 Nov 2007 02:37:00 -0500
Received: from mx20.gnu.org ([199.232.41.8])
	by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.60) (envelope-from <carsten.dominik@gmail.com>)
	id 1Ioa2W-0000sS-8P
	for emacs-orgmode@gnu.org; Sun, 04 Nov 2007 02:37:00 -0500
Received: from mu-out-0910.google.com ([209.85.134.184])
	by mx20.gnu.org with esmtp (Exim 4.60)
	(envelope-from <carsten.dominik@gmail.com>) id 1Ioa2V-0008Iq-F8
	for emacs-orgmode@gnu.org; Sun, 04 Nov 2007 02:36:59 -0500
Received: by mu-out-0910.google.com with SMTP id i2so2208150mue
	for <emacs-orgmode@gnu.org>; Sun, 04 Nov 2007 00:36:58 -0700 (PDT)
In-Reply-To: <m37il2gt8d.fsf@norvel.baumann-gauting.site>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: Thomas Baumann <dtbaumann@yahoo.de>
Cc: emacs-orgmode@gnu.org


On  1Nov2007, at 11:22 AM, Thomas Baumann wrote:

> Hi Carsten and others who might help,
>
> I thought this had been solved in between but somehow
>
> |------------+------+----+------+--------|
> | 26.10.2007 | Cost | 68 | 0.30 | 110.40 |
> |------------+------+----+------+--------|
> |            | Sum  |    |      | 110.40 |
> #+TBLFM: $5=$3*$4;%.2f::@2$5=vsum(@I..@II);%.2f
>
> won't work (I almost sent an incorrect invoice ...) whereas
>
> |       Test | tt   | tt |      |       |
> |------------+------+----+------+-------|
> | 26.10.2007 | Cost | 68 | 0.30 | 20.40 |
> |------------+------+----+------+-------|
> |            | Sum  |    |      | 20.40 |
> #+TBLFM: $5=$3*$4;%.2f::@3$5=vsum(@I..@II);%.2f
>
> works fine.
>
> Orgmode is 5.13h

This is not a bug, it is intended to work like this.  A hline before  
the table
is considered a table border line, not a separator line.  I do not want
table formulas depend on the habit of a user to have or have not the  
table
start with a hline.  I will make the clearer in the docs.

- Carsten