Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

#NOENTRY

In FORM templates the program will evaluate which cells that 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:

ENTRYmenu

NOENTRY

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

NOENTRY2

Published:

#NOENTRY

In FORM templates the program will evaluate which cells that 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:

ENTRYmenu

NOENTRY

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

NOENTRY2

For an optimal Community experience, Please view on Desktop
Powered by Zendesk