From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: 2 questions on tables Date: Mon, 15 Jul 2013 10:41:35 +0200 Message-ID: References: <871u705ngv.fsf@med.uni-goettingen.de> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:54591) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UyeLj-0003Lw-KD for emacs-orgmode@gnu.org; Mon, 15 Jul 2013 04:41:42 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UyeLh-0005fP-9A for emacs-orgmode@gnu.org; Mon, 15 Jul 2013 04:41:39 -0400 Received: from mail-lb0-x233.google.com ([2a00:1450:4010:c04::233]:50618) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UyeLh-0005fB-19 for emacs-orgmode@gnu.org; Mon, 15 Jul 2013 04:41:37 -0400 Received: by mail-lb0-f179.google.com with SMTP id w20so8995084lbh.24 for ; Mon, 15 Jul 2013 01:41:35 -0700 (PDT) In-Reply-To: <871u705ngv.fsf@med.uni-goettingen.de> 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: Andreas Leha Cc: Org Mode Hi Andreas On Mon, Jul 15, 2013 at 8:47 AM, Andreas Leha wrote: > I have two questions concerning tables in orgmode: I try to answer your first question: > 1. What is the best way to handle missing values? > I have the problem, that missing values ("") are treated as "0" when they > appear in a formula. > Entering ("nil") instead helps a bit, but does not propagate, > i.e. nil + 1 results in 0. > Can I do better? Is this what you are looking for?: | Tomato | | | | Pear | 3.00 | 6.00 | #+TBLFM: $3 = if("$2" == "nan", string(""), 2 * $2 +.0); E f-2 For "E" see http://orgmode.org/org.html#Formula-syntax-for-Calc and for "+.0; f-2" see http://orgmode.org/worg/org-faq.html#table-float-fraction Michael