Macros/Writer/002/en

Description
The menu allows you to recognize the links present in a document, including:
 * File source (URL)
 * Element (range)
 * Type (soffice)
 * Refresh (automatic/manual)

On the other hand, neither this approach, nor the navigator allows you to know which are the tables concerned (name or position in the document).

The purpose of the below macro is to locate tables created by DDE links.

The macro inserts in the first cell of a table a comment consisting of:
 * source (URL of a Calc spreadsheet for example),
 * the range used in the source.

(More on comment manipulation with macro in Macros/Writer/001.)

Note that the collection TextFieldMasters would only retrieve the information displayed by the  menu and TextTables does not give us any more information.

The DDE connection of table data is contained in an element  See the standard OASIS Open Document Format for Office Applications. The use of this element differs between spreadsheet and word processing. For text documents, the element is contained directly inside the element