Changing and Adding Values


1.Before you can edit a data set, you have to open it. To do this, double-click on the data set in the Object List. If the data set is already displayed in an open folder's data view, the data view is activated and the data set is displayed. Otherwise, a data set window appears, allowing you to edit the data set.

2.Using the mouse or keyboard, move the cell selection to the cell you want to edit. To insert data, select an empty cell.




Move the cell selection in the corresponding direction, if possible. If you hold down the SHIFT key, the cells that you cross over are selected.


Moves the cell selection to the right or left, if possible.


Moves the cell selection down, if possible.


Moves the cell selection to the top left corner of the data grid.


Moves the cell selection to the lower right corner of the data grid.


Moves the cell selection into the first column of the current row.


Moves the cell selection into the last column of the current row.

3.Press the F2 key or start entering the desired value immediately.

4.Finish entering the value by pressing the ENTER key.

Your input is converted into the valid data type for the component and inserted into the data set.

Depending on the data type of the data set to which the selected cell in data view belongs, the following rules apply when you input values:

Real Floating Point Values

For a void value, enter '?'.

Complex Values

Both the real and imaginary parts of the complex value are entered in a cell. The data view displays complex numbers in the format '(real ; imag)' or real+imagi and also accepts both input formats. When entering data in the format '(real , imag)', you can omit the parentheses. The two values must be separated by the list separator (usually ',') specified in the Options dialog box.

Boolean Values

If you would like to enter Boolean values, you can either enter the texts 'TRUE' or 'FALSE', or specify 0 for FALSE and 1 for TRUE. The data view itself always displays Boolean values as words.

Time Span Values

Enter these in the format 'D:H:M:S.ssss' or 'H:M:S.ssss'. Enter the fractional digits for seconds up to the desired resolution.

Calendar Time Values

Here, FlexPro accepts the formats 'M/D/Y H:M:S.ssss', 'Y-M-D H:M:S.ssss' and 'D.M.Y H:M:S.ssss', . When entering data, you must always use these formats, even if the data is displayed in a different format.

Note:   You can use FPScript formulas to enter data. To do this, the text that you input must start with '=', for example '=2 + 3' places the value 5 into the cell. You can also initialize one- and two-dimensional arrays; for example '=0#3#4' initializes a matrix with 3x4 elements with zeros. If you want to enter a string that starts with '=' in a text data set, you need to add an apostrophe first in order to prevent your input from being interpreted as FPScript code.

See Also


Data Set Window and Data View

Navigating and Selecting Data

Share article or send as email:

You might be interested in these articles