Editing Cell Values
Individual cell values may be modified with certain restrictions. Integer and float variables may only be modified with number input, the application truncates any decimal point and places for integer types, and the application does not check for data values that are too small or too large for the defined type. To edit the value in a cell, type the new value directly in the cell. The value will not be accepted until the Enter key is pressed, until the cursor is placed in another cell, or until the file is saved.
To “delete” the value in a cell, use the Delete command in the Edit menu, or simultaneously press the Ctrl+D key combination when the appropriate cell is selected. The application requires this method because data may not actually be deleted. The Delete command sets an internal flag for the selected piece of data to missing.
Editing a cell value will mark the file as containing altered data, will store an annotation with the session, and will update the modified dates for both the session and the data file containing that session. Modified dates may be viewed in the file’s properties.