From mboxrd@z Thu Jan  1 00:00:00 1970
From: Andrea Rossetti <andrea.rossetti@gmail.com>
Subject: Re: Worg Tutorial error: using Emacs lisp as formulas
Date: Wed, 27 Aug 2014 19:17:43 +0200
Message-ID: <84lhq9ua14.fsf@gmail.com>
References: <53FCDD83.40206@gmail.com>
	<87a96qhcfb.fsf@alphaville.dokosmarshall.org>
	<53FD8701.4060707@gmail.com> <53FDA2E2.7030502@druidsoftware.com>
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]:56833)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <andrea.rossetti@gmail.com>) id 1XMgrB-0005XD-LU
	for emacs-orgmode@gnu.org; Wed, 27 Aug 2014 13:18:10 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <andrea.rossetti@gmail.com>) id 1XMgr2-0005j2-JP
	for emacs-orgmode@gnu.org; Wed, 27 Aug 2014 13:18:01 -0400
Received: from mail-wg0-x234.google.com ([2a00:1450:400c:c00::234]:39481)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <andrea.rossetti@gmail.com>) id 1XMgr2-0005ik-Ab
	for emacs-orgmode@gnu.org; Wed, 27 Aug 2014 13:17:52 -0400
Received: by mail-wg0-f52.google.com with SMTP id a1so501637wgh.23
	for <emacs-orgmode@gnu.org>; Wed, 27 Aug 2014 10:17:49 -0700 (PDT)
In-Reply-To: <53FDA2E2.7030502@druidsoftware.com> (ciaran mulloy's message of
	"Wed, 27 Aug 2014 10:20:34 +0100")
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: ciaran_mulloy <cmulloy@druidsoftware.com>
Cc: emacs-orgmode@gnu.org

Hello Ciaran,

  given your example:

> | Col1 | Col2 | Col3 | Col4 | Col5 |
> |------+------+------+------+------|
> | a    | a    | :='(mapconcat 'identity (delete-dups (list @2$1..@>$1 @2$2..@>$2)) " ") | b    |      |
> | b    | a    |      |      |      |
> | c    | d    |      |      |      |
> #+TBLFM: @2$3='(mapconcat 'identity (delete-dups (list @2$1..@>$1 @2$2..@>$2)) " ")

  I confirm I see your same hitting C-c C-c in the cell containing the
  formula. My setup is:

  - Org 8.2.7c
  - GNU Emacs 24.3.1 (i386-mingw-nt6.1.7600) of 2013-03-17 on MARVIN
  - Win 7

  Further observations I collected are:

  1) if I use "II-1" instead of ">" in the formula
     (though it's not exactly the same) it works properly.

  2) I tried to reduce the test case to a simpler formula:
     for example :='(length (list @2$1..@>$1)) gave me
     another, maybe more helpful error message:

     user-error: Spreadsheet error: invalid reference
     "'(length (list @2$1..@>$1))"

toggle-debug-on-error did not work for case 2) because
it's a "catched" error condition. Some random debugging 
made me think the problem lies in (or around) function
`org-table-get-range'. 

  Kindest regards,

  Andrea