From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: Help on spreadsheet/calc references and improvements Date: Sun, 6 Oct 2013 19:03:47 +0200 Message-ID: References: <2013-10-05T16-39-57@devnull.Karl-Voit.at> <2013-10-06T13-22-35@devnull.Karl-Voit.at> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary=001a11c37abad6b46104e81584f9 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:38294) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VSrkF-0003mt-6I for emacs-orgmode@gnu.org; Sun, 06 Oct 2013 13:03:52 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VSrkD-0001VE-JM for emacs-orgmode@gnu.org; Sun, 06 Oct 2013 13:03:51 -0400 Received: from mail-lb0-x22a.google.com ([2a00:1450:4010:c04::22a]:33357) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VSrkD-0001V4-71 for emacs-orgmode@gnu.org; Sun, 06 Oct 2013 13:03:49 -0400 Received: by mail-lb0-f170.google.com with SMTP id w7so4810889lbi.15 for ; Sun, 06 Oct 2013 10:03:47 -0700 (PDT) In-Reply-To: <2013-10-06T13-22-35@devnull.Karl-Voit.at> 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: news1142@karl-voit.at, Org Mode --001a11c37abad6b46104e81584f9 Content-Type: text/plain; charset=ISO-8859-1 Hi Karl, hi all @maintainers: According to the below I tried to improve the Org manual with the attached patch, please review and apply. On Sun, Oct 6, 2013 at 1:30 PM, Karl Voit wrote: > The things I learned about referencing other tables I documented in [1]. > > Maybe you'll find it handy as a reference to referencing tables :-) > > 1. https://raw.github.com/novoid/org-mode-workshop/master/featureshow/org-mode-teaser.org > search for "referencing example with detailed explanation" Yes, with all the explanations of how the formulas work your github novoid/org-mode-workshop contains a very nice spreadsheet documentation, for more than just referencing remote tables. Can you please link the section here with mentioning that it contains explanations of how the formulas work?: http://orgmode.org/worg/org-tutorials/index.html Your new example in github novoid/org-mode-workshop with @2=remote(Income2012h, @3$$#) - motivated by my example in the current Org manual - that interprets text as a Calc algebraic expression, which is subject to reformatting reminded me of that just copying fields is better done with a Lisp formula "'(identity [...])", see attached patch for the Org manual. Michael --001a11c37abad6b46104e81584f9 Content-Type: text/plain; charset=US-ASCII; name="0001-Improve-manual-for-table-formulas.patch.txt" Content-Disposition: attachment; filename="0001-Improve-manual-for-table-formulas.patch.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_hmgir9qr0 RnJvbSBhM2VmYzNlZGQ5NGNjYzIxNTQ0NzkyZGRkZTRhNmM1NDI4NDEwMGNlIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNaWNoYWVsIEJyYW5kIDxtaWNoYWVsLmNoLmJyYW5kQGdtYWls LmNvbT4KRGF0ZTogU3VuLCA2IE9jdCAyMDEzIDE5OjAxOjE1ICswMjAwClN1YmplY3Q6IFtQQVRD SF0gSW1wcm92ZSBtYW51YWwgZm9yIHRhYmxlIGZvcm11bGFzCgoqIGRvYy9vcmcudGV4aSAoRmll bGQgY29vcmRpbmF0ZXMgaW4gZm9ybXVsYXMpOiBSZXBocmFzZSBhbmQgYWRkIGFuCmV4YW1wbGUg d2l0aCBhIExpc3AgZm9ybXVsYSB0byBjb3B5IGZyb20gcmVtb3RlIHRhYmxlLgotLS0KIGRvYy9v cmcudGV4aSB8IDMzICsrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0tLQogMSBmaWxlIGNo YW5nZWQsIDIwIGluc2VydGlvbnMoKyksIDEzIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2Rv Yy9vcmcudGV4aSBiL2RvYy9vcmcudGV4aQppbmRleCAwMjcxZDcwLi4wYTkwZDMzIDEwMDY0NAot LS0gYS9kb2Mvb3JnLnRleGkKKysrIGIvZG9jL29yZy50ZXhpCkBAIC0yNTUxLDIxICsyNTUxLDI4 IEBAIGZvciBDYWxjfS4KIEBjaW5kZXggcm93LCBvZiBmaWVsZCBjb29yZGluYXRlcwogQGNpbmRl eCBjb2x1bW4sIG9mIGZpZWxkIGNvb3JkaW5hdGVzCiAKLUZvciBDYWxjIGZvcm11bGFzIGFuZCBM aXNwIGZvcm11bGFzIEBjb2Rle0BAI30gYW5kIEBjb2RleyQjfSBjYW4gYmUgdXNlZCB0bwotZ2V0 IHRoZSByb3cgb3IgY29sdW1uIG51bWJlciBvZiB0aGUgZmllbGQgd2hlcmUgdGhlIGZvcm11bGEg cmVzdWx0IGdvZXMuCi1UaGUgdHJhZGl0aW9uYWwgTGlzcCBmb3JtdWxhIGVxdWl2YWxlbnRzIGFy ZSBAY29kZXtvcmctdGFibGUtY3VycmVudC1kbGluZX0KLWFuZCBAY29kZXtvcmctdGFibGUtY3Vy cmVudC1jb2x1bW59LiAgRXhhbXBsZXM6CitPbmUgb2YgdGhlIHZlcnkgZmlyc3QgYWN0aW9ucyBk dXJpbmcgZXZhbHVhdGlvbiBvZiBDYWxjIGZvcm11bGFzIGFuZCBMaXNwCitmb3JtdWxhcyBpcyB0 byBzdWJzdGl0dXRlIEBjb2Rle0BAI30gYW5kIEBjb2RleyQjfSBpbiB0aGUgZm9ybXVsYSB3aXRo IHRoZQorcm93IG9yIGNvbHVtbiBudW1iZXIgb2YgdGhlIGZpZWxkIHdoZXJlIHRoZSBjdXJyZW50 IHJlc3VsdCB3aWxsIGdvIHRvLiAgVGhlCit0cmFkaXRpb25hbCBMaXNwIGZvcm11bGEgZXF1aXZh bGVudHMgYXJlIEBjb2Rle29yZy10YWJsZS1jdXJyZW50LWRsaW5lfSBhbmQKK0Bjb2Rle29yZy10 YWJsZS1jdXJyZW50LWNvbHVtbn0uICBFeGFtcGxlczoKIAotQGV4YW1wbGUKLWlmKEBAIyAlIDIs ICQjLCBzdHJpbmcoIiIpKSAgIEBye2NvbHVtbiBudW1iZXIgb24gb2RkIGxpbmVzIG9ubHl9Ci0k MyA9IHJlbW90ZShGT08sIEBAQEAjJDIpICAgICAgQHJ7Y29weSBjb2x1bW4gMiBmcm9tIHRhYmxl IEZPTyBpbnRvfQotICAgICAgICAgICAgICAgICAgICAgICAgICAgICBAcntjb2x1bW4gMyBvZiB0 aGUgY3VycmVudCB0YWJsZX0KLUBlbmQgZXhhbXBsZQorQHRhYmxlIEBjb2RlCitAaXRlbSBpZihA QCMgJSAyLCAkIywgc3RyaW5nKCIiKSkKK0luc2VydCBjb2x1bW4gbnVtYmVyIG9uIG9kZCByb3dz LCBzZXQgZmllbGQgdG8gZW1wdHkgb24gZXZlbiByb3dzLgorQGl0ZW0gJDIgPSAnKGlkZW50aXR5 IHJlbW90ZShGT08sIEBAQEAjJDEpKQorQ29weSB0ZXh0IG9yIHZhbHVlcyBvZiBlYWNoIHJvdyBv ZiBjb2x1bW4gMSBvZiB0aGUgdGFibGUgbmFtZWQgQGNvZGV7Rk9PfQoraW50byBjb2x1bW4gMiBv ZiB0aGUgY3VycmVudCB0YWJsZS4KK0BpdGVtIEBAMyA9IDIgKiByZW1vdGUoRk9PLCBAQDEkJCMp CitJbnNlcnQgdGhlIGRvdWJsZWQgdmFsdWUgb2YgZWFjaCBjb2x1bW4gb2Ygcm93IDEgb2YgdGhl IHRhYmxlIG5hbWVkCitAY29kZXtGT099IGludG8gcm93IDMgb2YgdGhlIGN1cnJlbnQgdGFibGUu CitAZW5kIHRhYmxlCiAKLUBub2luZGVudCBGb3IgdGhlIHNlY29uZCBleGFtcGxlLCB0YWJsZSBG T08gbXVzdCBoYXZlIGF0IGxlYXN0IGFzIG1hbnkgcm93cwotYXMgdGhlIGN1cnJlbnQgdGFibGUu ICBOb3RlIHRoYXQgdGhpcyBpcyBpbmVmZmljaWVudEBmb290bm90ZXtUaGUgY29tcHV0YXRpb24g dGltZSBzY2FsZXMgYXMKLU8oTl4yKSBiZWNhdXNlIHRhYmxlIEZPTyBpcyBwYXJzZWQgZm9yIGVh Y2ggZmllbGQgdG8gYmUgY29waWVkLn0gZm9yIGxhcmdlCi1udW1iZXIgb2Ygcm93cy4KK0Bub2lu ZGVudCBGb3IgdGhlIHNlY29uZC90aGlyZCBleGFtcGxlLCB0aGUgdGFibGUgbmFtZWQgQGNvZGV7 Rk9PfSBtdXN0IGhhdmUKK2F0IGxlYXN0IGFzIG1hbnkgcm93cy9jb2x1bW5zIGFzIHRoZSBjdXJy ZW50IHRhYmxlLiAgTm90ZSB0aGF0IHRoaXMgaXMKK2luZWZmaWNpZW50QGZvb3Rub3Rle1RoZSBj b21wdXRhdGlvbiB0aW1lIHNjYWxlcyBhcyBPKE5eMikgYmVjYXVzZSB0aGUgdGFibGUKK25hbWVk IEBjb2Rle0ZPT30gaXMgcGFyc2VkIGZvciBlYWNoIGZpZWxkIHRvIGJlIHJlYWQufSBmb3IgbGFy Z2UgbnVtYmVyIG9mCityb3dzL2NvbHVtbnMuCiAKIEBzdWJzdWJoZWFkaW5nIE5hbWVkIHJlZmVy ZW5jZXMKIEBjaW5kZXggbmFtZWQgcmVmZXJlbmNlcwotLSAKMS43LjEyLjQgKEFwcGxlIEdpdC0z NykKCg== --001a11c37abad6b46104e81584f9--