Link a comparison summary to a source sheet in Calc

Practise cell references with fictional measurements and keep original records separate.

Create two simple practice sheets

Use a new workbook that contains no real personal or financial data. Rename one sheet Source and another Summary. On Source, enter a fictional room label in one cell and a practice dimension in a neighbouring cell, with the measurement unit written explicitly. Label the exercise as invented arithmetic rather than a property listing. The purpose is to understand how a summary can display a value recorded elsewhere. A working formula does not verify a measurement, establish a market value or turn a comparison workbook into professional advice about buying or building.

Insert a reference using the interface

Select the summary cell where the value should appear, type an equals sign, switch to the source sheet and select the source cell. Confirm the entry and inspect the resulting reference in the formula bar. LibreOffice's official guide explains that cells can refer to another sheet and, under the applicable saved-file conditions, another document. Begin with sheets in the same workbook to keep the exercise understandable. Change the fictional source value and observe whether the summary updates. If the wrong cell changes, undo the step and identify the selected reference before continuing.

Keep units and meaning beside the value

A linked number is easy to misunderstand when separated from its label. Put the room reference, unit, evidence date and qualification beside the summary value. If an actual dimension was only roughly observed, a formula must not silently present it as surveyed. Keep unknown values blank or use an explicit unresolved label rather than inserting zero. A zero can be mistaken for a measured quantity and may distort later calculations. Do not use the practice workbook to invent building quantities, material orders or structural dimensions; those require the appropriate project information and qualified assessment.

Check changes before relying on the summary

Make a small test log containing the source cell, old practice value, new practice value and observed summary result. Check one reference independently with another person. Conditional formatting can draw attention to a value under a chosen rule, as LibreOffice documents, but a colour means only that the rule was met. It does not show that a property is safe, affordable or approved. Keep copies of original documents outside the calculated summary and link them through a simple index. The useful outcome is a traceable practice workbook whose labels explain its limits, not an impressive dashboard that conceals uncertainty or replaces original evidence.

Finally, close and reopen the practice workbook, check the linked value again and write the result in your test log. This small exercise catches a copied value mistaken for a live reference. Keep the file labelled practice so another participant does not mistake it for evidence about a real property.

Sources & further reading

Use these references to check the underlying guidance and any current local requirements. Practical worksheets and illustrative examples in this guide are original educational material.

  1. LibreOffice: Referencing a cell in another sheet
  2. LibreOffice: Applying conditional formatting

This guide is general information. Source notes are not a claim of independent professional review.