• Calculation
  • Linkage
  • User Defined Data
  • About cell calculations
  • About checking portions of calculations
  • About direct referencing
  • About relative referencing
  • About the Equation Bar
  • Apply rounding
  • Apply rounding relations
  • Calculation Editor
  • Calculation operators
  • To enter a cell calculation
  • To enter a text value into an alphanumeric cell
  • Wildcard Characters

Apply rounding

Use rounding to control the decimal placement for numbers in a CaseView document. For example, the resulting value for the number 12345678999 is:

• 123456789.99 when rounding to 1's.
• 123456.78999 when rounding to 1,000's.
• 12345.678999 when rounding to 10,000's.
• 123.45678999 when rounding to 1,000,000's.
• 1.2345678999 when rounding to 100,000,000's.
• .12345678999 when rounding to 1,000,000,000's.

For information on applying rounding relations in a document, see Apply rounding relations.

To apply rounding:

1. Ensure you are working in Design Mode.
2. On the ribbon, click Tools | Rounding.
3. In the Rounding dialog, select Apply Rounding.
4. If you want to allow users to enable or disable rounding while viewing the document in Form Mode, select Allow Enabling and Disabling of Rounding in Form Mode.
5. In the Round To drop-down menu, select the level of rounding you want to apply. Selecting Display zeroes will ensure that numbers in the 1000s or higher will display all digits. Click OK.

Rounding is applied to the document and all affected numbers are updated.

Note: Rounding only affects cells that are linked to the Working Papers database.

Create a rounding cell event

You can create a cell in your document that will enable or disable rounding when clicked, rather than customizing the rounding settings from the Tools menu each time.

To create a rounding cell event:

1. Ensure you are working in Design Mode.
2. On the ribbon, click Tools | Rounding.
3. In the Rounding dialog, configure your rounding options as required. Click OK.
4. On the ribbon, click Home | Cell. Enter a cell number for the new cell and click OK.
5. In the New Cell dialog, on the General tab, click the Cell Type drop-down menu and select Check Box.
6. Click the Events tab. In the Event drop-down menu, select On Click.
7. Click Add.
8. In the Action drop-down menu, select Round To.
9. In the Round To field, enter the applicable rounding level (i.e. "1", "1000", "10000", "1000000", "100000000" or "1000000000").
10. If required, enter a skip condition for the event. Click OK.

The rounding cell event is added to the document. When viewing the document in Form Mode, users can select the check box to apply rounding to the document, or deselect the check box to disable rounding.