Page 223 - Trackpad 402_Class-X_Final
P. 223

Saving A Shared Spreadsheet

            There may be different issues with the shared document whenever you wish to save them:
            •  The document will be saved automatically after you open it and no other user has done any changes in the
              document.

            •  After you open a document if any other user has modified then:
                 w If the changes made by both the user and yourself do not match i.e. if the changes are not common, then your
                document will be saved with both the changes. The changes made by the other user will be with RED BORDER.
                For example, if you change the value of cell A10 and the other user changes the value of cell B10 then the saved
                document will have both the changes but B10 with a red border.
                 w If the changes made by both the user and yourself are done for a common cell then at the time of saving the

                document a dialog box saying Resolve Conflicts Dialog appears. Then you have to decide which version you want
                to keep-your or the other user’s. After the conflicts are resolved then the document will be saved.
                 w No two or more users can save the same shared document at the same time. If the other user is trying to save the
                same shared document. Then you will not have the permission to save it. The document will be locked with the
                message merge-in in progress. You have to cancel the save command and retry later.



                    RECORD CHANGES IN A SPREADSHEET

            OpenOffice Calc allows you to keep a track of the changes made in a document using the Record Changes option. If you
            make any changes in the original document, then your name along with new value and the cell address will be saved
            so that if you want to undo the changes you may have that option later.



                                                                                 Electronic Spreadsheet (Advanced)  223
   218   219   220   221   222   223   224   225   226   227   228