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

Hi Uwe On Thu, Jun 22, 2017 at 9:56 AM, Uwe Brauer wrote: > #+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15;%.1f);E > > And friends did not work any more > > | 3.25 | 0.5) | > | | 0.0) | > #+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15;%.1f);E This is invalid syntax, what you meant wo

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

> Hello, > Uwe Brauer writes: > One possibility: > | 3.25 | 0.4875 | > | || > | 2.25 | 0.3375 | > #+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15);E Great but how can I round? #+TBLFM: $2=if("$1" == "nan", string(""), $1*0.15;%.1f);E And

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

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

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

Please consider this | 3.25 | 0.4875 | | | 0. | | 2.25 | 0.3375 | #+TBLFM: $2=$1*0.15 How can I avoid the entry 0. ? I could insert ** Giving | 3.25 | 0.4875 | | ** | #ERROR | | 2.25 | 0.3375 | #+TBLFM: $2=$1*0.15 But this is cumbersome, any other possibilities? Thanks Uwe B