From mboxrd@z Thu Jan 1 00:00:00 1970 From: Myles English Subject: Re: what's wrong with this sbe? Date: Mon, 05 Mar 2012 17:09:48 +0000 Message-ID: <87wr6zc6ub.fsf@gmail.com> References: <8762ejdxe3.fsf@ed.ac.uk> <87r4x7ax0x.fsf@gmx.com> Reply-To: Myles English , emacs-orgmode Mode Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from eggs.gnu.org ([208.118.235.92]:41688) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1S4bM5-00022V-Tv for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:05:51 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1S4bM3-000392-Bs for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:05:49 -0500 Received: from mail-we0-f169.google.com ([74.125.82.169]:38196) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1S4bM3-00038F-2B for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:05:47 -0500 Received: by werj55 with SMTP id j55so3233673wer.0 for ; Mon, 05 Mar 2012 09:05:45 -0800 (PST) In-Reply-To: <87r4x7ax0x.fsf@gmx.com> (Eric Schulte's message of "Mon, 05 Mar 2012 07:34:49 -0700") 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: Eric Schulte , emacs-orgmode Mode >> On Mon, 05 Mar 2012 07:34:49 -0700, Eric Schulte said: > Myles English writes: >> Hi, >> >> Please could tell me where I am going wrong with this? I just >> can't get the source block to put a result in the table. [etc] > Hi Miles, > To force the value of "236:30:00" to be interpreted as a string > (rather than have sbe try to convert it to a number prefix the > reference with a "$" character). However even doing this your > example exposed a bug in this sbe functionality to which I've just > pushed up a fix. With the latest version of Org-mode the attached > works as expected. > #+name: workingDays #+BEGIN_SRC emacs-lisp :var hms="0" (require > 'org-timer) (/ (org-timer-hms-to-secs hms) (* 60 60 8)) #+END_SRC > Note the variable reference is prefixed with a "$" to ensure that it > is interpreted as a string. See the `sbe' documentation for full > `sbe' usage information. > -- Eric Schulte http://cs.unm.edu/~eschulte/ Thanks Eryk that solves the problem! I actually did try with an extra "$" but it didn't work so I assumed that I had misunderstood the documentation. Reading the documentation again, I think it could be improved, perhaps #+begin_quote to force interpretation of a cell's value as a string, prefix the identifier with two "$"s rather than a single "$" #+end_quote instead of #+begin_quote to force interpretation of a cell's value as a string, prefix the identifier with another "$", (e.g. @2$2 becomes $@2$2) #+end_quote Thanks again, Myles