Apache OpenOffice Calc · References and calculation · Intermediate
Link spreadsheet summaries into Writer
Insert a linked Calc OLE object into Writer, distinguish it from an embedded copy, and verify an edited source total.
Documentation-qualified exercise; native application verification pending · Editorial standards
Insert a Calc file into Writer as a linked OLE object when the report should remain connected to the spreadsheet. An embedded object is a separate copy; a plain pasted picture is only a visual snapshot.
Prepare the report source
Use Apache OpenOffice 4.1 desktop Calc and Writer with English menus. The following workflow is based on the official Calc guide and has not been run in native applications. Use local synthetic documents and keep both files in a stable disposable folder.
Create report-source.ods with a single summary sheet. Enter A1:C3:
| Item | Quantity | Rate |
|---|---|---|
| Workshop | 8 | 25 |
| Materials | 8 | 5 |
Enter =B2*C2 in D2, =B3*C3 in D3, and =SUM(D2:D3) in D5, with Total in C5. Expected line amounts are 200 and 40, total 240. Adjust column widths so the table and total fit together, then save and close Calc before embedding the link.
Create a Writer document with a short title and a paragraph introducing the cost summary. Save it as workshop-report.odt. The destination is a report document, not another Calc worksheet.
Create the linked object
- Place the Writer cursor where the spreadsheet summary should appear.
- Choose Insert > Object > OLE Object.
- Select Create from file.
- Select Link to file. This choice is what distinguishes the link from an independent embedded object.
- Click Search, choose report-source.ods, and open it. Complete the insertion dialog if required.
A section of the spreadsheet is displayed in the document. Check that the visible area includes the intended rows and total, rather than assuming the entire workbook is visible. Adjust the object’s displayed area and report layout as needed without treating a cropped view as deletion of source data.
The standard OpenOffice object route is sufficient here. The guide’s additional “Further objects” route is Windows-only; this tutorial does not require that route or infer it exists on Linux or macOS.
Prove it is a live link
Save and close the Writer report. Open report-source.ods in Calc, change B2 and B3 from 8 to 10, and save. Expected line amounts are now 250 and 50, total 300. Close the source, reopen the Writer report, and allow updating only for this known local link under your normal policy.
Verify the report displays the new quantities and 300 total. If it still shows 240, investigate the source path and link/update state. Do not type 300 into a Writer caption to disguise a stale object. Check whether Link to file was selected originally; an embedded copy is expected to remain independent.
The official guide says a linked OLE spreadsheet can also be edited from its containing document by double-clicking it, with changes reflected in the linked source. That is powerful but consequential: changing a number inside Writer is not necessarily an isolated report edit.
Avoid conflicting open copies
The guide notes that only one editable copy of the spreadsheet can be open at a time. If its linked object is open in Writer and you then open the same file in Calc, the Calc copy may be read-only. Close the report or finish object editing before attempting a source edit elsewhere. Do not force a second writable copy or interpret read-only status as data loss.
For a final controlled change, close Writer, restore both source quantities to 8 in Calc, save and close the Calc source, and reopen/update the report. It should return to 240. Save, close and reopen both documents to verify their relationship and paths remain intelligible.
Share intentionally and recover safely
Keep backup copies before altering real reports. Moving or renaming the source can break the link even while a cached preview remains visible. Restore the source path or recreate the object from the verified file; do not silently link a different workbook with a similar name.
A linked report depends on the source. If recipients need a fixed record rather than an editable model, create a deliberately static output and label its reporting date. Do not assume an ODT containing a link is self-contained or that a PDF preserves a live link.
Official reference
Apache OpenOffice 4.1 Calc Guide, Chapter 10, Embedding Spreadsheets, OLE, and Linked OLE Object. Recovered guide retrieved 19 October 2026; native layout, link refresh and saved-state checks remain unverified.