From mboxrd@z Thu Jan 1 00:00:00 1970 From: Bastien Subject: Re: Re: org-table formulas with missing values Date: Sun, 27 Feb 2011 12:45:15 +0100 Message-ID: <87ipw5prxc.fsf@altern.org> References: <86aahitzny.fsf@googlemail.com> <86ei6utkez.fsf@googlemail.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from [140.186.70.92] (port=37438 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Ptg09-0001xX-8Q for emacs-orgmode@gnu.org; Sun, 27 Feb 2011 07:45:34 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Ptg04-0008Ii-A5 for emacs-orgmode@gnu.org; Sun, 27 Feb 2011 07:45:28 -0500 Received: from mail-fx0-f41.google.com ([209.85.161.41]:54623) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Ptg03-0008He-Ut for emacs-orgmode@gnu.org; Sun, 27 Feb 2011 07:45:24 -0500 Received: by mail-fx0-f41.google.com with SMTP id 5so3518728fxm.0 for ; Sun, 27 Feb 2011 04:45:23 -0800 (PST) In-Reply-To: <86ei6utkez.fsf@googlemail.com> (Thorsten's message of "Sun, 27 Feb 2011 01:01:40 +0100") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Thorsten Cc: emacs-orgmode@gnu.org Hi Thorsten, Thorsten writes: > Ok, trial and error suggests that missing values in numeric columns can > be represented as 0 in formulas, in string columns as "". Is there > something like NaN in calc/org-table? I don't know what is NaN. Can you give an example of what you're trying to achieve? -- Bastien