Hi,
The container DDELinks of a spreadsheet contains the DDE links used in the
spreadsheet.
Is it possible to find where (in which cells) a DDE link is used ?
An idea is to scan cells containing formulas.
But a call to DDE() function can appear in a complex form in a cell formula, so
you need to parse the formula.
I tried to use the service c.s.s.sheet.FormulaParser like this:
' *** BASIC ***
Dim fp As Object, ca As Object, ftseq As Variant
Dim f As Object, c As Object
f = ThisComponent.Sheets.getByName("Feuille1")
c = f.getCellRangeByName("D7")
fp = ThisComponent.createInstance("com.sun.star.sheet.FormulaParser")
fp.FormulaConvention = com.sun.star.sheet.AddressConvention.XL_OOX
fp.ReferencePosition = c.CellAddress
ftseq = fp.parseFormula(c.Formula)
ftseq is a nice array of FormulaToken, but how can I interpret a formula token
OpCode ?
In the fp object, property OpCodeMap is an empty array, and the documented
property ExternalLinks does not exist.
Several IDL pages are unpublished, is this service usable ?
Regards
Bernard
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
