Re: [O] empty cells in columns should be left emtpy when manipulating columns

[Nicolas Goaziou]

Hello,

Uwe Brauer <o...@mat.ucm.es> 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