From mboxrd@z Thu Jan  1 00:00:00 1970
From: Eric S Fraga <e.fraga@ucl.ac.uk>
Subject: [bug] Error evaluating table expression with relative references
Date: Wed, 20 May 2015 15:23:14 +0100
Message-ID: <87k2w3l44t.fsf@pinto.chemeng.ucl.ac.uk>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:56443)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1Yv4u4-0007oi-VN
	for emacs-orgmode@gnu.org; Wed, 20 May 2015 10:23:25 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1Yv4tz-0006A7-VF
	for emacs-orgmode@gnu.org; Wed, 20 May 2015 10:23:24 -0400
Received: from mail-db3on0129.outbound.protection.outlook.com
	([157.55.234.129]:28858
	helo=emea01-db3-obe.outbound.protection.outlook.com)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1Yv4tz-00068z-Ov
	for emacs-orgmode@gnu.org; Wed, 20 May 2015 10:23:19 -0400
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Hello,

I seem to have encountered a bug in table spreadsheet evaluations.  See
this example:

#+begin_src org
  ,* Table evaluation with relative references
  | 1 | 2 | 3 |      6 |
  | 1 | 2 | 3 | #ERROR |
  ,#+TBLFM: @1$4=vsum($1..$3)::@2$4=vsum($1..$-1)
#+end_src

As far as I can tell, the two formulae should be equivalent?  Or am I
missing something silly (not unlikely ;-)?

Turning on debugging shows that the first formula gets converted to
vsum([1,2,3]) whereas the second goes to vsum((1)..(3)).

This is with git updated a minute ago and with emacs -Q.

Thanks,
eric

-- 
: Eric S Fraga (0xFFFCF67D), Emacs 24.4.1, Org release_8.3beta-1154-g6ba251