From mboxrd@z Thu Jan 1 00:00:00 1970 From: Thorsten Subject: Re: org-table formulas with missing values Date: Sun, 27 Feb 2011 01:01:40 +0100 Message-ID: <86ei6utkez.fsf@googlemail.com> References: <86aahitzny.fsf@googlemail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from [140.186.70.92] (port=40610 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1PtU5I-00043r-Ni for emacs-orgmode@gnu.org; Sat, 26 Feb 2011 19:02:05 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1PtU5E-0002cA-0S for emacs-orgmode@gnu.org; Sat, 26 Feb 2011 19:02:00 -0500 Received: from lo.gmane.org ([80.91.229.12]:58682) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1PtU5D-0002bz-RN for emacs-orgmode@gnu.org; Sat, 26 Feb 2011 19:01:55 -0500 Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1PtU5C-0005VS-6f for emacs-orgmode@gnu.org; Sun, 27 Feb 2011 01:01:54 +0100 Received: from g231108249.adsl.alicedsl.de ([92.231.108.249]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 27 Feb 2011 01:01:54 +0100 Received: from gruenderteam.berlin by g231108249.adsl.alicedsl.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 27 Feb 2011 01:01:54 +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: emacs-orgmode@gnu.org Thorsten writes: > Hello, > how do I best enter missing values in an org-tabel (just empty cells or NaN?) > and how do I use that missing values in formulas? 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?