Events tab - Edit Cell dialog

Use this dialog to set up actions that may be performed automatically when the user clicks on a check box or radio button or double-clicks a cell.

Event

Select an action that will initiate the event.

Select	Action
On Click	The event will be performed when the user clicks the cell in the Form Mode (with or without editing enabled).
On Double-click	The event will be performed when the user double-clicks the cell.
On Enter	The event will be performed when the user clicks on the cell and the value changes or a user types a value into the cell. Note: using the cursor keys to enter a cell also triggers the event.
On Exit	The event will be performed when the user exits the cell in Form Mode (with or without editing enabled).
On Input	The event will be performed when the user inputs data into the cell in Form Mode (with or without editing enabled).
On Selection Change	The event will be performed when the user selects a new option in a popup cell.

 

Undoable

Select to allow the event to be undone using Ctrl+Z. Events in files converted from earlier versions of CaseView are undo-able by default.

Running an undo-able event clears the list of actions that can be undone in a file.

Keep Arguments type

Select to allow arguments to keep their original type, such as a string, integer or date, instead of being converted to a string. For example, with this option selected, the event SetCellValue("C1", sysdate()), returns the date value 01/01/07 instead of the string "01/01/07".

Calculations

Lists actions that are assigned to the cell. Multiple actions may be assigned to the same cell. Click the Add button to add a new action. Click the Delete button to delete an action from the list. To rearrange items in the Calculations box, click on an item, and then select the button you want to move the item higher or lower in the list.

Additionally, the Calculations window supports copy (Ctrl+C), paste (Ctrl+V), cut (Ctrl+X), select all (Ctrl+A), and delete functionality through keystrokes. This allows for one or more events to be deleted, copied, or moved to another event type or cell with ease.

Add

Click Add to create a new action for the cell.

Delete

To delete an action from this cell, select the action in the Calculations box and then click Delete.

Automatic Calculation Entry

Complete the properties below to add the applicable calculation to the Calculations box automatically.

Action

Select the action you want to assign to the event and then complete the details of the action in the boxes provided. Please refer to the Event Functions Index for a detailed listing of each action.

Note: This option is unavailable if no event has been added to the Calculations area or if multiple selections have been made in the events list.

Run Skip Condition

Enter a condition that will prevent the event from occurring. Note, this option is unavailable if no event has been added to the Calculations area or if multiple selections have been made in the events list.

Cursor

Select the desired cursor type to be displayed in the Form Mode.

Select	Cursor:
Default	Doesn't change when over the cell in Form Mode.
Hand	Changes to a hand whenever it's over a cell
Properties	Changes the cursor to this symbol: .

Related Topics

• Edit Cell