Re: [O] Check on empty does not work

[Cecil Westerhof]

2014-06-01 11:50 GMT+02:00 Cecil Westerhof <address@hidden>:

I am trying the following:
    #+TBLFM: @address@hidden = if("$3" == "nan", string(""), $3 - $2) ; %.1f
and:
    #+TBLFM: @address@hidden = 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.

​The following does work:
    #+TBLFM: @address@hidden = if($3 - $2 == -$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?

--
Cecil Westerhof