From mboxrd@z Thu Jan 1 00:00:00 1970 From: Cecil Westerhof Subject: Strange problem with spreadsheet Date: Thu, 21 Jun 2007 10:32:57 +0200 Message-ID: <1182414777.20841.14.camel@Barebusta.DecebalComp> Mime-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1I1I68-0001MH-SB for emacs-orgmode@gnu.org; Thu, 21 Jun 2007 04:33:00 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1I1I67-0001M5-BV for emacs-orgmode@gnu.org; Thu, 21 Jun 2007 04:33:00 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1I1I67-0001M2-3l for emacs-orgmode@gnu.org; Thu, 21 Jun 2007 04:32:59 -0400 Received: from smtp-vbr5.xs4all.nl ([194.109.24.25]) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1I1I66-0007dU-LE for emacs-orgmode@gnu.org; Thu, 21 Jun 2007 04:32:58 -0400 Received: from Barebusta.DecebalComp (DecebalComputing.xs4all.nl [213.84.157.201]) by smtp-vbr5.xs4all.nl (8.13.8/8.13.8) with ESMTP id l5L8Wv9p010267 for ; Thu, 21 Jun 2007 10:32:57 +0200 (CEST) (envelope-from CecilWesterhof@xs4all.nl) 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 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.) -- Cecil Westerhof