emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] spreadsheet: empty field should be an empty field.


From: Thorsten Jolitz
Subject: Re: [O] spreadsheet: empty field should be an empty field.
Date: Tue, 16 Sep 2014 11:42:31 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux)

Uwe Brauer <address@hidden> writes:

> Hello
>
> Consider the following table.
>
>
> | Name   | Ex 1 | Ex2 | Ex + Ex2 |
> | smith  |    1 |   2 |        3 |
> | miller |      |     |        0 |
> #+TBLFM: $4=$2+$3
>
>
> Miller has no entries in Ex1 and Ex2 but when using C-u C-u C-c C-c also
> Ex2+Ex3 gets an entry namely zero. I don't like this I would prefer if
> this field remains empty.
>
> Any way of achieving this?

I think something like NaN was introduced to Org-tbls, but I don't
remember the exact syntax, maybe try with 'nan':

http://lists.gnu.org/archive/html/emacs-orgmode/2012-12/msg00983.html

-- 
cheers,
Thorsten




reply via email to

[Prev in Thread] Current Thread [Next in Thread]