From mboxrd@z Thu Jan  1 00:00:00 1970
From: Thorsten Jolitz <tjolitz@gmail.com>
Subject: Re: spreadsheet: empty field should be an empty field.
Date: Tue, 16 Sep 2014 11:42:31 +0200
Message-ID: <87d2avkik8.fsf@gmail.com>
References: <87ppew6ijq.fsf@mat.ucm.es>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:38323)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XTpK1-0000vo-JL
	for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 05:45:22 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XTpJw-0007Fo-Cq
	for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 05:45:17 -0400
Received: from plane.gmane.org ([80.91.229.3]:49788)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XTpJv-0007FY-P6
	for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 05:45:12 -0400
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XTpJp-0001im-Es
	for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 11:45:05 +0200
Received: from g231227029.adsl.alicedsl.de ([92.231.227.29])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Tue, 16 Sep 2014 11:45:05 +0200
Received: from tjolitz by g231227029.adsl.alicedsl.de with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Tue, 16 Sep 2014 11:45:05 +0200
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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Uwe Brauer <oub@mat.ucm.es> 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