To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=101041
Issue #|101041
Summary|DDE function should always use Calc A1 address syntax
Component|Spreadsheet
Version|DEV300m45
Platform|All
URL|https://bugzilla.novell.com/show_bug.cgi?id=442143
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|kohei
Reported by|kohei
------- Additional comments from ko...@openoffice.org Mon Apr 13 13:58:11 +0000
2009 -------
When pasting a cell from another document as a link, Calc pastes it using a DDE
function:
=DDE("soffice","/home/kyoshida/Documents/test1.ods","Sheet1.A1")
Notice the 3rd argument. The syntax of the referenced cell is always Calc A1
even when the formula syntax is not Calc A1. The problem is, when the formula
syntax is not Calc A1, the DDE function returns #N/A because the interpretation
of the referenced address fails.
I think the best course of action is to always interpret the referenced address
in DDE as Calc A1 since it is given in a string literal.
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
