From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Goaziou Subject: Re: empty cells in columns should be left emtpy when manipulating columns Date: Thu, 22 Jun 2017 09:34:56 +0200 Message-ID: <8737as8ogv.fsf@nicolasgoaziou.fr> References: <87shislc0r.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:36137) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dNwdq-0002xp-RD for emacs-orgmode@gnu.org; Thu, 22 Jun 2017 03:35:03 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dNwdm-0004xI-QL for emacs-orgmode@gnu.org; Thu, 22 Jun 2017 03:35:02 -0400 Received: from relay4-d.mail.gandi.net ([217.70.183.196]:43660) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1dNwdm-0004wn-Jr for emacs-orgmode@gnu.org; Thu, 22 Jun 2017 03:34:58 -0400 Received: from saiph.selenimh (000043010000000000000469.ipv6.commingeshautdebit.fr [IPv6:2a03:a0a0:0:4301::469]) (Authenticated sender: mail@nicolasgoaziou.fr) by relay4-d.mail.gandi.net (Postfix) with ESMTPSA id 2FDDB1720B4 for ; Thu, 22 Jun 2017 09:34:57 +0200 (CEST) Received: from ngz by saiph.selenimh with local (Exim 4.89) (envelope-from ) id 1dNwdk-0000qB-O9 for emacs-orgmode@gnu.org; Thu, 22 Jun 2017 09:34:56 +0200 In-Reply-To: <87shislc0r.fsf@mat.ucm.es> (Uwe Brauer's message of "Thu, 22 Jun 2017 07:25:24 +0000") 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" To: emacs-orgmode@gnu.org Hello, Uwe Brauer writes: > Please consider this > > | 3.25 | 0.4875 | > | | 0. | > | 2.25 | 0.3375 | > > #+TBLFM: $2=$1*0.15 > > How can I avoid the entry 0. ? One possibility: | 3.25 | 0.4875 | | | | | 2.25 | 0.3375 | #+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15);E Regards, -- Nicolas Goaziou