- Description
- describes all items of a DDE connection used in formulas.
A DDE connection consists of the DDE service name, the DDE topic and a
list of DDE items which may contain results cached from the last update.
The formula that would need this information for example would contain
=[1]!'R1C1' or =[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
service name is stored in Service, the topic
is stored in Topic. Note that if the DDE
item contains single quotes they are escaped by doubling them, as usual.
For example =[2]!'''Sheet name''.A1' in a "soffice" service.
|