emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Myles English <mylesenglish@gmail.com>
To: Eric Schulte <eric.schulte@gmx.com>,
	emacs-orgmode Mode <emacs-orgmode@gnu.org>
Subject: Re: what's wrong with this sbe?
Date: Mon, 05 Mar 2012 17:09:48 +0000	[thread overview]
Message-ID: <87wr6zc6ub.fsf@gmail.com> (raw)
In-Reply-To: <87r4x7ax0x.fsf@gmx.com> (Eric Schulte's message of "Mon, 05 Mar 2012 07:34:49 -0700")


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

Myles

  reply	other threads:[~2012-03-05 17:05 UTC|newest]

Thread overview: 7+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2012-03-05 12:51 what's wrong with this sbe? Myles English
2012-03-05 14:09 ` Sebastien Vauban
2012-03-05 15:29   ` Myles English
2012-03-05 14:34 ` Eric Schulte
2012-03-05 17:09   ` Myles English [this message]
2012-03-05 17:17     ` Myles English
2012-03-05 17:46     ` Eric Schulte

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87wr6zc6ub.fsf@gmail.com \
    --to=mylesenglish@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=eric.schulte@gmx.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).