Page 225 - Trackpad 402_Class-X_Final
P. 225

A deleted column or row is marked by a heavy red bar. This red color can be changed to some other colour by
              selecting Tools → Options → OpenOffice.org Calc → Changes.

            Viewing Changes Made Using Record Change Option

            To see the changes made using Record options:
            Step 1:  Click on Edit menu and select Changes option. A sub menu will appear.
            Step 2:  Click on Show option. The Show Changes dialog box opens:





















            The Filter settings will help you display the changes made with respect to the options given:
            •  Date: Changes made in the specified date and time range will be displayed.

            •  Author: Changes made by the specified author will be displayed. This option is useful when multiple users are
              editing the same file.
            •  Range: Changes made in the specified range of cells will be visible.

            •  Comment: Changes with the comments matching the search criteria will be displayed.
            •  Show accepted changes: Changes that you accepted in a file will be displayed.
            •  Show rejected changes: Changes that you rejected in a file will be displayed.
            Accepting or Rejecting Changes

            After the changes are made in a worksheet then you have a choice to accept by saving the changes or reject to retrieve
            the original data. The steps will be:
            Step 1:   Click on Edit menu and select Changes option. A sub menu will appear click on Accept or Reject... option. The
                    given dialog box will appear with the list of changes down in the worksheet.























            Step 2:  Click on the desired button.


                                                                                 Electronic Spreadsheet (Advanced)  225
   220   221   222   223   224   225   226   227   228   229   230