From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nicolas Goaziou <mail@nicolasgoaziou.fr>
Subject: Re: part of table name in remote(NAME, ...) is mangled by
 org-edit-special
Date: Mon, 15 Apr 2019 12:30:34 +0200
Message-ID: <871s23sgqd.fsf@nicolasgoaziou.fr>
References: <CAGyPOvBCuabAp8o=zRoKaaZc8=eGYd95_0P+qOdPoX-UW9kHvw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([209.51.188.92]:38633)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1hFysv-0007rg-4S
	for emacs-orgmode@gnu.org; Mon, 15 Apr 2019 06:30:45 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1hFysu-0004Dm-9M
	for emacs-orgmode@gnu.org; Mon, 15 Apr 2019 06:30:45 -0400
Received: from relay11.mail.gandi.net ([217.70.178.231]:54369)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <mail@nicolasgoaziou.fr>)
	id 1hFysu-0004D9-0G
	for emacs-orgmode@gnu.org; Mon, 15 Apr 2019 06:30:44 -0400
In-Reply-To: <CAGyPOvBCuabAp8o=zRoKaaZc8=eGYd95_0P+qOdPoX-UW9kHvw@mail.gmail.com>
	(Tony E. Bennett's message of "Sun, 14 Apr 2019 14:03:35 -0400")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode/>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: "Tony E. Bennett" <tony.e.bennett@gmail.com>
Cc: emacs-orgmode@gnu.org

Hello,

"Tony E. Bennett" <tony.e.bennett@gmail.com> writes:

> A reference to a table name such as '2019-Q1-X' is rewritten to '2019-@1$17-X'
> by org-edit-special.  And also for '2019_Q1_X'.     v9.2.3
>
> Test case:
>
>       |---+----+--------|
>       | # | Q1 | 600.00 |
>       |---+----+--------|
>
>       #+TBLFM: @1$3=remote(2019-*Q1*-X,$total)
>
>       #+NAME: 2019-Q1-X
>       |----+--------|
>
>       | _  |  total |
>       | *  | 600.00 |
>       |----+--------|
>
> With cursor in 1st table, invoke org-edit-special with:  C-x '
>
> Then save the edit with C-c C-c and notice TBLFM is now:
>
>       #+TBLFM: @1$3=remote(2019-*@1$17*-X,$total)
>
> A workaround is to use 1Q instead of Q1 in table name.

Try setting `org-table-use-standard-references' to nil.

I think this should be the default.

Regards,

-- 
Nicolas Goaziou