Checkboxes on Datasheets

The spreadsheets used for form definitions may include checkboxes. However, checkboxes will not be displayed in the AVEVA Electrical, for example, in the Datasheet Design window or the Datasheet viewer window (although they will be displayed in any Excel output). Checkboxes therefore must be replaced with a picklist with values of True and False only.

For how to add a checkbox to an Excel spreadsheet and link it to a cell, refer to the appropriate Microsoft Excel documentation. The following points should be noted however:

• The background colour of the cell should be set to white in order to hide the AVEVA Electrical picklist value (True or False) when opened in Excel.

• The Number format of the linked cells must be set to General.

Create a picklist to be used as a substitute for a checkbox in the normal way (refer to the Common Functionality User Guide for details). The picklist must be of the True/False data type.

The picklist must then be assigned to the appropriate property (refer to Property Definitions), either an existing property or one created for this purpose. The property must also be of the True/False data type.

In the Datasheet Design window, remember to assign the picklist to the checkbox cell (see Assign a PickList to a Cell) as the picklist will not automatically be available for that field when mapped to a cell in a datasheet, even the picklist is assigned to that field in the Grid Manager.