From mboxrd@z Thu Jan  1 00:00:00 1970
From: Frederick Giasson <fred@fgiasson.com>
Subject: Table (used a "spreadsheet") org-sbe issues when the value is a
 string
Date: Wed, 22 Jun 2016 08:37:36 -0400
Message-ID: <35a64fca-7d01-b382-15f0-568d93af4f61@fgiasson.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:52361)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <fred@fgiasson.com>) id 1bFhPc-00009h-Hl
	for emacs-orgmode@gnu.org; Wed, 22 Jun 2016 08:37:45 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <fred@fgiasson.com>) id 1bFhPX-0004tn-Hp
	for emacs-orgmode@gnu.org; Wed, 22 Jun 2016 08:37:44 -0400
Received: from s052.panelboxmanager.com ([72.55.186.33]:43485)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <fred@fgiasson.com>) id 1bFhPX-0004tV-Di
	for emacs-orgmode@gnu.org; Wed, 22 Jun 2016 08:37:39 -0400
Received: from mailnull by s052.panelboxmanager.com with sa-checked (Exim
	4.86_1) (envelope-from <fred@fgiasson.com>) id 1bFhPS-000Zia-5x
	for emacs-orgmode@gnu.org; Wed, 22 Jun 2016 08:37:34 -0400
Received: from modemcable199.69-130-66.mc.videotron.ca ([66.130.69.199]:64273
	helo=[192.168.0.199]) by s052.panelboxmanager.com with esmtpsa
	(TLSv1.2:DHE-RSA-AES128-SHA:128) (Exim 4.86_1)
	(envelope-from <fred@fgiasson.com>) id 1bFhPR-000ZiE-T6
	for emacs-orgmode@gnu.org; Wed, 22 Jun 2016 08:37:33 -0400
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"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

Hi Everybody,

I am experiencing a few issues trying to update a cell value using 
=org-sbe= when the value of a column is a string.

Here is an example that works when the value is a number:


====================

#+NAME: average-dataset-size
#+BEGIN_SRC clojure :var f="turtle" :exports none :results value
(identity f)
#+END_SRC

#+RESULTS: average-dataset-size
: turtle


| Format | Sizes distribution in MB | Average size in MB |
|--------+--------------------------+--------------------|
|      7 |                          |                  7 |
#+TBLFM: $3='(org-sbe "average-dataset-size" (f $1))

====================

Now, if I put a string in the format column, I al getting the following:

====================

#+NAME: average-dataset-size
#+BEGIN_SRC clojure :var f="turtle" :exports none :results value
(identity f)
#+END_SRC

#+RESULTS: average-dataset-size
: turtle


| Format | Sizes distribution in MB | Average size in MB |
|--------+--------------------------+--------------------|
| turtle |                          | #ERROR             |
#+TBLFM: $3='(org-sbe "average-dataset-size" (f $1))

====================

The debugging session I have is (which doesn't tell me with Result: is 
#ERROR):

====================

Substitution history of formula
Orig:   ?
$xyz->  '(org-sbe "average-dataset-size" (f $1))
@r$c->  '(org-sbe "average-dataset-size" (f $1))
$1->    '(org-sbe "average-dataset-size" (f "turtle"))
Result: #ERROR
Format: NONE
Final:  #ERROR

====================


Note #1: (identity) is a function in Clojure that returns the same value 
that is in input.


I am wondering if this is a bug, or something that I am missing in how 
to use these features?


Thanks for helping,


Fred