Alphanumeric tab - Edit Cell dialog

Edit the cell attributes for an alphanumeric cell.

Display Properties

Select options to control the appearance of the alphanumeric cell.

Cell Width

Allows a full range of widths for the cell to be selected. From the drop down, select one of the following:

Function

Description

Variable

Sets the cell width to shrink and grow with the contents of the cell

Exactly

Sets a definite width for the cell, regardless of cell contents

At least

Sets a lower limit for the size of the cell.

At most

Sets an upper limit for the size of the cell.

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.

Cell Height

Allows a full range of heights for the cell to be selected. From the drop down, select one of the following:

Function

Description

Variable:

Sets the cell heights to shrink and grow with the contents of the cell

Exactly:

Sets a definite heights for the cell, regardless of cell contents

At least:

Sets a lower limit for the size of the cell.

At most:

Sets an upper limit for the size of the cell.

Allow wrapping

Select this check box to enable the contents of the cell to wrap to the next line if necessary. This option is not available with fixed width Alphanumeric cells.

Accept Floating

Underline

Select this check box to allow the cell to receive a floating underline.

Underline space

Select this check box to allow extra space for underlining, if necessary. This option is only applicable in table cells and allows the user to line up the last line of the description in one table cell with the number in the next column.

Calculation

Specifies the appearance of the cell value.

Capitalization

Select the capitalization format for the cell from the drop down list. There are three choices:

  • Normal: Sets format to allow a mix of capitals and lower case.

  • Upper: Sets format as all uppercase

  • Lower: Sets format as all lowercase

  • Title: Capitalizes the first letter of each word

Input Validation

Select options to control data input to the alphanumeric cell.

Validation

Enables the use of a calculation and an operator to specify rules for the cell.

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.

Related Topics