Hey Uwe,

On 2025-06-15 16:41, Uwe Brauer wrote:
> Ej1 has been replace by -@1$140 why????
It’s related to the alphanumeric cell references like `B4' [recognized
by org]. The value of `org-table-use-standard-references' is `from' by
default, so org tries to convert `EJ1' into row-column syntax after
editing (140 is from `(org-letters-to-number "EJ")'). Another example
is:

#+begin_src org
,* Section
:PROPERTIES:
:ID:       a1-b2-c3
:END:

| 1 |

| 1 |
,#+TBLFM: @1$1=remote(a1-b2-c3, @1$1)
#+end_src

After editing, the second table becomes:

#+begin_src org
| 1 |
,#+TBLFM: @1$1=remote(@1$1-@2$2-@3$3, @1$1)
#+end_src

You can avoid this conversion by changing the option to `nil' (never
use alphanumeric references):

#+begin_src emacs-lisp
(setopt org-table-use-standard-references nil)
#+end_src

This behaviour does seem a little eager to me, but I’m unsure if it’s
expected or not. Perhaps someone more experienced can comment.

[recognized by org]
<https://orgmode.org/manual/References.html#FOOT18>

Best,

-- 
Jacob S. Gordon
jacob.as.gor...@gmail.com

======================
I strongly condemn the war crimes committed by Israel.
Please avoid sending me HTML emails and MS Office documents.
https://useplaintext.email/#etiquette
https://www.gnu.org/philosophy/no-word-attachments.html

Reply via email to