Page 196 - IT_V1.0_Class10
P. 196
Saving a Shared Spreadsheet
When a shared spreadsheet is saved, one of the several situations may occur:
If the document was not modified and saved by another user, the document will be saved.
If the document was modified and
saved by another user, one of the
following events will occur:
If the changes do not conflict, the
document is saved, a dialog box
appears, and any cells modified by
the other user are shown.
If the changes conflict, the Resolve
Conflicts window appears on the
screen. Decide for each conflict, i.e.,
which version to keep, Keep Mine or
Keep Other. When all conflicts are resolved, the document is saved. While resolving the conflicts, no
other user can save the shared document.
If another user is trying to save the shared document while other user is resolving conflicts, a message that the
shared spreadsheet file is locked due to a merge in progress. Choose to Cancel saving or Retry saving later.
When a shared spreadsheet is successfully saved, the document shows the latest version of all changes that
got saved by all users.
RECORDING CHANGES
Spreadsheet packages have the features that enable to track what changes were made in the data, when the
changes were made, who made the changes and in which cells the changes have occurred.
Record Changes feature is used to track every edited cell by highlighting it with a coloured border. On
selecting an edited cell, details of the change will appear. This allows the reviewers to observe those changes
before accepting them permanently. Record Changes function is available in LibreOffice for word processing
documents and spreadsheet documents.
When several authors are working on the same spreadsheet, the Record Changes function records and
displays the changes made by different authors. On the final edit of the document, it is then possible to look
at each individual change and decide whether it should be accepted or rejected.
For example, Aniket is the Deputy Manager of a reputed organisation. He has to analyse and update the
rate of manufactured stationery items received from Accounts department and send it to Manager for final
approval or rejection.
Aniket can use Record Changes feature to record the changes made in rate of stationery items received
from Accounts department. Changes done by Aniket will be shown with coloured outline border which will
be identified by the Manager and then he can accept or reject those changes.
A few changes are not recorded. For example, changing of a tab stop from align left to align right is not
recorded. However, all usual changes made by a proof reader are recorded, such as additions, deletions, text
alterations, and usual formatting.
194 Information Technology Play (Ver 1.0)-X

