Deleting Essbase Cell Comments

Be sure to complete the steps in Enabling Essbase Cell Comments.

Note:

The procedure in this topic shows you how to delete Oracle Essbase cell comments using the View Comments command and the Comment Edit dialog box in Oracle Smart View for Office. You can also delete cell comments directly in the grid, without using the Smart View interface elements in this topic.

To delete Essbase cell comments:

  1. If you have not already done so, open a workbook containing a grid, connect to an Essbase provider, and click Refresh.
  2. Click View Comments in the Essbase ribbon (see Figure 5-15).

    The Comment Edit dialog box is launched. The example in Figure 5-21 shows one comment left on the sheet, which can be removed.

    Figure 5-21 Comment Edit Dialog Box


    The Comment Edit dialog box, showing one comment, which can be removed.
  3. To delete the entire comment, first click in the row to highlight the editable text; for example, click in the "Oregon Coast" row to highlight it, as shown in Figure 5-22, then press the Delete key.

    Figure 5-22 Cell Comment Highlighted and Ready to be Deleted


    Cell comment highlighted and ready to be deleted in Comment Edit dialog box.

    After deletion, the text in the Comments column is removed, but the Cell ID is still displayed (see Figure 5-23).

    Figure 5-23 Cell Comment Deleted, Cell ID Remaining


    The cell comment is deleted from the Comment Edit dialog box, the Cell ID remains.
  4. Click Apply Changes and view the changes in the sheet.

    In Figure 5-24, cell F5 still shows as a commented cell, and will until the sheet is refreshed.

    Figure 5-24 Sheet After Clicking Apply Changes; Cell F5 Still Commented


    Grid After Clicking Apply Changes; Cell F5 Still Commented
  5. Click Refresh; the comment style is cleared.

    Figure 5-25 Grid After Refresh, Cell Style in Cell F5 Is Cleared


    After Refresh, the cell style on cell F5 is now cleared.