[[SOLVED?]] (was: remote calls to tables and (empty entry, NAN))

>>> "UB" == Uwe Brauer writes: > Hi again >> Uwe Brauer writes: >> This works for me: >> #+TBLFM: $2=if(typeof(remote(table2, @@#$7)) == 12, string(""), >> remote(table2, @@#$7)); E > As you can see in the table2 the row Miller-and-Smith have been > interchanged and so the final table ends

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

Hi again > Uwe Brauer writes: > This works for me: >#+TBLFM: $2=if(typeof(remote(table2, @@#$7)) == 12, string(""), > remote(table2, @@#$7)); E I just realized that the @@#$7 is not save against errors #+begin_src * Simple remote #+Name: table1 | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5

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

> Hi, > Uwe Brauer 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 > )

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

Hi, Uwe Brauer writes: > However if in table1 there is an empty entry in the relevant column, > remote copies it as 0 > > #+begin_src > > #+NAME: table2 > | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 | > |+-+-+-+-+-+| > | Smith | | 3 | 4 | 6 |

remote calls to tables and (empty entry, NAN)

Hi The following works nicely #+begin_src #+NAME: table1 | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 | |+-+-+-+-+-+| | Smith | 2 | 3 | 4 | 6 | 7 | 22 | | Miller | 2 | 10 | 1 | 1 | 5 | 19 | | Wick | 1 | 2 | 3 | 10 |