From mboxrd@z Thu Jan  1 00:00:00 1970
From: Cecil Westerhof <CecilWesterhof@xs4all.nl>
Subject: Re: Strange problem with spreadsheet
Date: Thu, 21 Jun 2007 10:45:24 +0200
Message-ID: <1182415525.20841.19.camel@Barebusta.DecebalComp>
References: <1182414777.20841.14.camel@Barebusta.DecebalComp>
Mime-Version: 1.0
Content-Type: text/plain
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 1I1IIC-0005G3-Lu
	for emacs-orgmode@gnu.org; Thu, 21 Jun 2007 04:45:28 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1I1IIB-0005Fr-7K
	for emacs-orgmode@gnu.org; Thu, 21 Jun 2007 04:45:28 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1I1IIB-0005Fo-3q
	for emacs-orgmode@gnu.org; Thu, 21 Jun 2007 04:45:27 -0400
Received: from smtp-vbr8.xs4all.nl ([194.109.24.28])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <CecilWesterhof@xs4all.nl>) id 1I1IIA-00017r-Kt
	for emacs-orgmode@gnu.org; Thu, 21 Jun 2007 04:45:26 -0400
Received: from Barebusta.DecebalComp (DecebalComputing.xs4all.nl
	[213.84.157.201])
	by smtp-vbr8.xs4all.nl (8.13.8/8.13.8) with ESMTP id l5L8jPUb018261
	for <emacs-orgmode@gnu.org>; Thu, 21 Jun 2007 10:45:25 +0200 (CEST)
	(envelope-from CecilWesterhof@xs4all.nl)
In-Reply-To: <1182414777.20841.14.camel@Barebusta.DecebalComp>
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: org-mode <emacs-orgmode@gnu.org>

Op do, 21-06-2007 te 10:32 +0200, schreef Cecil Westerhof:
> I have the following tables:
> |-------------------|
> |             22.50 |
> |             16.50 |
> |-------------------|
> | :=vsum(@-II..@-I) |
> |-------------------|
> #+TBLFM: @3$1=vsum(@-II..@-I)
> 
> |------------------------|
> |                  22.50 |
> |                  16.50 |
> |------------------------|
> | :=vsum(@-II..@-I);%.2f |
> |------------------------|
> #+TBLFM: @3$1=vsum(@-II..@-I);%.2f
> 
> With the first I get '39.' when I let the table be evaluated.
> But I want 39.00. That is why I created the second table. But here I get
> on evaluation: 'Args out of range: 15,16'.
> 
> I have the feeling that it could have something to do with the upgrade
> to 4.78, but I am not sure. (Before I was using 4.71.)

There is definitly something broken between 4.71 and 4.78. In a table I
have
	:=vsum(@II..@-I);%.2f
This worked without a problem. Now I get:
	Args out of rang: 14, 15
Also here when I remove the ';%.2f', it works. (But is not displayed the
way I want.)

-- 
Cecil Westerhof <CecilWesterhof@xs4all.nl>