From mboxrd@z Thu Jan  1 00:00:00 1970
From: Eric Schulte <eric.schulte@gmx.com>
Subject: Re: what's wrong with this sbe?
Date: Mon, 05 Mar 2012 10:46:39 -0700
Message-ID: <878vjfaqkg.fsf@gmx.com>
References: <8762ejdxe3.fsf@ed.ac.uk> <87r4x7ax0x.fsf@gmx.com>
	<87wr6zc6ub.fsf@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:36179)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <eric.schulte@gmx.com>) id 1S4c0F-0006Gc-NR
	for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:47:21 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <eric.schulte@gmx.com>) id 1S4bzs-0005Mh-4X
	for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:47:19 -0500
Received: from mailout-us.gmx.com ([74.208.5.67]:52496)
	by eggs.gnu.org with smtp (Exim 4.71)
	(envelope-from <eric.schulte@gmx.com>) id 1S4bzr-0005MS-UC
	for emacs-orgmode@gnu.org; Mon, 05 Mar 2012 12:46:56 -0500
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: Myles English <mylesenglish@gmail.com>
Cc: emacs-orgmode Mode <emacs-orgmode@gnu.org>

Myles English <mylesenglish@gmail.com> writes:

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

Good idea, I've just pushed up a documentation improvement.

Thanks,

>
> Myles

-- 
Eric Schulte
http://cs.unm.edu/~eschulte/