To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105182
User jes changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Sep 18 21:09:39 +0000
2009 -------
Oops! Ok, I'm an idiot. I just realized: If these are _operators_ then "A1~B1"
is an _expression_ and INDIRECT doesn't accept expressions.
So, instead of
=SUM(INDIRECT("A1~B1")), I need to write
=SUM(INDIRECT("A1")~INDIRECT("B1")), which does work.
I don't know what Excel does with these, and the ODFF draft says that INDIRECT
only accepts text references, but if ":" and "~" are operators, then "A1:B1"
looks as much like an expression as "A1~B1". It seems like a natural extension
or enhancement for INDIRECT to be able to accept reference expressions, in
addition to 'plain' references, since it is possible to return a reference for
both cases.
Anyway, never mind; closing as INVALID.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
