Re: [O] Worg Tutorial error: using Emacs lisp as formulas

[Andrea Rossetti]

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