DDE Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Registered and implemented in Apache OpenOffice 4.1.16. No retirement is established.
• Scope: Desktop Calc with English semicolon-separated formulas. The official guide restricts cross-platform DDE links.
• Checked: October 14, 2026. Function-specific source and documentation were inspected. No DDE connection was activated. No native example is claimed.

The three required arguments identify an application, a topic within that application and the requested item. In the OpenOffice-to-OpenOffice example described by the official guide, these correspond to the Soffice server, a complete file path and a sheet range. DDE is an external-data operation, not a way to evaluate arbitrary formula text inside the current workbook.

DDE(Application; Topic; Item[; Mode])

Square brackets mark optional arguments; do not type them. Application is the server application name. Topic is the server-specific topic, such as a complete file name. Item identifies the requested data, such as a range. All three are strings. Mode is optional and controls conversion of returned data into numbers or text. The inspected callback selects its default when omitted; the numeric mode constants were not established from the retained evidence, so this guide does not assign meanings to guessed mode numbers. Versioned argument description.

These examples explain the inspected code and documented contract. They were not executed. The DDE targets are placeholders and no returned data is invented.

Before setting up a link, document which application owns the data, which file is authoritative and which exact item or range is needed. Keep those three pieces in separate cells if that makes the configuration easier to inspect. A descriptive label beside the formula should identify the source and the purpose of the connection.

The patterns above are for reading existing workbook formulas and planning a trusted connection. They were not executed. Do not paste an unfamiliar application, topic or item from an untrusted workbook and assume it is harmless simply because it appears in a cell. Confirm the source before allowing external-link updates.

The official guide describes reloading the spreadsheet or using Edit > Links to view updated links. That documentation does not establish refresh timing, server availability or successful linking on every operating system.

The 4.1.16 callback searches for an existing link using all four pieces: application, topic, item and conversion mode. If it does not find one, it creates a link and calls its update method. It then listens for changes. This explains why DDE should not be treated like a self-contained arithmetic formula.

When the link supplies a matrix, Calc copies that matrix into the formula result. A range item is therefore different from assuming a single scalar cell. The callback also marks a normally recalculated formula for recalculation on loading, so a saved workbook can need link reconstruction when reopened.

There are two distinct unavailable-result paths in the inspected code: no document link manager produces a no-value error, while an existing link without a result produces an NA error. Those are source branches, not errors observed in an executed test here. They do not diagnose which external application or file caused a real-world failure. Inspected callback.

The official AOO4 guide explicitly says cross-platform links are unsupported. Its example includes a Windows OpenOffice installation and a document created on Linux. Treat this as the guide’s stated compatibility restriction, not evidence that every same-platform server or document will work.

The callback accepts three or four arguments. It floors a supplied mode before converting it to the internal small integer type and resets values above its text-mode constant to the default. Do not use that implementation detail as a substitute for documented mode values.

A saved numeric result is not proof that the linked source is current. Record the source and refresh context when relying on external data. No connection was activated and no output, refresh guarantee or current platform success is claimed in this guide.

HYPERLINK, INDIRECT, INDEX.

• Complete 4.1.16 function implementation
• English native-name registration
• Function description and arguments
• Official AOO4 spreadsheet-function guide

The review covers the documented syntax and exact retained 4.1.16 implementation. External-link activation and platform-specific connectivity were not tested.