Editing Cell Formats
Depending on your role, you may be able to edit the format of individual cells in a template, DataView, or view. For example, you may want to change the scaling of the cell’s data, or the number of decimals shown in the cell’s data.
For example, in the following illustration, the scaling and number of decimals for the selected cell have been changed.
When you define individual cell formats, those settings override the format settings of the symbols to which that cell belongs, as well as the global format settings for the file. Depending on your role, you may be able to perform this task.
| Role | Can perform this task? |
|---|---|
| Report Publisher | yes |
| Report Author | yes |
| Report User | no |
To edit the format of an individual cell, complete these steps.
- Right-click on the cell you want to edit. A pop-up menu appears.
- Choose Edit Cell Format. The Cell Format dialog appears, with the coordinates of the cell you want to edit highlighted in the list box.
- In the list box, make sure the cell you want to edit is selected.
- To add cells to the list, select the coordinates of the cell to edit in the Symbol section, and click New.
- To remove cells from the list, select them and click Delete.
- Complete these fields.
Field Description Decimal Select the number of decimal places for the cell’s data.
If you select Default, the setting specified in the Symbol Format dialog is applied. For more information, see Editing symbol formats.
The results of allocation calculations are rounded up to the precision you select here.
Scaling Factor Select a scaling factor for the cell’s data. Scaling refers to the format in which the data appears. For example, if you are dealing with very large numbers, you may want to view numbers in thousands or millions. Scaling makes the numbers easier to read. For example, to view the number “10,000” as “10”, select 000s to specify that all numbers appear in thousands.
If you select Default, the setting specified in the Symbol Format dialog is applied. For more information, see Editing symbol formats.
- Click OK. The cell is reformatted.