Hello,
Ihor Radchenko <yanta...@posteo.net> writes:
> Roger Mason <rma...@mun.ca> writes:
>
>> It does not work when called thus:
>> | Element | oxide d.l. |
>> |---------+-------------|
>> | Fe | #ERROR |
>> #+tblfm: @2$2='(org-sbe "dl" (el '@2$1'))
>>
>> I have tried various ways of quoting the reference to the cell in column
>> 1 to no avail.
>
> M-x org-table-toggle-formula-debugger might be helpful.
Thanks for the hint. What I see is:
Substitution history of formula
Orig: '(org-sbe "dl" (el @2$1))
$xyz-> '(org-sbe "dl" (el @2$1))
@r$c-> '(org-sbe "dl" (el #("Fe" 0 2 (face org-table fontified t))))
$1-> '(org-sbe "dl" (el #("Fe" 0 2 (face org-table fontified t))))
Result: #ERROR
Format: NONE
Final: #ERROR
or
Substitution history of formula
Orig: '(org-sbe "dl" (el '@2$1'))
$xyz-> '(org-sbe "dl" (el '@2$1'))
@r$c-> '(org-sbe "dl" (el '#("Fe" 0 2 (face org-table fontified t))'))
$1-> '(org-sbe "dl" (el '#("Fe" 0 2 (face org-table fontified t))'))
Result: #ERROR
Format: NONE
Final: #ERROR
or
Substitution history of formula
Orig: '(org-sbe "dl" (el "@2$1"))
$xyz-> '(org-sbe "dl" (el "@2$1"))
@r$c-> '(org-sbe "dl" (el "#("Fe" 0 2 (face org-table fontified t))"))
$1-> '(org-sbe "dl" (el "#("Fe" 0 2 (face org-table fontified t))"))
Result: #ERROR
Format: NONE
Final: #ERROR
depending on how quoting of the cell reference is done.
Thanks,
Roger
