The first three chapters introduce you to Apache OpenOffice Basic: This guide divides information about Apache OpenOffice administration into several chapters.

Since other pages of the Developer's Guide on Basic are technical details for experienced Basic programmers, you should then read this Basic Programming Guide. Before attempting to write macros you should read First Steps with Apache OpenOffice Basic and the pages on Apache OpenOffice Basic IDE. It is described in the chapter Apache OpenOffice Basic of the Developer's Guide. Click OK.Apache OpenOffice offers a complete user interface for developing programs in Basic.

When the Paste Special dialog opens, select the Link option on the bottom left of the dialog.

Go to the place in the spreadsheet where you want to the link to be.

In Calc, select the cells that you want to make the DDE link to.

The process is a little different, but the result is the same.

You can create DDE links either within Calc cells in a Calc sheet, or in Calc cells in another OOo doc such as in Writer.Ĭreating a DDE link in Calc is similar to creating a cell reference.

With DDE, objects are linked through file reference, but not embedded. The DDE link ensures that, as the source spreadsheet is updated so is the report, thus reducing the scope for error and reducing the work involved in keeping the Writer document up to date.ĭDE is a predecessor of OLE. It would be used, for example, in a report written in Writer containing time‑varying data, such as sales results sourced from a Calc spreadsheet. DDE is an acronym for Dynamic Data Exchange, a mechanism whereby selected data in document A can be pasted into document B as a linked, ‘live’ copy of the original.

Openoffice calc tutorials