From mboxrd@z Thu Jan  1 00:00:00 1970
From: Myles English <mylesenglish@gmail.com>
Subject: Re: what's wrong with this sbe?
Date: Mon, 05 Mar 2012 17:17:14 +0000
Message-ID: <87r4x7c6hx.fsf@gmail.com>
References: <8762ejdxe3.fsf@ed.ac.uk> <87r4x7ax0x.fsf@gmx.com>
	<87wr6zc6ub.fsf@gmail.com>
Reply-To: Eric Schulte <eric.schulte@gmx.com>,
	emacs-orgmode Mode <emacs-orgmode@gnu.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:59010)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mylesenglish@gmail.com>) id 1S4bTH-0003z0-KJ
	for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:13:21 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mylesenglish@gmail.com>) id 1S4bTE-0005DA-SQ
	for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:13:15 -0500
Received: from mail-we0-f169.google.com ([74.125.82.169]:39476)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mylesenglish@gmail.com>) id 1S4bTE-0005Cs-Jy
	for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:13:12 -0500
Received: by werj55 with SMTP id j55so3239842wer.0
	for <emacs-orgmode@gnu.org>; Mon, 05 Mar 2012 09:13:10 -0800 (PST)
In-Reply-To: <87wr6zc6ub.fsf@gmail.com> (Myles English's message of "Mon, 05
	Mar 2012 17:09:48 +0000")
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: Eric Schulte <eric.schulte@gmx.com>, emacs-orgmode Mode <emacs-orgmode@gnu.org>

>> On Mon, 05 Mar 2012 17:09:48 +0000, Myles English said:

>> On Mon, 05 Mar 2012 07:34:49 -0700, Eric Schulte said:

  >> Myles English <mylesenglish@gmail.com> 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

Yeah, I got these two blocks the wrong way around:

  > #+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


Myles