Spreadsheet Sharing Basics

A spreadsheet accessible by multiple users simultaneously, allowing concurrent edits, and avoiding multiple copies.

The process of making a spreadsheet accessible to multiple users for simultaneous edits.

Some features might be disabled for a spreadsheet shared with other users (e.g., undo/redo, external links).

After a user saves changes to a shared spreadsheet, if no conflicts occurred, it gets automatically updated with changes from other users in the background

Opening a shared spreadsheet may show that some features are unavailable. It displays a warning first before allowing access for editing

Occur when multiple users try to simultaneously change the same portion of the spreadsheet.

If conflicts happen when saving a shared spreadsheet, a dialog window appears to help resolve conflicting changes made by different users.

An intermediate dialog box that appears after sharing the spreadsheet asks for confirmation to continue with saving.

Adding notes to a spreadsheet cell.

Showing the notes added to a spreadsheet cell.

Modifying the notes added to a spreadsheet cell.

Removing the notes added to a spreadsheet cell.

Changing the appearance of the comment box (font, colour, etc.).

Inspecting and accepting or rejecting edits made by others to a spreadsheet.

Agreeing with the revisions made.

Disagreeing with the changes.

Steps to disable the shared mode of a spreadsheet, preventing other users from making changes simultaneously.

Method in LibreOffice Calc to track modifications made to cells, highlighting them and displaying the author/reviewer of the change.

A notification that the spreadsheet is locked to prevent saving while a conflict resolution is occurring.

Activating the function to record changes made within a spreadsheet, highlighting modified cells.

Process to insert and view comments in a spreadsheet cell, whether by the user or another person.

A feature of spreadsheets that shows changes made by other users and allows for comments.

When two users make changes to the same cell in a shared spreadsheet and the resolution of these discrepancies.

Annotation of a Spreadsheet cell, indicating notes, suggestions, or observations.

Allowing multiple users to access and modify the same spreadsheet simultaneously. This enables collaborative work on the same document.

Tracking alterations made in the spreadsheet, allowing users to see who changed what and when, providing a history of edits.

Multiple users can access and edit the document simultaneously, with changes automatically reflected for all users.

The Edit menu allows users to activate 'Track Changes' which records all modifications made in the spreadsheet.

Merging combines data from two or more spreadsheets into one. Comparing highlights differences between two spreadsheets.

Combining changes from multiple versions of a spreadsheet into a single document, integrating all edits.

Highlighting differences between two versions of a spreadsheet without modifying or merging them.

Feature in LibreOffice Calc allowing you to view and manage changes made to a document.

Window in Calc that allows you to choose a spreadsheet to compare with the currently open one.

Window in Calc that appears after comparing documents, allowing acceptance or rejection of changes.

Window in Calc that allows you to choose a spreadsheet to merge with the currently open one.