emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

* part of table name in remote(NAME, ...) is mangled by org-edit-special
@ 2019-04-14 18:03 Tony E. Bennett
  2019-04-15 10:30 ` Nicolas Goaziou
  0 siblings, 1 reply; 3+ messages in thread
From: Tony E. Bennett @ 2019-04-14 18:03 UTC (permalink / raw)
  To: emacs-orgmode

[-- 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 --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

• * Re: part of table name in remote(NAME, ...) is mangled by org-edit-special
    2019-04-14 18:03 part of table name in remote(NAME, ...) is mangled by org-edit-special Tony E. Bennett
  @ 2019-04-15 10:30 ` Nicolas Goaziou
    2019-04-15 16:43   ` Tony E. Bennett
    0 siblings, 1 reply; 3+ messages in thread
  From: Nicolas Goaziou @ 2019-04-15 10:30 UTC (permalink / raw)
    To: Tony E. Bennett; +Cc: emacs-orgmode
  
  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
  
  ^ permalink raw reply	[flat|nested] 3+ messages in thread

• • * Re: part of table name in remote(NAME, ...) is mangled by org-edit-special
      2019-04-15 10:30 ` Nicolas Goaziou
    @ 2019-04-15 16:43   ` Tony E. Bennett
      0 siblings, 0 replies; 3+ messages in thread
    From: Tony E. Bennett @ 2019-04-15 16:43 UTC (permalink / raw)
      To: emacs-orgmode
    
    [-- 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 --]
    
    ^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2019-04-15 16:43 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2019-04-14 18:03 part of table name in remote(NAME, ...) is mangled by org-edit-special Tony E. Bennett
2019-04-15 10:30 ` Nicolas Goaziou
2019-04-15 16:43   ` Tony E. Bennett

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).