Setting Up Cell Editor

Question

How to enable entering only numeric values in the regular report cells?

Application Area

Data format can be set up to restrict values entered into cells of regular report sheet. For example, the user can set up entering only numeric or logical values.

Source Data

Regular report sheet:

Only numeric values (integer or real) must be entered to the B0 cell.

Solution

Set up value format in the B0 cell. To do this:

  1. Select the B0 cell.

  2. Execute one of the following operations:

After executing the operation the Cell Format dialog box opens.

  1. Go to the Number Format tab:

  1. Click the Set Up button. The Value Editor Parameters dialog box opens.

  2. Select the Float Editor value in the Type drop-down list:

  1. Select the Default Value and the Tolerance checkboxes.

  2. To save settings, click the OK button in the Value Editor Parameters dialog box and then click the OK button in the Cell Format dialog box.

After the B0 cell is set up, when selected, (by double-clicking on the cell) it looks as follows:

Thus, the B0 cell attributes are set up so that only numeric values can be entered into this cell.

See also:

Questions and Answers │ Table Cell AttributesValue Editor Parameters