Ch 7: Share and Review a Spreadsheet
Sharing a Spreadsheet
Sharing: one file that more than one user can access and edit at the same time (collaboration). Path: Tools > Share Spreadsheet. The word (shared) appears in the title bar.
In shared mode some features are unavailable — Undo, Redo, Repeat, Paste, Links to External files, ImageMap, Object.
Recording Changes
Recording changes turns OFF the shared feature — first disable sharing, then Edit > Track Changes > Record. A changed cell gets a red border.
Comments & Reviewing
Add comments via Edit > Track Changes > Comment, or Insert > Comment. Accept/reject via Edit > Track Changes > Manage.
Merge vs Compare: Merge combines two versions into one file; Compare shows the differences between two versions.
Summary
- Sharing lets several users edit one file; some tools are disabled while shared.
- Track Changes is under the Edit menu; changed cells show a red border.
- Merge combines versions; Compare shows their differences.
Spreadsheet Share करना
Sharing: एक file जिसे कई users एक साथ access और edit कर सकते हैं (collaboration)। Path: Tools > Share Spreadsheet। Title bar में (shared) दिखता है।
Shared mode में कुछ features unavailable होते हैं — Undo, Redo, Repeat, Paste, Links to External files, ImageMap, Object।
Changes Record करना
Recording changes shared feature को OFF कर देता है — पहले sharing बंद करें, फिर Edit > Track Changes > Record। बदला cell red border पाता है।
Comments & Reviewing
Comments जोड़ें Edit > Track Changes > Comment, या Insert > Comment से। Accept/reject करें Edit > Track Changes > Manage से।
Merge vs Compare: Merge दो versions को एक file में जोड़ता है; Compare दो versions के अंतर दिखाता है।
सारांश
- Sharing कई users को एक file edit करने देता है; कुछ tools disabled होते हैं।
- Track Changes Edit menu में है; बदले cells red border दिखाते हैं।
- Merge versions जोड़ता है; Compare अंतर दिखाता है।
Frequently Asked Questions
Which menu contains Track Changes in Calc?
Track Changes is found under the Edit menu.
What is the difference between merging and comparing spreadsheets?
Merging combines two versions into one file, while comparing shows the differences between two versions.