Setting Up the Control
Customizing the Control
- Setting Measurement Units
- Preventing Flickering
- Setting the Gray Area Color
- Working with the Control and Sheet Borders
- Specifying Which Elements Users Can Select
- Hiding Selections When Not in Focus
- Resetting the Control to its Default Settings
Customizing Interaction with the Control
- Allowing Users to Drag and Drop Cells
- Customizing Scroll Bars
- Specifying the Pointer
- Turning Off the Control's Beep
- Customizing Navigation
- Using Arrow Keys to Move Between Cells
- Turning Off the Clipboard Shortcut Keys
- Changing or Turning Off the Action Keys
- Specifying When Buttons Appear
- Providing Text Tips
Working with Sheets
- Adding Sheets
- Deleting Sheets
- Setting Sheet Names
- Customizing the Tab Strip
- Customizing Grid Lines
- Resetting a Sheet to its Default Settings
- Monitoring Data Changes in the Sheet
- Specifying the Operation Mode
- Using Virtual Mode
Customizing Columns and Rows
- Inserting Columns and Rows
- Deleting Columns and Rows
- Copying, Moving, and Swapping Columns and Rows
- Providing Column IDs
- Sizing Columns and Rows
- Preventing Resizing of Columns and Rows with the Mouse
- Setting the Maximum Number of Columns and Rows
- Displaying a Specified Number of Columns and Rows
- Designating the Leftmost Column to Display
- Designating the Top Row to Display
- Hiding Columns and Rows
- Freezing Columns and Rows
- Specifying Where the Last Column and Row Stop Scrolling
- Setting Odd and Even Row Colors
Customizing Headers
- Providing Multiple Headers
- Specifying Header Content
- Hiding the Column and Row Headers
- Setting the Header Three-Dimensional Appearance
- Setting the Header Shadow Color
- Setting the Header Background and Text Colors
Working with Cells
- Working with the Active Cell
- Providing Cell Tags
- Working with a Range of Cells
- Selecting Multiple Blocks of Cells
- Locking Cells
- Resizing Cells
- Spanning Cells
- Merging Cells
- Allowing Cells to Overflow
- Displaying an Ellipsis to Indicate More Text
- Using Edit Mode
- Customizing Cell Borders
- Setting Cell Background and Text Colors
- Setting the Font
- Specifying the Colors of Selected Cells
- Providing Cell Notes
Setting the Cell Type
- Creating Button Cells
- Creating Check Box Cells
- Creating Combo Box Cells
- Creating Currency Cells
- Creating Custom Cells
- Creating Date Cells
- Creating Edit Cells
- Creating Number Cells
- Creating Owner-Drawn Cells
- Creating Percent Cells
- Creating Mask (PIC) Cells
- Creating Picture Cells
- Creating Scientific Notation Cells
- Creating Static Text (Label) Cells
- Creating Time Cells