part of table name in remote(NAME, ...) is mangled by org-edit-special

part of table name in remote(NAME, ...) is mangled by org-edit-special

[Tony E. Bennett]

[-- Attachment #1: Type: text/plain, Size: 637 bytes --]

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*

[-- Attachment #2: Type: text/html, Size: 2072 bytes --]

Re: part of table name in remote(NAME, ...) is mangled by org-edit-special

[Nicolas Goaziou]

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

Re: part of table name in remote(NAME, ...) is mangled by org-edit-special

[Tony E. Bennett]

[-- Attachment #1: Type: text/plain, Size: 606 bytes --]

On Mon, Apr 15, 2019 at 6:30 AM Nicolas Goaziou <mail@nicolasgoaziou.fr>
wrote:

>
> "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
>
       ...


> > 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.


Confirmed, that fixes it for me and since I don't use the 'B3' style in org
tables it doesn't interfere with anything for me.

thanks Nicolas!

[-- Attachment #2: Type: text/html, Size: 1861 bytes --]