Spread 8.0 Documentation
Using Edit Mode
Support Options
User's Guide > Setting Up the Control > Working with Cells > Using Edit Mode

Glossary Item Box

Using Edit Mode


Overview

When the user enters data in a cell in the sheet or double clicks a cell, the sheet automatically turns edit mode on. When the user moves from the cell, the sheet automatically turns edit mode off. If edit mode is on, the active cell is the cell being edited.

Notes:
  • Picture cells, static text cells, and locked cells cannot be edited.
  • For ActiveX users, the EditMode event with the Mode parameter set to 1 (True), is sent to the application each time the sheet turns edit mode on. The EditMode event, with the Mode parameter set to 0 (False), is sent to the application each time the sheet turns edit mode off. An application might want to know when the user leaves edit mode so that validation can be performed on the data.
  • For DLL users, the fpSpread control sends its owner the SSM_EDITMODEON message when the sheet turns edit mode on, and it sends the SSM_EDITMODEOFF message when the sheet turns edit mode off. An application might want to know when the user leaves edit mode so that validation can be performed on the data.

You can tell the sheet to turn edit mode on or off using code. If you prefer, you can turn edit mode on all the time. In addition, you can specify what happens to existing text in the cell when the sheet turns edit mode on. You can specify whether data overflows into adjacent empty cells while edit mode is on in a cell.

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.