Chapter 7 Notes
Unit 2 Electronic Spreadsheet · Chapter 7
Share and Review a Spreadsheet
Master collaborative spreadsheet workflows in LibreOffice Calc: Shared Mode Concurrency, Resolving Cell Conflicts, Recording & Commenting Changes, and Merging vs Comparing Documents.
Chapter 7 Theory
1. Shared Spreadsheet Concurrency
Enabling Shared Mode:
Menu: Tools > Share Spreadsheet. Check 'Share this spreadsheet with other users'. Title bar displays (shared).
Disabled Features in Shared Mode:
- Inserting images, charts, drawing shapes
- Creating or editing macros
- Deleting or renaming sheets
- Conditional formatting adjustments
2. Recording Changes & Adding Comments
Menu: Edit > Track Changes > Record. Edited cells receive a red boundary. Hovering displays the tooltip. Add comments via Edit > Track Changes > Comment.
3. Merging vs Comparing Spreadsheets
Merge Document
Path: Edit > Track Changes > Merge Document. Merges tracked changes from distributed copies back into the original master sheet.
Compare Document
Path: Edit > Track Changes > Compare Document. Compares open workbook with an untracked copy, opening the Manage Changes review dialog.
Chapter 7 Practice
Solved MCQs: Share & Review Spreadsheets
1
When a spreadsheet document is set to 'Shared' mode (Tools > Share Spreadsheet), which of the following operations is disabled?
2
How are cells visually marked in LibreOffice Calc when Track Changes is enabled (Edit > Track Changes > Record)?
3
What happens when two users edit the exact same cell simultaneously in a Shared Spreadsheet?
4
Which command is used to merge tracked edits from a separate copy of a spreadsheet back into the original master document?
Frequently Asked Board Questions