EditModeReplace Property (SpreadView)

Gets or sets whether the existing text in a cell in the view is selected when the cell enters edit mode.

Syntax

Visual Basic
C#

'Declaration
 
Public Property EditModeReplace As Boolean

'Usage
 
Dim instance As SpreadView
Dim value As Boolean
 
instance.EditModeReplace = value
 
value = instance.EditModeReplace

public bool EditModeReplace {get; set;}

Property Value

Boolean: true if the text in an edit cell is not selected when the cell enters edit mode; false otherwise

Remarks

When this property is set to true, when a cell in the spreadsheet enters edit mode, the existing text in the cell is selected. Then, if users start typing, their text replaces the existing text. When this property is set to false, the cursor is placed at the end of the existing text when the cell enters edit mode; new characters are appended to the existing text.

Note: If you set the EditModePermanent property to true, you might want to set this property to false to prevent users from accidentally deleting their data.

For a discussion of edit mode and related properties, refer to Understanding Edit Mode.

Example

This example sets the EditModeReplace property.

FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.EditModeReplace = true;

VB.NET

Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.EditModeReplace = True

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SpreadView Class
SpreadView Members
EditModePermanent Property

User-Task Documentation

Understanding Edit Mode