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

#ENTRY

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).

Note: If a cell meets one of the above rules but contains a formula, then that cell will also be locked. To override, enter #ENTRY in that cell. This enables the end-user to make changes to a cell that contains a formula.

Caution: If #ENTRY is used in many individual cells it will affect the performance of the book.

To override the rule that all other cells are locked, a cell comment can be inserted in the particular cell that should be open for entry. When the form is generated this comment will make the cell open for entry, even though it does not meet the above rules. In addition, the cell comment will not be visible in the generated document.

The cell I26 does not meet the above rules and will therefore automatically be locked when generating the form. To override the rule, add a comment in the cell with the text #ENTRY, or from Bizview version 5.0, mark the cells and then use the menu item to add #ENTRY in selected cells:

ENTRYmenu

ENTRY

When the template is saved and opened in template design again, the cells containing a command will be visible with an orange triangle in the bottom-left corner. Select the mark and the following dialog displays. Using this dialog, the comment can be removed, or another command can be added:

ENTRY2

The expanded rows in column I is open for entry even though they do not meet the rules above. No comment is visible for the end-user.

ENTRY3

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

#ENTRY

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).

Note: If a cell meets one of the above rules but contains a formula, then that cell will also be locked. To override, enter #ENTRY in that cell. This enables the end-user to make changes to a cell that contains a formula.

Caution: If #ENTRY is used in many individual cells it will affect the performance of the book.

To override the rule that all other cells are locked, a cell comment can be inserted in the particular cell that should be open for entry. When the form is generated this comment will make the cell open for entry, even though it does not meet the above rules. In addition, the cell comment will not be visible in the generated document.

The cell I26 does not meet the above rules and will therefore automatically be locked when generating the form. To override the rule, add a comment in the cell with the text #ENTRY, or from Bizview version 5.0, mark the cells and then use the menu item to add #ENTRY in selected cells:

ENTRYmenu

ENTRY

When the template is saved and opened in template design again, the cells containing a command will be visible with an orange triangle in the bottom-left corner. Select the mark and the following dialog displays. Using this dialog, the comment can be removed, or another command can be added:

ENTRY2

The expanded rows in column I is open for entry even though they do not meet the rules above. No comment is visible for the end-user.

ENTRY3

For information about how to apply a rule or condition that must be satisfied for cell entry in a form, see #CONDITIONALENTRY.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk