From mboxrd@z Thu Jan  1 00:00:00 1970
From: Cecil Westerhof <cldwesterhof@gmail.com>
Subject: Check on empty does not work
Date: Sun, 1 Jun 2014 11:50:15 +0200
Message-ID: <CAG-LmmA9-7DcEd5Kn4UxLjLfhZvG4FTQqe7eWnEJBACJz+_=UQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=001a1138f656a6078904fac33490
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:36527)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1Wr2PB-0001s0-TX
	for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 05:50:18 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1Wr2PB-00056p-1n
	for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 05:50:17 -0400
Received: from mail-qg0-x22f.google.com ([2607:f8b0:400d:c04::22f]:36173)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1Wr2PA-00056f-KO
	for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 05:50:16 -0400
Received: by mail-qg0-f47.google.com with SMTP id j107so8863355qga.6
	for <emacs-orgmode@gnu.org>; Sun, 01 Jun 2014 02:50:15 -0700 (PDT)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: emacs-orgmode@gnu.org

--001a1138f656a6078904fac33490
Content-Type: text/plain; charset=UTF-8

I am trying the following:
    #+TBLFM: @-I$4..@+I$4 = if("$3" == "nan", string(""), $3 - $2) ; %.1f
and:
    #+TBLFM: @-I$4..@+I$4 = if("$3" == "", string(""), $3 - $2) ; %.1f

But in both case the fourth field is filled when the third field is empty.
What am I doing wrong?

I am using version 8.2.1.

-- 
Cecil Westerhof

--001a1138f656a6078904fac33490
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:courier =
new,monospace">I am trying the following:<br>=C2=A0=C2=A0=C2=A0 #+TBLFM: @-=
I$4..@+I$4 =3D if(&quot;$3&quot; =3D=3D &quot;nan&quot;, string(&quot;&quot=
;), $3 - $2) ; %.1f<br>and:<br>
=C2=A0=C2=A0=C2=A0 #+TBLFM: @-I$4..@+I$4 =3D if(&quot;$3&quot; =3D=3D &quot=
;&quot;, string(&quot;&quot;), $3 - $2) ; %.1f <br><br></div><div class=3D"=
gmail_default" style=3D"font-family:courier new,monospace">But in both case=
 the fourth field is filled when the third field is empty. What am I doing =
wrong?<br>
<br></div><div class=3D"gmail_default" style=3D"font-family:courier new,mon=
ospace">I am using version 8.2.1.<br clear=3D"all"></div><br>-- <br>Cecil W=
esterhof
</div>

--001a1138f656a6078904fac33490--