From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ciaran Mulloy Subject: Worg Tutorial error: using Emacs lisp as formulas Date: Tue, 26 Aug 2014 20:18:27 +0100 Message-ID: <53FCDD83.40206@gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------------010101080007030006090008" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:55146) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XMMGM-0006cs-Kr for emacs-orgmode@gnu.org; Tue, 26 Aug 2014 15:18:44 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XMMGG-0002bU-QB for emacs-orgmode@gnu.org; Tue, 26 Aug 2014 15:18:38 -0400 Received: from mail-we0-x230.google.com ([2a00:1450:400c:c03::230]:57490) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XMMGG-0002bO-KJ for emacs-orgmode@gnu.org; Tue, 26 Aug 2014 15:18:32 -0400 Received: by mail-we0-f176.google.com with SMTP id q58so15131322wes.21 for ; Tue, 26 Aug 2014 12:18:31 -0700 (PDT) Received: from [192.168.15.101] ([89.124.44.33]) by mx.google.com with ESMTPSA id w20sm15173981wie.7.2014.08.26.12.18.29 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 26 Aug 2014 12:18:30 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: org-mode This is a multi-part message in MIME format. --------------010101080007030006090008 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi! I was fascinated to work through the examples provided in the org-tutorials sections under Worg and really see the power of using eLisp as spreadsheet formula: http://orgmode.org/worg/org-tutorials/org-spreadsheet-lisp-formulas.html However the use of the mapconcat function always generated an error: Invalid regex "Regular expression too big", even with only a few terms in the formula. The offending formula was: #+TBLFM: @2$3='(mapconcat 'identity (delete-dups (list @2$1..@>$1 @2$2..@>$2)) " ") I experimented with variations of the formula getting the same error every time. I did a search of the org-mode forum without finding any solution. Any thoughts? Regard --------------010101080007030006090008 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi!
I was fascinated to work through the examples provided in the org-tutorials sections under Worg and really see the power of using eLisp as spreadsheet formula: http://orgmode.org/worg/org-tutorials/org-spreadsheet-lisp-formulas.html

However the use of the mapconcat function always generated an error: Invalid regex "Regular expression too big", even with only a few terms in the formula.

The offending formula was:

#+TBLFM: @2$3='(mapconcat 'identity (delete-dups (list @2$1..@>$1 @2$2..@>$2)) " ")

I experimented with variations of the formula getting the same error every time.

I did a search of the org-mode forum without finding any solution.

Any thoughts?

Regard --------------010101080007030006090008--