Spread 8.0 Documentation
Book Settings
Support Options
User's Guide > Introduction to Spread > The Spread Designer > Understanding the Spread Designer Interface > Spread Designer Dialogs and Settings > Book Settings

Glossary Item Box

Book Settings


Several groups of properties that apply to multiple sheets and the entire control are available from the Books Settings dialog. These include the environment settings, the display settings, etc. and each are provided on an individual tab in this dialog. From the Book menu, select any of the options and the tab for that set of settings is displayed. Or click one of the buttons from the Book toolbar. For example, the Environment tab is shown in this figure.


For more information about the items in this dialog, move the focus to an item and press the F1 key, or see the following topics:

Settings Item Topic
Make Edit Mode Permanent Keeping Edit Mode Permanently On
Replace Existing Text Replacing Text as You Edit
Handle Clipboard Keys Turning Off the Clipboard Shortcut Keys
Use Arrow Keys to Exit Edit Using Arrow Keys to Move Between Cells
Retain Selected Block Hiding Selections When Not in Focus
Protect Locked Cells Locking the Sheet
Multiple Block Selections Selecting Multiple Blocks of Cells
Cell Overflow Allowing Cells to Overflow
Beep Off Turning Off the Control's Beep
Cell Drag Drop Allowing Users to Drag and Drop Cells
Hide Border Hiding Sheet Borders
Process Tab Key Using the Tab Key to Move Between Cells
Autosize On Displaying a Specified Number of Columns and Rows
On Focus Set Cell to Cursor Preventing Active Cell Change on Focus
Calculate Formulas Automatically Recalculating and Updating Formulas
Custom Formulas Allowing Users to Enter Formulas
Edit Overflow Allowing Text to Overflow in Edit Mode
Formula Sync Automatically Recalculating and Updating Formulas
Clipboard Options Copying Data Using the Clipboard
Moving Data Using the Clipboard
Pivot Year Creating and Setting up a Date Cell
Note Indicator Providing Cell Notes
HighlightStyle Customizing the Appearance
Note Shape Providing Cell Notes
HighlightHeaders Customizing the Appearance

For information on other book-level settings, refer to Book Default Settings and Book Display Settings.

Return to Spread Designer Dialogs and Settings.

Copyright © GrapeCity, inc. All rights reserved.