From: Michael Brand <michael.ch.brand@gmail.com>
To: Christoph LANGE <math.semantic.web@gmail.com>
Cc: "emacs-orgmode@gnu.org" <emacs-orgmode@gnu.org>
Subject: Re: How to use symbolic names to refer to spreadsheet fields containing irregular values
Date: Thu, 4 Aug 2016 08:42:31 +0200 [thread overview]
Message-ID: <CALn3zojaFvzP1HtKR1uig=Zk-1YtYBdhcxaYOW0QB3e5kH8dkA@mail.gmail.com> (raw)
In-Reply-To: <482abd44-b7e5-6bd3-b741-3b939b322fc1@gmail.com>
Hi Christoph
On Wed, Aug 3, 2016 at 11:31 PM, Christoph LANGE
<math.semantic.web@gmail.com> wrote:
> 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,
"-" is not a valid Calc expression. To copy literally one needs a Lisp
formula:
|---+----------+---+---|
| | 13:13 | - | 1 |
| ^ | h | s | n |
|---+----------+---+---|
| | 13:13:00 | - | 1 |
|---+----------+---+---|
#+TBLFM: @3$2 = $h; T :: @3$3 = '(identity "$s") :: @3$4 = $n
Michael
prev parent reply other threads:[~2016-08-04 6:42 UTC|newest]
Thread overview: 2+ messages / expand[flat|nested] mbox.gz Atom feed top
2016-08-03 21:31 How to use symbolic names to refer to spreadsheet fields containing irregular values Christoph LANGE
2016-08-04 6:42 ` Michael Brand [this message]
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='CALn3zojaFvzP1HtKR1uig=Zk-1YtYBdhcxaYOW0QB3e5kH8dkA@mail.gmail.com' \
--to=michael.ch.brand@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=math.semantic.web@gmail.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).