Type Cell (Text Fields Section)
Specifies a data type for the text field value.
| Value | Description |
|---|---|
| 0 |
String. |
| 2 |
Number. Includes date, time, duration, and currency values as well as scalars, dimensions, and angles. Specify a format picture in the Format cell. |
| 5 |
Date or time value. Displays days, months, and years, or seconds, minutes, and hours, or a combined date and time value. Specify a format picture in the Format cell. |
| 6 |
Duration value. Displays elapsed time. Specify a format picture in the Format cell. |
| 7 |
Currency value. Uses the system's current Regional Settings. Specify a format picture in the Format cell. |
Remarks
You can also set the value of this cell using the Field dialog box (with a shape selected, on the Insert tab, in the Text group, click Field ).
To get a reference to the Type cell by name from another formula, or from a program by using the CellsU property, use:
| Value | |
|---|---|
| Cell name: |
Fields.Type[ i ] where i = <1>, 2, 3... |
To get a reference to the Type cell by index from a program, use the CellsSRC property with the following arguments:
| Value | |
|---|---|
| Section index: |
visSectionTextField |
| Row index: |
visRowField + i where i = 0, 1, 2... |
| Cell index: |
visFieldType |