#NOENTRY

In FORM templates the program will evaluate which cells should be locked or open for entry when the document is generated.

Program rules for open cells in a FORM:

• All cells with DATA in column A and CVAL in row 1
• All cells with DATA in column A and a data attribute in row 1
• All cells with DATA in column A and SPVAL, SPKEY and/or SPLIM in row 1

All other cells will be locked for editing when the FORM document is generated (in a REPORT document all cells will be locked at all times).

To override the rule that some cells are open, a cell comment can be inserted in the particular cell to locked it from entry. When the form is generated this comment will make the cell locked, even though it meets the above rules. In addition, the cell comment will not be visible in the generated document.

The cell Z26 meets the above rules and will therefore automatically be open when generating the form. To override the rule, add a comment in the cell with the text #NOENTRY or from Bizview version 5.0 mark the cells and then use the menu item to add #NOENTRY in selected cells:

The expanded rows in column Z is locked for entry even they meet the rules above. No comment is visible for the end-user.

For information about how to apply a rule or condition that must be satisfied for cell entry in a form, see #CONDITIONALNOENTRY.