org-edit-special screws up org-table with remote calls

[Uwe Brauer]

Hi all

I have 

** Ej1
   :PROPERTIES:
   :ID:       test-num-jun10-2025-ej1
   :END: 

#+begin_src 

#+TBLNAME: stat-25-jun10-E1
|    | E1 |
|----+----|
|  1 |  0 |
|  2 |  0 |
|  3 |  0 |
|  4 |  0 |
|  5 |  0 |
|  6 |  0 |
|  7 |  0 |
|  8 |  0 |
|  9 |  0 |
| 10 |  0 |
| 11 |  0 |
| 12 |  0 |
| 13 |  0 |
| 14 |  0 |
| 15 |  0 |
| 16 |  0 |
| 17 |  0 |
| 18 |  0 |
| 19 |  0 |
| 20 |  0 |
|----+----|
 #+end_src

I run 
=org-id-update-id-locations=

Then I create

#+begin_src 

#+TBLNAME: stat-25-jun10-res
|    | E1 | E2 |
|----+----+----|
|  1 |    |    |
|  2 |    |    |
|  3 |    |    |
|  4 |    |    |
|  5 |    |    |
|  6 |    |    |
|  7 |    |    |
|  8 |    |    |
|  9 |    |    |
| 10 |    |    |
| 11 |    |    |
| 12 |    |    |
| 13 |    |    |
| 14 |    |    |
| 15 |    |    |
| 16 |    |    |
| 17 |    |    |
| 18 |    |    |
| 19 |    |    |
| 20 |    |    |
|----+----+----|
#+TBLFM: $2='(org-lookup-first $1 
'(remote(test-num-jun10-2025-ej1,@I$1..@II$1)) 
'(remote(test-num-jun10-2025-ej1, @I$2..@II$2)))
#+end_src

Then  I run =org-edit-special=

And obtain 
#+begin_src 

#+TBLNAME: stat-25-jun10-res
|    | E1 | E2 |
|----+----+----|
|  1 |    |    |
|  2 |    |    |
|  3 |    |    |
|  4 |    |    |
|  5 |    |    |
|  6 |    |    |
|  7 |    |    |
|  8 |    |    |
|  9 |    |    |
| 10 |    |    |
| 11 |    |    |
| 12 |    |    |
| 13 |    |    |
| 14 |    |    |
| 15 |    |    |
| 16 |    |    |
| 17 |    |    |
| 18 |    |    |
| 19 |    |    |
| 20 |    |    |
|----+----+----|
#+TBLFM: $2='(org-lookup-first $1 
'(remote(test-num-jun10-2025-@1$140,@I$1..@II$1)) 
'(remote(test-num-jun10-2025-@1$140, @I$2..@II$2)))

#+end_src

Ej1 has been replace by -@1$140 why????

Regards

Uwe Brauer


-- 
I strongly condemn Hamas heinous despicable pogroms/atrocities on Israel
I strongly condemn Putin's war of aggression against Ukraine.

smime.p7s
Description: S/MIME cryptographic signature