From mboxrd@z Thu Jan 1 00:00:00 1970 From: Cecil Westerhof Subject: Re: Check on empty does not work Date: Sun, 1 Jun 2014 12:00:51 +0200 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a1138f65690cfc604fac35a4c Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:37676) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Wr2ZU-0005ip-9i for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 06:00:57 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Wr2ZQ-00080D-Dr for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 06:00:56 -0400 Received: from mail-qg0-x230.google.com ([2607:f8b0:400d:c04::230]:64488) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Wr2ZQ-000803-Au for emacs-orgmode@gnu.org; Sun, 01 Jun 2014 06:00:52 -0400 Received: by mail-qg0-f48.google.com with SMTP id i50so8932974qgf.21 for ; Sun, 01 Jun 2014 03:00:51 -0700 (PDT) In-Reply-To: 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: emacs-orgmode@gnu.org --001a1138f65690cfc604fac35a4c Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 2014-06-01 11:50 GMT+02:00 Cecil Westerhof : > I am trying the following: > #+TBLFM: @-I$4..@+I$4 =3D if("$3" =3D=3D "nan", string(""), $3 - $2) = ; %.1f > and: > #+TBLFM: @-I$4..@+I$4 =3D if("$3" =3D=3D "", 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. > =E2=80=8BThe following does work: #+TBLFM: @-I$4..@+I$4 =3D if($3 - $2 =3D=3D -$2, string(""), $3 - $2) ; But is not what is described. I removed %.1f because that displays an empty string as 0.0. Is it possible to use %.1f without making an empty field displayed as 0.0? --=20 Cecil Westerhof --001a1138f65690cfc604fac35a4c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
2014= -06-01 11:50 GMT+02:00 Cecil Westerhof <cldwesterhof@gmail.com>= ;:
I am trying the following:
=C2= =A0=C2=A0=C2=A0 #+TBLFM: @-I$4..@+I$4 =3D if("$3" =3D=3D "na= n", string(""), $3 - $2) ; %.1f
and:
=C2=A0=C2=A0=C2=A0 #+TBLFM: @-I$4..@+I$4 =3D if("$3" =3D=3D "= ;", string(""), $3 - $2) ; %.1f

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

I am using versi= on 8.2.1.
=

=E2=80=8BThe following does work:
=C2=A0=C2=A0=C2=A0 #+TBLFM: @-I$4..@+I= $4 =3D if($3 - $2 =3D=3D -$2, string(""), $3 - $2) ;

But is not what is described.

I removed
=C2=A0=C2=A0=C2=A0 %= .1f
because that displays an empty string as 0.0.

Is = it possible to use %.1f without making an empty field displayed as 0.0?

--
Cecil Westerhof
--001a1138f65690cfc604fac35a4c--