emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Uwe Brauer
Subject: Re: remote calls to tables and (empty entry, NAN)
Date: Fri, 07 Jun 2024 13:47:53 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux)

> Hi,

> Uwe Brauer <oub@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 

Attachment: smime.p7s
Description: S/MIME cryptographic signature


reply via email to

[Prev in Thread] Current Thread [Next in Thread]