From mboxrd@z Thu Jan  1 00:00:00 1970
From: Christoph LANGE <math.semantic.web@gmail.com>
Subject: How to use symbolic names to refer to spreadsheet fields containing
 irregular values
Date: Wed, 3 Aug 2016 23:31:46 +0200
Message-ID: <482abd44-b7e5-6bd3-b741-3b939b322fc1@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:49761)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <math.semantic.web@gmail.com>) id 1bV3lh-0006nC-UZ
	for emacs-orgmode@gnu.org; Wed, 03 Aug 2016 17:32:02 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <math.semantic.web@gmail.com>) id 1bV3ld-0003MH-Mh
	for emacs-orgmode@gnu.org; Wed, 03 Aug 2016 17:32:00 -0400
Received: from mail-wm0-x230.google.com ([2a00:1450:400c:c09::230]:37934)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <math.semantic.web@gmail.com>) id 1bV3ld-0003Lc-G2
	for emacs-orgmode@gnu.org; Wed, 03 Aug 2016 17:31:57 -0400
Received: by mail-wm0-x230.google.com with SMTP id o80so354643395wme.1
	for <emacs-orgmode@gnu.org>; Wed, 03 Aug 2016 14:31:57 -0700 (PDT)
Received: from [192.168.1.5] (x4d0b64ea.dyn.telefonica.de. [77.11.100.234])
	by smtp.googlemail.com with ESMTPSA id
	a21sm347726wma.10.2016.08.03.14.31.54 for <emacs-orgmode@gnu.org>
	(version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
	Wed, 03 Aug 2016 14:31:54 -0700 (PDT)
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" <emacs-orgmode@gnu.org>

Dear all,

I would like to make the following work (with Org 8.3.5):

|---+----------+--------+---|
|   |    13:13 | -      | 1 |
| ^ |        h | s      | n |
|---+----------+--------+---|
|   | 13:13:00 | #ERROR | 1 |
|---+----------+--------+---|
#+TBLFM: @3$2=$h;T::@3$3=$s::@3$4=$n

I can give the field @1$2 the symbolic name $h, I can give the field
@1$4 the symbolic name $n, and I can successfully refer to both of them
in @3.

However I didn't manage to refer to @1$3 using the symbolic name $s.
The reason must be the value "-".  If I use an alphabetic string value,
it works.

Any ideas?  Or is this a bug?

Thank you very much in advance,

Christoph

-- 
Dr. Christoph Lange, Enterprise Information Systems Department
Applied Computer Science @ University of Bonn; Fraunhofer IAIS
http://langec.wordpress.com/about, Skype duke4701

→ Please note: I will be on parental leave from 29 July to 28 October.
  Colleagues will stand in for me by project.