Editing Comments

Data source types: Oracle Essbase

Be sure to complete the steps in Enabling Comment Display in the Sheet.

Note:

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

To edit comments on an Essbase sheet:

1. If you have not already done so, open a workbook containing a grid, connect to an Oracle Essbase provider, and click Refresh.
2. Click View Comments in the Essbase ribbon.

   Figure 10-23 View Comments Command in Essbase Ribbon

   
   
   

   Tip:

   The View Comments command is enabled only when there are comments in the sheet.

   The Comment Edit dialog box is launched. The example in Figure 10-24 shows two comments in the sheet which can be edited.

   Figure 10-24 Comment Edit Dialog Box

   
   
   
3. To edit the text in a row, 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 10-25

   Figure 10-25 Row Highlighted, Ready for Editing in Comment Edit Dialog Box

   
   
   
4. Edit the text as required; in this example, change "Oregon Coast" to "Oregon".

   Figure 10-26 Changed Text in Comment Edit Dialog Box

   
   
   
5. Click Apply Changes and note the change in the grid.

   In Figure 10-27, cell C4 still shows as a commented cell, and will until the sheet is refreshed.

   Figure 10-27 Grid After Clicking Apply Changes; Cell C4 Still Commented

   
   
   
6. Click Refresh; the comment style is cleared.

   Figure 10-28 Grid After Refresh, Cell Style in Cell C4 Is Cleared; Member is In Sync with Server