SpreadsheetGear 2023
RangeChanged Event (WorkbookView)


SpreadsheetGear.Windows.Controls Namespace > WorkbookView Class : RangeChanged Event
Occurs sometime after an SpreadsheetGear.IRange property setter or method changes one or more of the cells in the range.
Syntax
'Declaration
 
<System.ComponentModel.CategoryAttribute("Data")>
<System.ComponentModel.DescriptionAttribute("Occurs when a range changes.")>
Public Event RangeChanged As RangeChangedEventHandler
'Usage
 
Dim instance As WorkbookView
Dim handler As RangeChangedEventHandler
 
AddHandler instance.RangeChanged, handler
[System.ComponentModel.Category("Data")]
[System.ComponentModel.Description("Occurs when a range changes.")]
public event RangeChangedEventHandler RangeChanged
Event Data

The event handler receives an argument of type RangeChangedEventArgs containing data related to this event. The following RangeChangedEventArgs properties provide information specific to this event.

PropertyDescription
Returns the range that was changed.  
Remarks

It is important to note that some actions, such as insert or delete, will change cells outside of the range, and possibly even modify formulas in other worksheets or workbooks.

The RangeChanged event is always invoked on the thread which created the workbook view control, and a lock is always acquired on the workbook set associated with the workbook view control before RangeChanged is invoked.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also