Re: [SLUG] OpenOffice Calc function

From: blee2@tampabay.rr.com
Date: Fri Dec 12 2008 - 16:28:03 EST


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 " ` "....
-----------------------------------------------------------------------
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:01:50 EDT