From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Tony E. Bennett" Subject: part of table name in remote(NAME, ...) is mangled by org-edit-special Date: Sun, 14 Apr 2019 14:03:35 -0400 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="00000000000076dd5e0586815bc2" Return-path: Received: from eggs.gnu.org ([209.51.188.92]:49588) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1hFjZy-0005GC-O9 for emacs-orgmode@gnu.org; Sun, 14 Apr 2019 14:10:11 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1hFjTq-0005s2-De for emacs-orgmode@gnu.org; Sun, 14 Apr 2019 14:03:52 -0400 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]:36938) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1hFjTp-0005qO-7S for emacs-orgmode@gnu.org; Sun, 14 Apr 2019 14:03:50 -0400 Received: by mail-lj1-x234.google.com with SMTP id v13so13482506ljk.4 for ; Sun, 14 Apr 2019 11:03:48 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org --00000000000076dd5e0586815bc2 Content-Type: text/plain; charset="UTF-8" Hello, 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. *--tony* --00000000000076dd5e0586815bc2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

A reference to a table name such as '2019= -Q1-X' is rewritten to '2019-@1$17-X' by org-edit-special.=C2= =A0 And also for '2019_Q1_X'.=C2=A0=C2=A0=C2=A0=C2=A0 v9.2.3

Test case:

=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 |---+----+--------|
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | = # | Q1 | 600.00 |
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |---+----+--------|
= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 #+TBLFM: @1$3=3Dremote(2019-Q1-X,$tot= al)

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 #+NAME: 2019-Q1-X
=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 |----+--------|
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | _=C2= =A0 |=C2=A0 total |
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | *=C2=A0 | 600.00 |<= br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |----+--------|

With cursor in 1st table, invoke org-ed= it-special with:=C2=A0 C-x '

Then save the edit with C-c C-c and notice TBLFM is now:

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 #+TBLFM: @1$3=3Dremote(2019-= @1$17-X,$total)

A workaround is to use 1Q instead of Q1 in table name.=

=

<= i>--tony

--00000000000076dd5e0586815bc2--