Cell Comments in Financial Management

Cells in ad hoc grids, data forms, Smart Slices, and the Query Designer can contain multiple comments. Comments within a cell are are differentiated by their labels, which are defined in Financial Management. You cannot create labels in Smart View.

You select from these defined labels to add and view in Smart View. You cannot edit or delete labels, but you can edit and delete comments.

Viewing and Adding Comments

  To view or add cell comments in Financial Management:

  1. Select a cell in the grid.

  2. From the HFM ribbon, select Cell Comments to open the Cell Text dialog box.

    Any comments currently associated with the cell are displayed in the Cell Text list.

  3. To add a comment, from Cell Text, select a label from the drop-down menu.

  4. Select the Add button.

    The selected cell text label is added to the list of labels in Cell Text.

  5. Repeat as needed to add other labels.

  6. Click OK.

    The labels in the list are now associated with the cell.

Editing and Deleting Cell Comments

  To edit or delete cell text in Financial Management:

  1. Select a cell in the grid.

  2. From the HFM ribbon, select Cell Comments to open the Cell Text dialog box.

  3. From Cell Text, select a comment in the list and then do one of the following:

    • To edit the comment, select the Edit button. The comment is displayed in a field, where you can edit the text. Click OK after editing.

    • To delete the comment from the cell, select the Delete button. The comment is removed from the list. Deleting a comment removes it only from the selected cell; it remains available for selection from the drop-down menu. Click OK.

Note:

In Financial Management, you can use functions HsSetText and HsGetText to submit and retrieve cell text to and from the data source. See Functions.