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
   191   192   193   194   195   196   197   198   199   200   201