emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[O] Spreadsheet - issue with remote reference to named column


From: Daniel Gerber
Subject: [O] Spreadsheet - issue with remote reference to named column
Date: Thu, 10 Sep 2015 15:06:50 +0200
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.2.0

Hi,

The docs say that the REF argument to remote can be "@3$3 or $somename, valid in the referenced table". So, adapting the tutorial, the last column here should get the same values as the second one, right?


| currency | rate (@r$c ref) | rate (named ref) |
|----------+-----------------+------------------|
| eur      |               1 | nil              |
| usd      |            0.77 | nil              |
| sek      |            0.12 | nil              |
| sek      |            0.12 | nil              |
| sek      |            0.12 | nil              |
| nok      |            0.14 | nil              |
|          |             nil |                  |
#+TBLFM: $2='(org-lookup-first $1 '(remote(rates,@2$2..@>$2)) '(remote(rates,@2$3..@>$3)))::$3='(org-lookup-first $1 '(remote(rates,$abbr)) '(remote(rates,$euros)))


 #+TBLNAME: rates
| ! | abbr | euros |
|---+------+-------|
|   | eur  |     1 |
|   | nok  |  0.14 |
|   | sek  |  0.12 |
|   | usd  |  0.77 |



Thanks for your answers!


Daniel



reply via email to

[Prev in Thread] Current Thread [Next in Thread]