Workbook Commands

The following commands are native to workbook, and can be added to any workbook main command menu or right click menu.

Workbook Command Menu Definition Code Description Example

Activate Upper Check

ACTIVATE_UPPER_CHECK

Requests a check on the upper analyte (set REPEAT) if selected cells are checked.

<command code="ACTIVATE_UPPER_CHECK" label="Request Check"/>

Alphanumeric Mode Off

ALPHANUMERIC_MODE_OFF

Prohibits the entry of string values for numeric-type analytes.

<command code="ALPHANUMERIC_MODE_OFF" label="Alphanumeric Mode Off"/>

Alphanumeric Mode On

ALPHANUMERIC_MODE_ON

Allows the entry of string values for numeric-type analytes.

<command code="ALPHANUMERIC_MODE_ON" label="Alphanumeric Mode On"/>

Check locked cell reason

CHECK_CELL_LOCKED_REASON

Triggers an alert dialog that displays a list of all selected cells and the reason why they are locked (if any).

<command code="CHECK_CELL_LOCKED_REASON" visible="true" label="Check Locked Reason"/>

Exclude from Aggregate Functions

EXCLUDE_FROM_AGGREGATE_FUNCTIONS

Excludes selected analytes from getting passed to any aggregate formula functions.

<command code="EXCLUDE_FROM_AGGREGATE_FUNCTIONS" visible="true" label="Exclude from Aggregation"/>

Go to Bar Code Bar Focus

GOTO_BARCODE_BAR

Sets the barcode bar to focus and ready for input.

<command code="GOTO_BARCODE_BAR" visible="true" label="Goto Barcode Bar"/>

Ignore QC Failures

IGNORE_QC_FAILURES

Ignores any QC failures for selected cells and prompts for an ignore reason.

<command code="IGNORE_QC_FAILURES" label="Ignore QC Failures"/>

Ignore DL Failures

IGNORE_DL_FAILURES

Ignores any DL failures for selected cells.

<command code="IGNORE_DL_FAILURES" label="Ignore DL Failures"/>

Include in Aggregate Functions

INCLUDE_IN_AGGREGATE_FUNCTIONS

Includes selected analytes into any aggregate formula function that marks the analytes as part of is range.

<command code="INCLUDE_IN_AGGREGATE_FUNCTIONS" visible="true" label="Include in Aggregation"/>

Open Select Sample Dialog

OPEN_SELECT_SAMPLE_DIALOG

Usable only in worklist mode.

Opens a "select sample" dialog to then identify the job, sample, and scheme to open in the worklist.

<command code="OPEN_SELECT_SAMPLE_DIALOG" label="Toggle Detail Panel"/>

Reassess Results

REASSESS_RESULTS

Forces the reassessment of selected cells in terms of the workflow and status limit checks.

<command code="REASSESS_RESULTS" label="Reassess Results"/>

Recalculate Formulas

RECALCULATE_FORMULAS

Forces the recalculation of formulas for selected cells.

If no cells are selected, then all formulas are recalculated.

<command code="RECALCULATE_FORMULAS" label="Recalculate Formulas"/>

Release

RELEASE

Marks selected cells as released.

<command code="RELEASE" label="Release"/>

Request Repeat

REQUEST_REPEAT

Requests a repeat on selected cells.

<command code="REQUEST_REPEAT" label="Request Repeat"/>

Reset Workflow Status

RESET_WORKFLOW_STATUS

Resets the Workflow Status for selected cells back to Not Started if they were previously Listed Not Received, Insufficient Sample, Not Analysed, or No Result.

<command code="RESET_WORKFLOW_STATUS" label="Reset Workflow Status">

Set User Workflow Status

USER_WORKFLOW_STATUS

Sets the User Defined Workflow status for selected cells.

The required User Workflow Status code is passed in as string parameter.

If the User Workflow Status code is defined and associated with a core Workflow Status, then also sets the Workflow Status.

Refer to Enumerations related to User Workflow Statuses and Enumerations related to Core Workflow Statuses.

<command code="USER_WORKFLOW_STATUS" label="Lost In Lab">

<parameters>

<string>LIL</string>

</parameters>

</command>

Set Workflow Status

WORKFLOW_STATUS

Sets the primary Workflow Status value for selected cells.

The required Workflow Status enumeration is passed in as string parameter.

All applied workflow statuses are still evaluated by the core logic, which means that a specific Workflow Status cannot be set blindly if it is not allowed.

Refer to Enumerations related to User Workflow Statuses and Enumerations related to Core Workflow Statuses.

<command code="WORKFLOW_STATUS" label="Completed">

<parameters>

<string>11</string>

</parameters>

</command>

Show Composite Specification Status

SHOW_COMPOSITE_SPECIFICATION_STATUS

Displays the specification colour status indicators for the Composite Specification Status.

<command code="SHOW_COMPOSITE_SPECIFICATION_STATUS" label="Show Composite Specs"/>

Show Data Entry Column Code

DATA_ENTRY_COLUMN_SHOW_CODE

Force display of the Scheme Code in the data entry column header.

Normal Mode: Analyte Code

Transposed Mode: Sample Code

<command code="DATA_ENTRY_COLUMN_SHOW_CODE" visible="true" label="Show Code"/>

Show Data Entry Column Group Code

DATA_ENTRY_COLUMN_GROUP_SHOW_CODE

Forces the display of the Scheme Code in the data entry column group header.

<command code="DATA_ENTRY_COLUMN_GROUP_SHOW_CODE" visible="true" label="Show Code"/>

Show Data Entry Column Group Label

DATA_ENTRY_COLUMN_GROUP_SHOW_LABEL

Forces the display of the label in the data entry column group header.

<command code="DATA_ENTRY_COLUMN_GROUP_SHOW_LABEL" visible="true" label="Show Label"/>

Show Data Entry Column Label

DATA_ENTRY_COLUMN_SHOW_LABEL

Forces the display of the label the data entry column header.

Normal Mode: Analyte Label

Transposed Mode: Sample Label, if the WKBK_TRANSPOSED_GRID_SAMPLE_HEADER application preference is set.

<command code="DATA_ENTRY_COLUMN_SHOW_LABEL" visible="true" label="Show Label"/>

Show Primary Specification Status

SHOW_SPECIFICATION_STATUS

Displays the specification colour status indicators for the Primary Specification Status.

<command code="SHOW_SPECIFICATION_STATUS" label="Show Primary Specs"/>

Toggle Workbook Detail Panel

TOGGLE_DETAIL_PANEL

Toggles the visibility of the workbook detail panel (that is, the lower panel).

<command code="TOGGLE_DETAIL_PANEL" label="Toggle Detail Panel"/>

Unlock cells

UNLOCK_SELECTED_CELLS

Unlocks selected locked cells so that locked cells become editable.

<command code="UNLOCK_SELECTED_CELLS" visible="true" label="Unlock Cells"/>

Validate

VALIDATE

Marks selected cells as validated.

<command code="VALIDATE" label="Validate"/>

View Readings

VIEW_READINGS

Displays a dialog of the all the readings for selected cells.

<command code="VIEW_READINGS" label="View Readings"/>

Special Editing Commands

Workbook Command Menu Definition Code Description Example

Delete Cell Content

SHORTCUT_DELETE

Deletes the values/formulas of selected cells.

<command code="SHORTCUT_DELETE" label="Delete"/>

Copy Cell Formulas

SHORTCUT_COPY_FORMULAS

Copies the formulas of selected cells.

<command code="SHORTCUT_COPY_FORMULAS" label="Copy Formulas"/>

Copy Cell Values

SHORTCUT_COPY_VALUES

Copies the values of selected cells.

<command code="SHORTCUT_COPY_VALUES" label="Copy Values"/>

Cut Cell Formulas

SHORTCUT_CUT_FORMULAS

Cuts the formulas of selected cells.

<command code="SHORTCUT_CUT_FORMULAS" label="Cut Formulas"/>

Cut Cell Value

SHORTCUT_CUT_VALUES

Cuts the values of selected cells.

<command code="SHORTCUT_CUT_VALUES" label="Cut Values"/>