New!Linking to CaseView Database Records in Excel
Note: This is applicable to Connector versions 2010.00.017 and later.
Linking to CaseView database records (e.g. using cw_cvdata(..) in linkages) can return an empty string in Excel. An issue can occur if this empty string is part of a formula. In every case, a formula returns a #VALUE if one of its operands is an empty string. This #VALUE indicates that the expression is incorrect because of an invalid argument: the empty string.
To change the default behavior in Connector to convert empty strings to a zero value (0) to ensure that the #VALUE error does not appear, use the CVDataBlankToZero registry key.
Procedure
To activate the CVDataBlankToZero registry key setting:
- Close Excel.
- Go to the Start menu and search for regedit.
- Select and open the Registry Editor. You require administrative permissions for this operation.
- Navigate to HKEY_CURRENT_USER | Software | CaseWare International | CaseWare Connector | Settings | Excel.
- Right-click in the right pane and select New | DWORD (32-bit) Value.
- Name this key CVDataBlankToZero.
- Double-click this entry and set the value to 1. Select the radio button for decimal base.
- Click OK.
- Close the Registry Editor and open Excel.
Result
All empty strings are converted to the value zero (0) when linked in Excel from the CaseView database.
Notes
- All invalid arguments are also converted to zero (0).
- Deactivate this behavior by deleting the registry key or set the registry key value to zero (0). Deactivating this key returns Connector to its default behavior - that is, cw_cvdata(...) returns the value retrieved from the CaseView database or #VALUE if the argument is invalid.
