Numeric tab - Edit Cell dialog

Use this dialog tab to edit the cell attributes for a numeric cell.

Display Properties

Select options to control the appearance of the numeric cell.

Width

Select the type of width from the drop-down list.

Select	To
Variable	Select this option if you want the cell width to expand as contents are input.
Exactly	Select this to fix the width of the cell at the dimension selected in the box to the right.
At Least	Select this option to specify a minimum cell width in the dimension box.
At Most	Select this option to specify a maximum cell width in the dimension box.
Column	If the cell is contained within a table or a multi-column format, select this option to allow the maximum width of the cell to be the column width.

Tip

Subsequent cells of each type (numeric, alphanumeric, date, etc.) inherit the initial settings of the last cell of the same type created. These settings can be changed if the user desires.

Height

Select the type of height from the drop-down list.

Select	To
Variable	Select this option if you want the cell height to expand as contents are input.
Exactly	Select this to fix the height of the cell at the dimension selected in the box to the right.
At Least	Select this option to specify a minimum cell height in the dimension box.
At Most	Select this option to specify a maximum cell height in the dimension box.

Currency/Unit Symbol

Display

Select this to show the currency sign or symbol in the cell.

Source

Select the settings to be used for default currency/ units. The options include using the Windows Regional settings, using the options set in the Cell Options dialog, using a percent (%) symbol, or creating a custom symbol for the cell.

Symbol

If using a custom symbol, type the symbol to display as the custom currency/ unit symbol.

Position

If using a custom symbol, select the position of the custom symbol relative to the cell contents - to the left or to the right.

Display Zero as

To specify how zero values are displayed, select an option in the Zero as box.

Display Positive as

To specify how positive values appear, select an option in the Positive as box.

Display Negative as

To specify how negative values are displayed, select an option in the Negative as box.

Digit Grouping Symbol

If you want the digits in large currency values formatted with separators, select Default, the grouping symbol specified in the regional settings in the Control Panel. If you do not want the currency values formatted, select None. To define your own Digit Grouping Symbol, click in the box and type a single character.

Decimal Points

Enter the number of digits displayed to the right of the decimal point. (CaseView supports up to 8 decimal places.)

Switch Sign

Performs a switch sign on the value of the cell by returning a negative cell value as a positive value and a positive cell value as a negative value. Any calculations referenced to the cell will not take the switch sign into consideration and will use the original cell value.

Show Rounded to Zero Symbol

If selected, amounts rounded to zero will be indicated by a red dot.

Accept Floating

To specify floating attributes of the cell:

Currency/ Unit Symbol

Accepts a rising or sinking currency sign if this has been selected in the section attributes. See Using a sinking or rising currency for more information. The floating Percent symbol works the same way as the currency symbol.

Underline

Accepts a smart underline in the event of a skip in the section.

Underline Space

Accepts a space in the event of a skip in the section. This option is only applicable in table cells and allows the user to ensure that the last line of the description in one table cell aligns with the number in the next column. With this option enabled, when one or more cells in the row are underlined, the height of all cells in the whole row adjust to keep the baseline of all the cells, even those not underlined, aligned.

Calculation Properties

Select options to control the calculations in the numeric cell.

Flip Sign of Value

Returns a negative cell value as a positive value and a positive cell value as a negative value. Any calculations referenced to the cell will also return flipped positive or negative values, taking the flipped sign into consideration accordingly.

Disable Rounding

If selected, rounding will not be applied to the cell.

Positive becomes Zero

If the calculation results in a positive value, activate this check box to render the value zero. This option is useful in the preparation of financial statements when you wish to flip an account balance to another section of the statement.

Negative becomes Zero

If the calculation results in a negative value, activate this check box to render the value zero. This option is useful in the preparation of financial statements when you wish to flip an account balance to another section of the statement.

Use Decimals for Precision

Select to lock the number chosen in the Decimal Precision selector to the number selected under Decimal Points so that changing one automatically changes the other to match.

Decimal Precision

If used, the number of decimal places selected in the Decimal Precision selector represents the number of decimals stored in the cell but not necessarily displayed. These decimal places are used in calculating the value of the cell.

To have number of decimals saved in the cell for calculation purposes differ from the number of decimals displayed, ensure the Use Decimals for Precision check box is cleared, and then set the number of decimal using the selector. With the option cleared, changing this number will not change the number selected to display in the cell under Decimal Points.

Input Validation

Select options to control data input to the numeric cell.

Validation

Enables the use of a calculation and an operator to specify rules for the cell. Select an operator from the drop down list and then click the calculation button to create a calculation in the Calculation Editor.

If validation fails

Enables you to create a rule in the event that the cell validation fails.

Response

Choose a response type from the drop down and then click the calculation button to create a calculation in the Calculation Editor.

Action

Choose an action in the event that the cell validation fails. You can choose to accept or reject the value.