Unlocking Workbook Cells

• Unlocking Workbook Cells
  • Overview
  • Process
    • Cell Locking
    • Unlocking Workbook Cells
      • Workflow Status
      • Sample Expiry
      • Formulas

Overview

Each laboratory might have their own rules as to whether cells that contain formulas should be locked, whether cells that are associated with an expired sample scheme analyte should be locked, whether cells that contain results can have another result entered, which workflow status of a SSA should trigger a cell to be locked, and which workflow status of a SSA can a user unlock. These rules are set by a laboratory preferences.

Where a sample scheme analyte exists for the associated workbook cell, then cell locking is based various analyte lockers. A workbook cell is locked where:

• The job is finalised (applied using the finalisedJobAnalyteLocker). This type of lock cannot be unlocked in workbook.

• The workbook is opened as read-only (applied using the workbookReadOnlyAnalyteLocker). This type of lock cannot be unlocked in workbook, that is, you have to exit the current workbook session and reopen it without the read-only mode applied.

• The sample is not activated (applied using the sampleNotActivatedAnalyteLocker). This type of lock cannot be unlocked in workbook.

• The scheme is read-only due to an active job scheme lock (applied using the schemeReadOnlyAnalyteLocker)

  Refer to:

  • Maintaining Job Locks

  • Conditions for Setting Job Scheme Locks from Workbook

  • Conditions for Releasing Job Scheme Locks set from Workbook.

  If job locks exist for the same job because a job is open in the CCREGN—Job application or an invoice is open in the CCINV—Invoice application, or job scheme locks exist for the same job scheme because a workbook is loaded or reloaded in the CCWKOP—Open Workbook or CCWKOPTRAN—Open Transposed Workbook applications, and the locks are still active, then the workbook is opened, however, the relevant cells are locked for update. If workbook cells are not locked by active job locks or job scheme locks, they can still be locked due to other conditions: workflow status, formula, or expiry.

  If a job scheme lock exist for the sample because a workbook containing the sample scheme is loaded or reloaded in the CCWKOP—Open Workbook or CCWKOPTRAN—Open Transposed Workbook applications, then the sample's tests and specifications are displayed as read-only.

• The workbook’s mode locks the cell based on what data is shown in the cell (applied using the workbookModeAnalyteLocker).

• The cell is locked due to the SSA's Workflow Status:

  • The S/SS/SSA has a Workflow Status of Listed Not Received (applied using the lnrWorkflowStatusAnalyteLocker).

  • The cell has a Workflow Status listed in the AUTO_LOCK_WORKFLOW_STATUS application preference (applied using the autoLockWorkflowStatusAnalyteLocker).

  Refer to:

  • Conditions for Setting Workbook Cell Locks due to Workflow Status

  • Restrictions on Releasing Workbook Cell Locks due to Workflow Status

  Also refer to the Appendix—Job Life-cycle and the Status Cascade Engine for locks based on workflow status.

• The cell has a Workflow Status of Analysed, that is, it has a result, and the user does not have the ALLOW_RESULT_OVERWRITE preference setting to allow result overwrite (applied using the allowResultOverwriteAnalyteLocker)—refer to Restrictions on Overwriting a Result.

• The cell has a formula and the AUTO_LOCK_FORMULAS application preference is set (applied using the autoLockFormulaAnalyteLocker)

  Refer to:

  • Using Formulas to Calculate Results

  • Conditions for Setting Workbook Cell Locks due to a Formula

  • Restrictions on Releasing Workbook Cell Locks due to a Formula.

• The sample portion due to undergo analysis for the test has expired, that is, the sample scheme's or sample scheme analyte's Expiry Date is exceeded (locking is applied using the expiredAnalyteLocker)

  Refer to:

  • Using Sample Expiry

  • Conditions for Setting Workbook Cell Locks due to Expiry

  • Restrictions on Releasing Workbook Cell Locks due to Expiry.

  Also refer to the Effect of Scheme Scope upon Expiry and Warning of Expiry in Workbook.

The rights to unlock cells are based on preference settings.

Process

Cell Locking

View the reason for a lock on a workbook cell

Cell locking is based various analyte lockers, as noted in the overview.

Unlocking Workbook Cells

Unlock workbook cells that are locked

Where a workbook cell is unlocked for a specific lock case, the cell may still be locked due to other locking reasons.

Cells are unlocked based upon your permissions. Review the cell locking conditions and unlocking restrictions, as noted in the overview.

If the workbook is reloaded, the cell locking conditions are reapplied.

Workflow Status

Ensure a workbook menu item exists to execute the Unlock Cells Workbook function based on workflow status.

The ALLOW_UNLOCK_EXPIRED application preference allows users to unlock workbook cells that are locked due sample scheme analyte workflow status. Refer to Configuring Analysis.

Sample Expiry

Ensure a workbook menu item exists to execute the Unlock Cells Workbook function based on sample expiry.

The ALLOW_UNLOCK_EXPIRED application preference allows users to unlock workbook cells that are locked due sample scheme or sample scheme analyte expiry. Refer to Configuring Analysis.

Formulas

Ensure a workbook menu item exists to execute the Unlock Cells Workbook function based on the existence of a formula.

The ALLOW_UNLOCK_FORMULAS application preference allows users to unlock workbook cells that are locked due a formula in the cell. Refer to Configuring Analysis.