From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Richard Subject: Re: spreadsheet: empty field should be an empty field. Date: Tue, 16 Sep 2014 12:22:53 +0200 Message-ID: <87ppev6f0i.fsf@geodiff-mac3.ulb.ac.be> References: <87ppew6ijq.fsf@mat.ucm.es> <87d2avkik8.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:46686) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XTps7-00006t-Jj for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 06:20:36 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XTps0-0001BH-Pn for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 06:20:31 -0400 Received: from mxin.ulb.ac.be ([164.15.128.112]:7054) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XTps0-0001A3-Ir for emacs-orgmode@gnu.org; Tue, 16 Sep 2014 06:20:24 -0400 In-Reply-To: (Michael Brand's message of "Tue, 16 Sep 2014 11:56:54 +0200") 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: Michael Brand Cc: Org Mode Michael Brand writes: > 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 This is something I tend to forget (and usually work around with some lisp). Thanks for the reminder. -- Nicolas Richard