Controlling How Many Rows are Visible in a Spreadsheet Dialog

By default, when displaying a spreadsheet dialog, HotDocs always shows 10 rows of the spreadsheet. If you need to show more or less than this number of rows, you can enter a specific number at the Dialog Editor.

To change the number of viewable rows in a spreadsheet

1. In Component Studio, open the dialog component.
2. Click the Repetition drop-down button; then choose Spreadsheet.
3. In the Contents tab, in the Rows to display field, either type a number, or click the up or down arrows to select a number.

This feature only alters the amount of spreadsheet rows displayed in the interview and will not stop the user from entering information in further rows. The user can view the additional rows by using the scroll bar on the spreadsheet. To limit the amount of rows that the user can create you can use the LIMIT instruction.