Reference cells of other tables in org-mode table as plain text

Question

I intent to copy the value of a cell and put the exact copy to the target cell and be able to update the value on referenced cell to be updated on the targeted one.

Calling remote to a cell evaluate its value and then return the result of the process which might be different then the original text.

In my case remoted cells have '.' and '/' symbols. So far I tried these:

#+NAME: t1
|   | 01.02.2003 |
| ^ |        foo |

#+NAME: t2
| #ERROR |
#+TBLFM: @1=remote(t1,@1$2)

#+NAME: t3
| (01.02.2003) |
#+TBLFM: @1=string("remote(t1,@1$2)

#+NAME: t4
| ((01.02.2003)) |
#+TBLFM: @1=string("remote(t1,$foo)

#+NAME: t5
| "01.02.2003" |

#+NAME: t6
| 01.02.2003 |
#+TBLFM: @1=string(remote(t5,@1$1)

Edit: To explain further. Basically I want to...

#+NAME: t1
| 01.02.2003 | --------> Edit this cell and expect to update the value of -->|
                                                                             |
#+NAME: t2                                                                   |
| 01.02.2003 | <--- this cell -------------------------------------------<

Answer 1

I believe the following works to literally copy a cell from one table to another. Try it and see:

#+NAME: t1
|   | 01/03.03  |
| ^ | foo       |

#+NAME: t2
| 01/03.03 |
#+TBLFM: @1$1='(identity remote(t1, @1$2))

although I'm not sure how useful it will be to you: it depends on what exactly you want to do afterwards.

EDIT: I don't know why org mode adds parentheses in the named reference case:

#+NAME: t1
|   | 01/03.03  |
| ^ | foo       |

#+NAME: t2
| (01/03.03) |
#+TBLFM: @1$1='(identity remote(t1, $foo))

When I debug the formula, the parentheses are part of the string, so I believe org mode does that, not Calc. You can get rid of them using the lisp substring function, but I don't know of a way to treat the two cases uniformly:

#+NAME: t2
| 01/03.03 |
#+TBLFM: @1$1='(identity (substring remote(t1, $foo) 1 -1))