From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: spreadsheet: empty field should be an empty field. Date: Tue, 16 Sep 2014 11:56:54 +0200 Message-ID: References: <87ppew6ijq.fsf@mat.ucm.es> <87d2avkik8.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:42107) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XTpVM-00045t-1p for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 05:57:01 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XTpVK-0002KG-Fa for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 05:56:59 -0400 Received: from mail-qa0-x232.google.com ([2607:f8b0:400d:c00::232]:55915) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XTpVK-0002Jx-B4 for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 05:56:58 -0400 Received: by mail-qa0-f50.google.com with SMTP id dc16so5146708qab.37 for ; Tue, 16 Sep 2014 02:56:54 -0700 (PDT) In-Reply-To: <87d2avkik8.fsf@gmail.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: Org Mode On Tue, Sep 16, 2014 at 11:42 AM, Thorsten Jolitz wrote: > 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 Yes, and I already documented the OP use case in the second example here: http://orgmode.org/manual/Formula-syntax-for-Calc.html Michael