To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92797
------- Additional comments from [EMAIL PROTECTED] Thu Aug 14 12:09:04 +0000
2008 -------
DR->ER: Also needed: DDE links. They are stored as follows:
in Excel UI:
=server|'topic'!'item'
e.g.
=excel|'X:\PATH\[FILE.XLSX]Sheet1'!'R1C1'
to refer to cell Sheet1.A1 in the file X:\PATH\FILE.XLSX
or:
=soffice|'file:///X:/PATH/FILE.ODS'!'Sheet1.A1'
to refer to cell Sheet1.A1 in the file X:\PATH\FILE.ODS
in MSOOXML format, these formulas are stored as following:
=[link-index]'item'
e.g.:
=[1]'R1C1'
=[2]'Sheet1.A1'
where [1] is an external link with DDE service name "excel" and topic
"X:\PATH\[FILE.XLSX]Sheet1", and [2] contains service "soffice" and topic
"file:///X:/PATH/FILE.ODS".
The parser has to generate the formula =DDE("service";"topic";"item" from that
data.
Furthermore, MSOOXML allows to create OLE links to external cells, e.g. in
Excel UI:
=progid|target!item
e.g.
=Excel.Sheet.12|'X:/PATH/FILE.XLSX'!'!Sheet1!R1C1'
but that is not supported by Calc.
I suggest to handle external links and DDE with the same API, but this requires
something different than a simple sequence<string>, e.g. a
sequence<com.sun.star.sheet.ExternalLinkInfo> containing a link type
(external/DDE) and the related string data.
---------------------------------------------------------------------
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]
