[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
smime.p7s
Description: S/MIME cryptographic signature