Spread Designer
To specify the maximum number of rows when using virtual mode
In the Spread Designer,
- From the Book menu, choose Virtual Mode or press the Virtual Mode button (
) on the Book toolbar.
-
Type the number of rows in the Virtual Max Rows box under Settings as follows:
- If you know the exact number of rows in the sheet or bound database, specify that number.
- If you do not know the exact number of rows in the sheet or bound database, but would like the sheet to determine it once it has read all the rows, specify –1.
-
If you do not know the exact number of rows in the sheet or bound database, but would like to estimate it, overestimate the number rather than underestimating it.
If you underestimate the number, the sheet never reads the records past the value you assign.
- Choose the OK or Apply button.