Contact

Apache OpenOffice Calc ยท Collaboration and review ยท Intermediate

Review Comments and Recorded Changes in OpenOffice Calc

Add cell comments, record edits, accept one change and reject another in Apache OpenOffice Calc with a recoverable ODS workflow.

Documentation-qualified exercise; native application verification pending ยท Editorial standards

Review two proposed number changes separately while keeping an ordinary cell comment as context. AOO Calc’s recorded changes are useful for an offline review cycle, but they are not a complete audit log of every action or a real-time chat service.

Make a clean baseline

Use a new spreadsheet with Sheet1 containing the following cells.

Cell Content
A1 Item
B1 Quantity
A2 Clipboards
B2 12
A3 Marker packs
B3 8
A4 Total
B4 =SUM(B2:B3)

The initial total is 20. Save it as supply-review-baseline.ods with File โ†’ Save As in ODF spreadsheet format. Keep this baseline unchanged. Use File โ†’ Save As again to create supply-review-proposed.ods for the exercise. No file needs to be shared or sent to anyone.

Add an ordinary comment

  1. Select B2 and choose Insert โ†’ Comment.
  2. Enter Count includes the two spare clipboards in the cupboard.
  3. Click outside the comment to finish. Hover over B2 to read it again. A comment indicator should appear in the upper-right corner; its exact color can depend on settings.
  4. Confirm B2 is still 12 and B4 still 20. An annotation does not change the quantity.

Use the menu rather than relying on the right-click command if spelling suggestions change the context menu. The note belongs to B2, so do not attach it to the total merely because the total is what you first noticed. This is an ordinary cell comment, distinct from the automatically generated description of a recorded edit.

Record two deliberate edits

  1. Choose Edit โ†’ Changes โ†’ Record to enable recording before editing the values.
  2. Replace B2 with 15 and commit the edit. Replace B3 with 6 and commit it. The proposed total should now be 21.
  3. Look for the colored change borders. Hover over each changed cell and inspect the recorded information. The author and time come from your local user settings and clock; they are not guaranteed to identify another person securely.
  4. Save supply-review-proposed.ods. Save another copy as supply-review-decided.ods before accepting or rejecting anything. This preserves the undecided version independently.

The two intentional content changes are B2: 12 โ†’ 15 and B3: 8 โ†’ 6. The total recalculates because its precedents changed; you did not manually edit B4. Do not claim that cell formatting or every workbook action is recorded: the AOO guide specifically notes that some changes, including cell formatting, are not marked.

Accept one proposal and reject the other

  1. In the decided copy, choose Edit โ†’ Changes โ†’ Accept or Reject.
  2. On Filter, clear restrictive filters so the review is not silently limited to an author, date, cell range or comment. Return to List.
  3. Select the change for B2. Read its description and confirm it proposes 12 โ†’ 15 in the correct sheet and cell. Click Accept for that change alone.
  4. Select the change for B3. Confirm it proposes 8 โ†’ 6 and click Reject for that change alone. Avoid Accept All and Reject All in this exercise.
  5. Close the dialog and inspect the worksheet. B2 should be 15, B3 should be restored to 8, and B4 should be 23. The original clipboard comment should still explain the context at B2; accepting a value change does not make that explanation automatically accurate for a new count.

Do not decide by row position in the dialog alone: sorting, filtering, and nested changes can alter the list. The official guide describes separate accepted and rejected lists, so historical decisions may remain visible. An empty pending list is not evidence that review history has been erased.

Advanced case: inspect a focused review without losing the rest

Open Edit โ†’ Changes โ†’ Show and examine its range/date/author controls. A range filter covering B2 can help you examine a large sheet, but hides other changes from view. Clear that restriction afterward and review the full sheet. The Filter tab in the Accept or Reject dialog similarly controls the list, not the underlying quantities.

For this small exercise, compare all three stages: baseline total 20, proposed total 21, decided total 23. These totals distinguish acceptance of both changes (21), rejection of both (20), and the requested mixed decision (23). A matching total alone is insufficient; always check B2 and B3 separately as well.

Persist and recover safely

Save and close the decided ODS, then reopen it. Verify 15, 8 and 23, read B2’s comment, and reopen the review dialog to inspect the stored decision state. Check whether recording is still enabled before continuing unrelated edits. Turn Edit โ†’ Changes โ†’ Record off if you intend to finish the exercise without tracking further edits.

The AOO guide describes accepting/rejecting changes as non-reversible. Do not plan to use Undo to reverse review decisions, especially after reopening. For this exercise, reopen the preserved proposed copy and repeat the decisions into a newly named file if you choose incorrectly. Preserve the baseline too; a decided workbook is not a substitute for the original.

Boundaries and troubleshooting

These are the AOO 4.1 Edit โ†’ Changes commands, not a modern LibreOffice Track Changes menu path. Shared-file conflict handling, compare/merge and permission-controlled cloud collaboration are separate workflows. No Tools โ†’ Share Document step is required here. If no edits appear, check that recording was enabled before the two changes and that filters are cleared. If reviewer metadata is missing or unexpected, inspect local user settings rather than inventing an identity.

Keep the master in ODS and inspect any exported copy separately. A CSV cannot retain comments or review history. The values and arithmetic here were checked independently; the dialog behavior and save/reopen sequence are documented procedures for the reader to verify, not a reported native test.

Version scope and first-party references

Apache OpenOffice Calc 4.1 desktop, English menu names; documentation checked 2026-10-19. No native build or operating system was tested for this exercise. The expected numbers were calculated independently; appearance, UI interactions and persistence remain reader checks. No screenshot is presented as evidence of running this fixture.

Sources consulted on 2026-10-19: