Investment Studio > Objects > Grid > Data entry

Grid cells can be read-only or editable, depending on the corresponding record field definition.

To modify an editable cell, select it, then either press Del to reset its value (to 0 for numerical cells, to "" for string cells) or press Enter (or click it) to edit its value. The cell's response depends on its data type:

Boolean Toggles between TRUE (checked) and FALSE (blank).
Integer Opens an in-place editor:

Type a value and/or use the spin buttons to increment/decrement. Abort and revert to the previous value by pressing Esc, commit to the new value by double-clicking or pressing Enter.

Image Opens an in-place editor:

Works like the in-place editor for integers; additionally displays the image corresponding to the current value (if any).

Color Opens a standard Windows color selection dialog. Abort and revert to the previous value by pressing Esc, commit to the new value by clicking OK or pressing Enter.
Float Opens an in-place editor:

Float formatting (in particular, the choice of decimal separator) depends on the computer's regional settings.

Works like the in-place editor for integers.

Date Opens an in-place editor:

Date formatting depends on the computer's regional settings.

Use the mouse or the left/right arrows to select date field; type new date field values or use the up/down arrows to increment/decrement them. Abort and revert to the previous date by pressing Esc, commit to the new date by pressing Enter.

Click the spin button to open a calendar-style date picker:

In the calendar, use the numeric keypad (arrow keys, PgUp, PgDn) to move around, press Enter to commit to the selected date, press Esc to abort. Clicking a date selects and commits in one step.

Time Opens an in-place editor:

Time formatting depends on the computer's regional settings.

Use the mouse or the left/right arrows to select time field; type new time field values or use the up/down arrows (or spin buttons) to increment/decrement them. Abort and revert to the previous time by pressing Esc, commit to the new time by pressing Enter.

String Opens an in-place editor:

The editor will expand to the bottom of the Grid if necessary to fit the entire string. Abort and revert to the previous value by pressing Esc, commit to the new value by double-clicking or pressing Enter.

Currency Opens an in-place editor:

Type the new three-letter currency code. Abort and revert to the previous value by pressing Esc, commit to the new value by double-clicking or pressing Enter.

Click the button to open a currency selection dialog:

In this dialog, use the mouse or the numeric keypad (arrow keys, PgUp, PgDn) to move around, press Enter or click OK to commit to the selected currency, press Esc to abort.

Clicking a column header causes the list to be sorted on that column. Click a second time to reverse the sort order.

Lookup types (i.e. Portfolio, Asset and Transaction types) are all handled as one of the above; the choice depends on the type of the referenced value.