Contact

OpenOffice Calc Β· Styles and templates Β· Beginner

Create and Reuse a Workbook Template in OpenOffice Calc

Build a clean Apache OpenOffice Calc template, create independent reports, revise the master and restore a changed default.

Editorial standards

A reusable template should contain the report structure and formulas, while each report gets its own inputs and filename. This exercise makes two reports from one clean master, then changes the master without pretending it rewrites the contents of old reports.

Scope and clean master

Apache OpenOffice Calc 4.1 desktop, English Windows/Linux menus; documentation checked against the official 4.1 Calc Guide and versioned 4.1.6 Help on 19 October 2026. No native application run or save/reopen test was performed for this exercise.

Use the classic File β†’ Templates commands documented for Apache OpenOffice. Do not use a template manager workflow copied from another spreadsheet product. The official template chapter, pages 126–134, covers creation, editing, defaults, import and export.

Start a blank spreadsheet and enter the following:

Cell Master content
A1 Supply estimate
A2 Template revision
B2 1
A4 Report label
B4 Leave empty
A6 Item
B6 Units input
C6 Unit price
D6 Cost
A7 Notebook
B7 0
C7 4
D7 =B7*C7
A8 Folder
B8 0
C8 3
D8 =B8*C8
C10 Total
D10 =SUM(D7:D8)

β€œLeave empty” is an instruction; do not type those words into B4. Make A1 and A6:D6 bold. Format C7:D8 and D10 as numbers with two decimal places. You may shade B4 and B7:B8 lightly to identify inputs, but retain the written labels so color is not the only cue.

The clean master calculates 0, 0 and 0. Save a separate working backup as supply-master-before.ods. Before creating the template, inspect all sheets for trial reports, personal details, comments and unused sensitive data. Hiding a sheet is not cleanup.

Register the template and export an OTS copy

  1. Choose File β†’ Templates β†’ Save.
  2. Type Supply estimate practice in New template.
  3. Choose an appropriate category, such as My Templates, and confirm.
  4. Choose File β†’ Templates β†’ Organize. Expand that category and select Supply estimate practice.
  5. Use Commands β†’ Export Template and save a copy in a known practice folder, using the native OpenDocument Spreadsheet Template (.ots) format.

The registered template is the master used by the template chooser; the exported OTS is a separate portable backup. Record both its name/category and the exported file’s location. Do not rename an .ods file to .ots as a substitute for saving a template.

The Creating a Template guide supports registration. If you later import the exported OTS into another profile, File β†’ Templates β†’ Organize β†’ Commands β†’ Import Template adds it to that profile’s category. Importing another copy does not magically synchronize two masters.

Create two independent reports

  1. Choose File β†’ New β†’ Templates and Documents.
  2. Select Templates, open the category holding Supply estimate practice, select it, and click Open.
  3. Verify the new document has blank B4, zero quantities and revision 1 before entering data.
  4. Put North in B4, 3 in B7 and 2 in B8. Expect D7=12, D8=6 and D10=18.
  5. Save this document as supply-north.ods using OpenDocument Spreadsheet.
  6. Create another new document through the same Templates and Documents route. Do not make it by overwriting the North report.
  7. Put South in B4, 1 in B7 and 5 in B8. Expect D7=4, D8=15 and D10=19.
  8. Save it as supply-south.ods.

Reopen North and South and inspect their filenames, report labels, quantities and totals. North must still be 18 while South is 19. A new third document from the template must still show blank B4 and zeros, proving the master was not filled with the last report’s data. Close this third document without saving.

If the master itself opens for editing instead of an untitled report, stop and check how it was opened. Use the documented New β†’ Templates and Documents route for report creation and the Organize β†’ Edit route below for deliberate master edits.

Revise the master deliberately

Make a backup export before changing the registered master. Then:

  1. Open File β†’ Templates β†’ Organize, expand its category and select Supply estimate practice.
  2. Choose Commands β†’ Edit.
  3. Change B2 to 2 and C8, Folder unit price, from 3 to 4.
  4. Confirm B4 is still empty and B7:B8 are still zero. D7, D8 and D10 should still be zero.
  5. Choose File β†’ Save, then close the template.
  6. Create a fresh report from the updated template and use the South quantities, 1 and 5. Expect revision 2, costs 4 and 20, and total 24.

The Editing a Template guide makes an important distinction: a template can offer style updates to existing documents; it cannot reapply their content. The old South report should retain revision 1, Folder price 3 and total 19. Updating a style is not a mechanism for pushing new prices or formulas into existing reports.

If a styles-update prompt appears for an existing report, decide whether its formatting should change. Neither Update Styles nor Keep Old Styles is approval to rewrite its business data. A content migration needs its own explicit comparison. The official update warning also says that choosing Keep Old Styles stops later template-style update prompts for that document; it is not merely a one-opening postponement.

Import the exported master and prove which revision it contains

Import and export move a template file between a normal folder and the template categories; they are not synchronization. Use this optional round trip after the revision-2 edit above, without replacing the registered master.

  1. Export the revised Supply estimate practice template again through File β†’ Templates β†’ Organize β†’ Commands β†’ Export Template. Give this separate copy a distinctive filename such as Supply estimate roundtrip revision 2.ots in your practice folder. Keep the original revision-1 backup.
  2. In Template Management, select the destination category first, then choose Commands β†’ Import Template. Select the revision-2 OTS file and click Open.
  3. Inspect the new entry in that category. The official import procedure permits renaming the imported entry and pressing Enter. Give it a distinct name such as Supply estimate imported revision 2. If an existing-name or replacement prompt appears unexpectedly, cancel rather than overwrite the master and investigate the selected category and filename.
  4. Close the manager. Create a new document through File β†’ New β†’ Templates and Documents, selecting the imported entry, not the original master.
  5. Before entering any report data, verify B2=2, C8=4, B4 empty, B7:B8 zero and D10=0. Enter the South quantities 1 and 5: D10 must become 24. Save this separate report as supply-import-check.ods.
  6. Reopen the original supply-south.ods from the earlier exercise. It should still contain revision 1, Folder price 3 and total 19. Compare filenames as well as cell values so you do not mistake one report for the other.

If the imported template produces revision 1 or a 19 total with those quantities, check which OTS you exported and imported. Renaming an entry does not change its formulas, prices or revision cell. If the imported template begins with South’s quantities instead of zeros, it was exported from a filled master or report: recover the clean master before creating more reports.

The imported entry and the original registered template are separate copies. Later edits to one must not be assumed to update the other. Likewise, an OTS kept in a backup folder does not become a registered choice merely because its filename ends in .ots; the import step places it in a template category.

Organize template categories without moving report files

Template Management folders are the categories used by the template chooser. They are not your ordinary folder of saved North and South reports. Use the imported revision-2 practice copy from the preceding section, not your only master or an existing custom default.

  1. Open File β†’ Templates β†’ Organize. Click any folder, choose Commands β†’ New, replace the new Untitled name with Supply practice staging, and press Enter.
  2. Repeat to create Supply practice reports. Choose unused names so that neither is confused with an existing team category. This is the documented naming step when creating a folder, not a claim about renaming arbitrary existing folders.
  3. Select Supply practice staging and import the exported revision-2 OTS through Commands β†’ Import Template. When the imported entry appears, type a distinct name such as Supply estimate organization check and press Enter. This documented rename changes the imported template’s chooser label, not B2 or the saved report filenames.
  4. Expand Supply practice staging. Drag Supply estimate organization check, the template entry itself, onto Supply practice reports. Expand both categories and inspect where that exact entry appears.
  5. Close the manager and create a fresh document through File β†’ New β†’ Templates and Documents, selecting the entry under Supply practice reports. Check revision 2, blank B4, zero quantities, Folder price 4 and zero total before adding any inputs. Using the South quantities 1 and 5 should still give 24.

The official move procedure warns that lacking permission to delete from the source category makes a drag copy rather than move. If the entry remains in both categories, do not force deletion or assume synchronization. Check the source/destination labels and treat them as separate entries until verified. No permission change is needed for this exercise.

If you drop into the wrong category, locate the entry before dragging again. The exported OTS remains the fallback for re-importing a known revision into a deliberately selected category. Do not delete an old category as a shortcut for renaming it: it may contain other templates. Existing-folder rename behavior is not established by the sources used here.

This organization check is documentation-qualified, not a native move or persistence test. The original master and saved North/South reports are left unchanged. See Creating a Template Folder and Importing a Template, full AOO 4.1 guide pages checked on 2026-10-23.

Template files versus extension packages

An OTS is a spreadsheet template. An OXT is an extension package that may contain collections of templates, graphics, macros or other add-ins; it is not another filename for the exported master. The AOO 4.1 Extension Manager guide, checked in full on 2026-10-23, describes Tools β†’ Extension Manager β†’ Add as the installation route. It says a package can request license acceptance and installed templates become available through File β†’ New β†’ Templates and Documents.

That is a description of the documented mechanism, not an installation step in this exercise. No extension, license acceptance, package safety review or current package compatibility was tested. The built-in folder/import workflow above needs no extension. Do not install a collection merely to organize an OTS, and do not assume a package contains only harmless formatting because it is advertised as a template pack.

The starter downloads remain data-only CSV exercises. A downloadable clean native OTS master and populated ODS counterpart, with actual OpenOffice reset and save/reopen checks, are not supplied by this page. Their validation remains outstanding; the instructions above are not evidence that such files have been created or accepted natively.

Optional default and its reversal

This exercise does not require changing the default. If you choose to try it in a disposable profile, first record whether a custom spreadsheet default is already in use.

In Template Management, select the practice template and choose Commands β†’ Set As Default Template. File β†’ New β†’ Spreadsheet should then start with its layout. To return to the application’s built-in default, select a folder in Template Management and choose Commands β†’ Reset Default Template β†’ Spreadsheet.

If there was a previous custom default, select that original template and set it as default again instead; resetting to the built-in default would not restore the user’s former customization. Check a new blank spreadsheet after the reversal.

Recovery and validation

If a report accidentally changed the master, use the exported before OTS or supply-master-before.ods to reconstruct the clean master, then create a new report and check the zero-input state. Preserve the already saved reports separately. Export a new OTS backup after an intentional master revision and give it a revision-aware filename so it cannot be mistaken for the old backup.

For accidental formula edits, use the separate protect formulas while allowing inputs workflow after validating the template. Protection is optional here and does not encrypt report data.

These calculations and separation checks are independent expected outcomes. Registration, OTS export, report creation, master editing and save/reopen have not been executed natively for this new exercise; no screenshot is offered as proof.

Additional first-party lifecycle references

The following full Apache OpenOffice 4.1 Calc Guide pages were checked on 2026-10-21. The import round trip is a documentation-qualified exercise, not a native test result.