From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ciaran Mulloy Subject: Re: Worg Tutorial error: using Emacs lisp as formulas Date: Wed, 27 Aug 2014 08:21:37 +0100 Message-ID: <53FD8701.4060707@gmail.com> References: <53FCDD83.40206@gmail.com> <87a96qhcfb.fsf@alphaville.dokosmarshall.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:56871) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XMXYB-0000S6-Ey for emacs-orgmode@gnu.org; Wed, 27 Aug 2014 03:21:53 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XMXY5-0007Be-L9 for emacs-orgmode@gnu.org; Wed, 27 Aug 2014 03:21:47 -0400 Received: from mail-wi0-x232.google.com ([2a00:1450:400c:c05::232]:54742) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XMXY5-0007BR-Db for emacs-orgmode@gnu.org; Wed, 27 Aug 2014 03:21:41 -0400 Received: by mail-wi0-f178.google.com with SMTP id hi2so5263053wib.5 for ; Wed, 27 Aug 2014 00:21:40 -0700 (PDT) Received: from [192.168.15.102] ([89.124.44.33]) by mx.google.com with ESMTPSA id ua8sm14700975wjc.7.2014.08.27.00.21.39 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Wed, 27 Aug 2014 00:21:39 -0700 (PDT) In-Reply-To: <87a96qhcfb.fsf@alphaville.dokosmarshall.org> 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: emacs-orgmode@gnu.org On 27/08/14 03:52, Nick Dokos wrote: > Ciaran Mulloy writes: > >> 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? >> > I can't reproduce it - e.g. this > > --8<---------------cut here---------------start------------->8--- > | one | two | three | four | five | > |-----+-----+---------------+------+------| > | a | a | a b c e f d g | | | > | a | b | | | | > | b | a | | | | > | c | d | | | | > | e | f | | | | > | f | g | | | | > | a | f | | | | > #+TBLFM: @2$3='(mapconcat 'identity (delete-dups (list @2$1..@>$1 @2$2..@>$2)) " ") > --8<---------------cut here---------------end--------------->8--- > > works fine for me. This is with more-or-less latest org. > > Moreover, none of the functions used (mapconcat, identity, delete-dups > or list) use regexps at all. There is a chance that regexps are used by > the evaluator when building the ranges, but it's unlikely IMO, so the > regexp error seems like a red herring to me. How big a table did you > try? Did you try restarting emacs and redoing the evaluation? How about > starting emacs without any of your customizations and redoing the > evaluation? Something like this > > emacs -q -l /path/to/minimal/init /path/to/file/with/the/table > > where the minimal init file just sets load-path if necessary and > initializes org. > Hi Nick, Many thanks for your input. The table I was trying was the example in the tutorial shown as follows (not big) and no hint of a regex!: | 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 did as you suggested and ran emacs -q -l ~/.emacs ~/path_to_file and got the same result as above: org-table-eval-formula: Invalid regexp: "Regular expression too big" The .emacs file is blank. The version of emacs is GNU Emacs 24.3.1 (x86_64-pc-linux-gnu, ) of 2013-07-27 on roseapple, modified by Debian Org-mode version 7.9.3f (release_7.9.3f-17-g7524ef @ /usr/share/emacs/24.3/lisp/org/) Using Mint 17 Xfce. I don't think I'm doing something silly here but am at a loss to figure out the problem.