From mboxrd@z Thu Jan 1 00:00:00 1970 From: William Henney Subject: BUG in reference by ID to remote table (was Re: org babel question: reference tables in remote file) Date: Sun, 27 Apr 2014 23:24:12 -0500 Message-ID: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary=001a11c2e2b805644104f812b078 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40987) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Wed71-0005Tn-5C for emacs-orgmode@gnu.org; Mon, 28 Apr 2014 00:24:16 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Wed70-0003Vx-32 for emacs-orgmode@gnu.org; Mon, 28 Apr 2014 00:24:15 -0400 Received: from mail-ig0-x234.google.com ([2607:f8b0:4001:c05::234]:53169) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Wed6z-0003Vm-RU for emacs-orgmode@gnu.org; Mon, 28 Apr 2014 00:24:14 -0400 Received: by mail-ig0-f180.google.com with SMTP id c1so4338475igq.13 for ; Sun, 27 Apr 2014 21:24:13 -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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode Cc: Arun Persaud --001a11c2e2b805644104f812b078 Content-Type: multipart/alternative; boundary=001a11c2e2b805643e04f812b076 --001a11c2e2b805643e04f812b076 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable There is an apparent bug when using the ID property to refer to cells in remote tables, which is currently the only way to refer to a table in an external file. This is illustrated in the attached org file. In brief, the bug is triggered by any ID that contains a sequence matching the regexp "-[A-Z]+[0-9]+-", which org wants to interpret as a spreadsheet-style cell reference. Also, it would be more user friendly if CUSTOM_ID properties could also be used in this way. Would that be easy to implement? Will On Thu, Apr 17, 2014 at 1:45 PM, Bastien wrote: > Hi Arun, > > Arun Persaud writes: > > > thanks for the answer. It would be nice to be able to reference tables > > in other files easily though, so some form of : would > > be great for the remote call. Is there some special ref syntax that > > could be used here? > > remote(NAME-OR-ID,REF) > > describes a reference to a table in a section, possibly in a different > file, and the ID property is probably more stable than a filename, so > I'd argue that what we have is enough. > > -- > Bastien > > --=20 Dr William Henney, Centro de Radioastronom=C3=ADa y Astrof=C3=ADsica, Universidad Nacional Aut=C3=B3noma de M=C3=A9xico, Campus Morelia --001a11c2e2b805643e04f812b076 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
There is an apparent bug when using the ID property to ref= er to cells in remote tables, which is currently the only way to refer to a= table in an external file.=C2=A0

This is illustrated in= the attached org file. =C2=A0In brief, the bug is triggered by any ID that= contains a sequence matching the regexp "-[A-Z]+[0-9]+-", which = org wants to interpret as a spreadsheet-style cell reference.=C2=A0

Also, it would be more user friendly if CUSTOM_ID prope= rties could also be used in this way. =C2=A0Would that be easy to implement= ?

Will=C2=A0

On Thu, Apr 17, 2014 at 1:45 PM, Bastien <bzg@gnu.org> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">
Hi Arun,

Arun Persaud <apersaud@lbl.gov&g= t; writes:

> thanks for the answer. It would be nice to be ab= le to reference tables
> in other files easily though, so some form of <path>:<tablena= me> would
> be great for the remote call. Is there some special ref syntax that > could be used here?

=C2=A0 =C2=A0 =C2=A0remote(NAME-OR-ID,REF)

describes a reference to a table in a section, possibly in a different
file, and the ID property is probably more stable than a filename, so
I'd argue that what we have is enough.

--
=C2=A0Bastien




--
=C2=A0 Dr William Henney, Centro de Radioastronom=C3=ADa y Astrof=C3= =ADsica,
=C2=A0 Universidad Nacional Aut=C3=B3noma de M=C3=A9xico, Campu= s Morelia
--001a11c2e2b805643e04f812b076-- --001a11c2e2b805644104f812b078 Content-Type: application/octet-stream; name="remote-ref-test.org" Content-Disposition: attachment; filename="remote-ref-test.org" Content-Transfer-Encoding: base64 X-Attachment-Id: f_huj9fti00 IytPUFRJT05TOiBeOnt9CgoqIFRhcmdldCB0YWJsZSBvbmUKOlBST1BFUlRJRVM6CjpDVVNUT01f SUQ6IHRhcmdldC10YWJsZQo6SUQ6ICAgICAgIDQ0Qzg0RTEyLUM4M0EtNEM3Ni05MUYzLTNBOUMz MDlDN0RGMwo6RU5EOgoKIytuYW1lOiB0YXJnZXQtdGFibGUtMQp8IHRhcmdldDEgIHwKCiogVGFy Z2V0IHRhYmxlIHR3bwo6UFJPUEVSVElFUzoKOklEOiAgICAgICBBNDEzMzIzMS0wODBDLTRDQ0It QTk5Qi1FNjg2NjY4NjIxNzQKOkVORDoKIytuYW1lOiB0YXJnZXQtdGFibGUtMgp8IHRhcmdldDIg IHwKCgoqIFJlZmVyZW5jZSB0byBhIGNlbGwgaW4gYSByZW1vdGUgdGFibGUgdmlhIHRoZSBJRCBw cm9wZXJ0eQoKKiogQ2FzZSB0aGF0IHdvcmtzCiMrbmFtZTogdGFibGUtcmVmLXRoYXQtd29ya3MK fCB0YXJnZXQyIHwKIytUQkxGTTogQDEkMT1yZW1vdGUoQTQxMzMyMzEtMDgwQy00Q0NCLUE5OUIt RTY4NjY2ODYyMTc0LEAxJDEpCisgRGlyZWN0bHkgZWRpdGluZyB0aGUgVEJMRk0gbGluZSB3b3Jr cwogICsgRXZhbHVhdGluZyB0aGUgZm9ybXVsYSAoZS5nLiwgd2l0aCDigJxDLWMgKuKAnSkgd2ls bCBjb3JyZWN0bHkgY29weSB0aGUgY2VsbCBmcm9tIHRoZSByZW1vdGUgdGFibGUKCioqIENhc2Ug dGhhdCBmYWlscwojK25hbWU6IHRhYmxlLXJlZi10aGF0LWZhaWxzCnwgOj1yZW1vdGUoQTQxMzMy MzEtMDgwQy00Q0NCLUE5OUItRTY4NjY2ODYyMTc0LEAxJDEpICAgICAgIHwKIytUQkxGTTogQDEk MT1yZW1vdGUoQDQxMzMyMzEkMS0wODBDLTRDQ0ItQTk5Qi1ANjg2NjY4NjIxNzQkNSxAMSQxKQor IEJ1dCBhZGRpbmcgdGhlIHJlbW90ZSByZWZlcmVuY2Ugd2l0aCDigJxDLXUgQy1jID3igJ0gZmFp bHMKKyBBcyBkb2VzIHVzaW5nIHRoZSBmb3JtdWxhIGVkaXRvciAo4oCcQy1jICfigJ0pCisgQXMg dG9vIGRvZXMgZW50ZXJpbmcgdGhlIGZvcm11bGEgaW4gdGhlIGNlbGwgZGlyZWN0bHkgd2l0aCB0 aGUg4oCcOj3igJ0gbWV0aG9kCisgVGhlIGVycm9yIGlzIAojK0JFR0lOX0VYQU1QTEUKb3JnLXRh YmxlLWdldC1yYW5nZTogQXJncyBvdXQgb2YgcmFuZ2U6IFtuaWwgMjddLCA0MTMzMjMxCiMrRU5E X0VYQU1QTEUKKyBOb3RlIHRoYXQgdGhlIHNlY3Rpb24gb2YgdGhlIElEIOKAnC1BNDEzMzIzMS3i gJ0gaXMgY29udmVydGVkIHRvIOKAnC1ANDEzMzIzMSQxLeKAnSBpbiB0aGUgVEJMRk0gbGluZSwg d2hpY2ggaXMgcHJlc3VtYWJseSB0aGUgc291cmNlIG9mIHRoZSBidWcKKyBPcmcgc2VlbXMgdG8g YmUgaW50ZXJwcmV0aW5nIGl0IGFzIGEgc3ByZWFkc2hlZXQtc3R5bGUgY2VsbCByZWZlcmVuY2Ug dG8gYSBjZWxsIHRoYXQgZG9lcyBub3QgZXhpc3QKKyBUaGlzIGlzIHJlbWluaXNjZW50IG9mIGFu b3RoZXIgW1todHRwOi8vbGlzdHMuZ251Lm9yZy9hcmNoaXZlL2h0bWwvZW1hY3Mtb3JnbW9kZS8y MDEwLTAzL21zZzAwMTQ0Lmh0bWxdW2J1ZyB0aGF0IENhcnN0ZW4gZml4ZWQgZm9yIG1lXV0gc2V2 ZXJhbCB5ZWFycyBhZ28KCioqIE5vdCBhbGwgSURzIGhhdmUgdGhpcyBwcm9ibGVtCiMrbmFtZTog c29tZS1pZHMtYWx3YXlzLXdvcmsKfCB0YXJnZXQxIHwKIytUQkxGTTogQDEkMT1yZW1vdGUoNDRD ODRFMTItQzgzQS00Qzc2LTkxRjMtM0E5QzMwOUM3REYzLEAxJDEpCisgW1tpZDo0NEM4NEUxMi1D ODNBLTRDNzYtOTFGMy0zQTlDMzA5QzdERjNdW1RhcmdldCB0YWJsZSBvbmVdXSBkb2VzIG5vdCBo YXZlIHRoaXMgcHJvYmxlbS4KKyBJdCBzZWVtcyB0aGF0IGluIG9yZGVyIHRvIHRyaWdnZXIgdGhl IGJ1ZyB0aGUgSUQgbXVzdCBjb250YWluIGEgc2VjdGlvbiB0aGF0IGJvdGgKICAxLiBTdGFydHMg d2l0aCBhIGxldHRlciAob3Igc2VxdWVuY2Ugb2YgbGV0dGVycykgcmF0aGVyIHRoYW4gYSBkaWdp dCwgYW5kCiAgMi4gRG9lcyBub3QgY29udGFpbiBhbnkgb3RoZXIgbGV0dGVycywgb25seSBkaWdp dHMKKyBGcm9tIHZlcnkgc21hbGwgbnVtYmVyIHN0YXRpc3RpY3MgSSB3b3VsZCBzYXkgdGhhdCBy b3VnaGx5IGhhbGYgb2YgSURzIGhhdmUgdGhlc2UgcHJvcGVydGllcwoKCioqIFRoZSBDVVNUT01f SUQgcHJvcGVydHkgY2Fubm90IGN1cnJlbnRseSBiZSB1c2VkIGluIHRoZSByZWZlcmVuY2UKfCA6 PXJlbW90ZSh0YXJnZXQtdGFibGUsQDEkMSkgfAojK1RCTEZNOiBAMSQxPXJlbW90ZSh0YXJnZXQt dGFibGUsQDEkMSkKCkVycm9yIG1lc3NhZ2U6CiMrQkVHSU5fRVhBTVBMRQp1c2VyLWVycm9yOiBD YW4ndCBmaW5kIHJlbW90ZSB0YWJsZSAidGFyZ2V0LXRhYmxlIgojK0VORF9FWEFNUExFCgoqIEVt YWNzIGFuZCBvcmcgdmVyc2lvbnMgdGVzdGVkCiMrQkVHSU5fU1JDIGVsaXNwCihlbWFjcy12ZXJz aW9uKQojK0VORF9TUkMKCiMrUkVTVUxUUzoKOiBHTlUgRW1hY3MgMjQuMy4xICh4ODZfNjQtYXBw bGUtZGFyd2luMTMuMS4wLCBDYXJib24gVmVyc2lvbiAxLjYuMCBBcHBLaXQgMTI2NS4xOSkKOiAg b2YgMjAxNC0wNC0yMiBvbiBpcmlzLmxvY2FsCgojK0JFR0lOX1NSQyBlbGlzcAoob3JnLXZlcnNp b24pCiMrRU5EX1NSQwoKIytSRVNVTFRTOgo6IDguMi41aAoK --001a11c2e2b805644104f812b078--