To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=96863
User cloph changed the following:
What |Old value |New value
================================================================================
CC|'regina' |'cloph,regina'
--------------------------------------------------------------------------------
Keywords|oooqa |oooqa, regression
--------------------------------------------------------------------------------
OS/Version|Windows XP |All
--------------------------------------------------------------------------------
Platform|PC |All
--------------------------------------------------------------------------------
Summary|ADDRESS and INDIRECT funct|ADDRESS adds quote around
|ions not adaptable |sheet, not only filename,
| |breaks reference to other
| |file (ADDRESS and INDIRECT
| | functions not adaptable)
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Mon Sep 21 10:34:50 +0000
2009 -------
confirmed, flagging as regression, not only windows affected, updated summary.
As described: when referencing another document in the table-parameter, the
address function in OOo 3.x adds the quotes at inappropriate places.
It includes the sheetname in the quoted part, which is not what other formulas
expect.
In addition, this is different from previous versions that did not add quotes at
all (the user had to specify them).
regression as this breaks documents that try to use indirect in combination with
address function to reference data from other files.
Even if it would add the quotes at the correct places, it would break formulas
that use CONCATENATE or similar that provide the quotes as it was necessary in
previous versions of OOo. as a name like
''file:///tmp/bug.ods''#Table1.A1
(i.e. double-quoted filename) will not be accepted by INDIRECT either.
---------------------------------------------------------------------
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]
