Use special characters to edit the values in an embedded worksheet

You can edit the values of the cells in an embedded worksheet, using the special characters such as ##, +, /, -, or %. This allows you to add or subtract a value or a percentage to the existing value.
Note: You can only edit cells that are displayed with an underline.

Examples:

  • To the original value of 200, specify ##+10% to add 10% to the original value; new value 220.
  • To the original value of 200, specify ##+10 to add 10 to the existing value; new value 210.
  • To the original value of 200, specify ##-10% to subtract 10% from the existing value; new value 180.
  • To the original value of 200, specify ##-10 to subtract 10 from the existing value; new value 190.

This option is applicable only:

  • If a value is already specified for the cell.
  • If you are editing a measure that is defined in the rv_measure_calc parameter, the spread measure defined for the rule is used. If not, the existing spreading measure is used.