Using Design Versus Run-Time Mode
Overview
In the Spread Designer you can be in either design mode or run-time mode. By default, when you start the Spread Designer you are operating in design mode.
In design mode, the "design" spreadsheet displays in a format where certain properties are temporarily reset to values that optimize the spreadsheet design process. For example, if you hide a row, it will still display in the Spread Designer and you can still work with that row.
The following table shows the properties that are temporarily reset while in design mode.
Property | Setting while in design mode |
---|---|
AllowDragDrop | True |
AllowMultiBlocks | True |
AllowUserFormulas | True |
AutoClipboard | True |
ColHeadersShow | True |
Lock | True |
MoveActiveOnFocus | True |
OperationMode | SS_OP_MODE_NORMAL |
Protect | False |
RetainSelBlock | True |
RowHeadersShow | True |
ScrollBars | SS_SCROLLBAR_BOTH |
SelectBlockOptions | SS_SELBLOCKOPT_BLOCKS | SS_SELBLOCKOPT_COLS | SS_SELBLOCKOPT_ROWS | SS_SELBLOCKOPT_ALL |
UserResize | SS_USER_RESIZE_COL | SS_USER_RESIZE_ROW |
UserResizeCol | SS_USER_RESIZE_DEFAULT |
UserResizeRow | SS_USER_RESIZE_DEFAULT |
VisibleCols | 0 |
VisibleRows | 0 |
In run-time mode, the spreadsheet you are working with displays in a format where all properties you have set using the Spread Designer, both design-time and run-time, are applied as they are currently set. For example, if you hide a row, it will not display in the Spread Designer and you cannot work with that row.
You can switch between design and run-time modes. When you switch to run-time mode, the spreadsheet reflects the original property settings. Design mode does not permanently change the property values you have set.
The status bar displays the mode status.
Return to the overview of Understanding Designer Modes.