On Fri, 12 Dec 2008, Eben King wrote:
> On Fri, 12 Dec 2008, blee2@tampabay.rr.com wrote:
>
>> Thus draeath hast written on Fri, Dec 12, 2008 at 03:21:43PM -0500, and,
>> according to prophecy, it shall come to pass that:
>>>> =CELL("contents"; "ADDRESS(2;23;2)")
>>
>>>> That still gets me "#REF!". I think what it's doing is interpreting
>>>> ADDRESS(2;23;2) as a string, not evaluating it and taking the return
>>>> value.
>>
>>> I wonder if there is anything that forces evalualtion? I tried a quick
>>> test with eval() but it doesn't do what I would expect, and I fail to
>>> find a function reference in help.
>>
>> Try with single quotes " ' " or graves " ` "....
>
> There's no EVAL function, but both
> =CELL("contents"; 'address(2;23;2)')
> and
> =CELL("contents"; `ADDRESS(2;23;2)`)
> give #NAME? ("unknown function"). Sigh. There HAS to be a way...
Got it (yay comp.os.linux.misc):
=CELL("contents"; indirect(ADDRESS(2;23;2)))
--
-eben QebWenE01R@vTerYizUonI.nOetP royalty.mine.nu:81
> A: It's annoying as hell
> Q: Why do most people hate top-posting? -- Lots42 The Library Avenger
http://www.fscked.co.uk/writing/top-posting-cuss.html
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 18:04:15 EDT