Using Edit Mode

---

• Setting the Edit Mode
• Keeping Edit Mode Permanently On
• Replacing Text as You Edit
• Allowing Text to Overflow in 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.