Re: remote calls to tables and (empty entry, NAN)

[General discussions about Org-mode.]

> Hi,

> Uwe Brauer <o...@mat.ucm.es> writes:


> This works for me:

>    #+TBLFM: $2=if(typeof(remote(table2, @@#$7)) == 12, string(""), 
> remote(table2, @@#$7)); E

Thanks very much!

> (everything is documented here:
>    
> https://orgmode.org/manual/Formula-syntax-for-Calc.html#Formula-syntax-for-Calc
> )

> This works too, although I'm not sure it should:

>    #+TBLFM: $2=if("remote(table2, @@#$7)" = "nan", string(""), remote(table2, 
> @@#$7)); E

This I tried but without the " in front of remote

$2=if(remote(table2, @@#$7)" = "nan", string(""), remote(table2, @@#$7)); E


And obtained an error. I think I will stick to the typeof syntaxes.

Uwe 

smime.p7s
Description: S/MIME cryptographic signature