Spread Windows Forms 10.0 Product Documentation
EditModePermanent Property (SpreadView)
Example 


Gets or sets whether edit mode remains on for any cell in the view when that cell becomes active.
Syntax
'Declaration
 
Public Property EditModePermanent As Boolean
'Usage
 
Dim instance As SpreadView
Dim value As Boolean
 
instance.EditModePermanent = value
 
value = instance.EditModePermanent
public bool EditModePermanent {get; set;}

Property Value

Boolean: true if the cell immediately goes to edit mode; false otherwise
Remarks

If this property is set to true, when any cell in the spreadsheet becomes the active cell, it immediately enters edit mode. In effect, setting this property to true creates a spreadsheet with cells that do not display the focus rectangle. You can use this option to emulate a table of editor controls.

When this property is set to true, every time you move the active cell, the EditMode event occurs twice: when you leave the current active cell and when you move to the new active cell.

When edit mode is on, no selections are possible. Refer to Hiding Selection and Focus Rectangle.

Note: Setting this property to true automatically sets the SelectionBlockOptions property to 0. If you then set this property to false, you must reset the SelectionBlockOptions property to its original setting.

Tip: If you set this property to true, you might want to set the EditModeReplace 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 EditModePermanent property.
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.EditModePermanent = true;
Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.EditModePermanent = 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

See Also

Reference

SpreadView Class
SpreadView Members
EditModeReplace Property
SelectionBlockOptions Property

User-Task Documentation

Understanding Edit Mode

 

 


Copyright © GrapeCity, inc. All rights reserved.