[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