Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Web
  [Expand]DevExpress.Web.ASPxGauges
  [Expand]DevExpress.Web.ASPxGauges.Base
  [Expand]DevExpress.Web.ASPxGauges.Scripts
  [Expand]DevExpress.Web.ASPxHtmlEditor
  [Expand]DevExpress.Web.ASPxHtmlEditor.Localization
  [Expand]DevExpress.Web.ASPxHtmlEditor.Scripts
  [Expand]DevExpress.Web.ASPxPivotGrid
  [Expand]DevExpress.Web.ASPxPivotGrid.Data
  [Expand]DevExpress.Web.ASPxPivotGrid.HtmlControls
  [Expand]DevExpress.Web.ASPxPivotGrid.Scripts
  [Expand]DevExpress.Web.ASPxRichEdit
  [Expand]DevExpress.Web.ASPxRichEdit.Localization
  [Expand]DevExpress.Web.ASPxRichEdit.Scripts
  [Expand]DevExpress.Web.ASPxScheduler
  [Expand]DevExpress.Web.ASPxScheduler.Commands.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Controls
  [Expand]DevExpress.Web.ASPxScheduler.Dialogs
  [Expand]DevExpress.Web.ASPxScheduler.Drawing
  [Expand]DevExpress.Web.ASPxScheduler.Localization
  [Expand]DevExpress.Web.ASPxScheduler.Reporting
  [Expand]DevExpress.Web.ASPxScheduler.Scripts
  [Expand]DevExpress.Web.ASPxSpellChecker
  [Expand]DevExpress.Web.ASPxSpellChecker.Localization
  [Expand]DevExpress.Web.ASPxSpellChecker.Scripts
  [Collapse]DevExpress.Web.ASPxSpreadsheet
   [Collapse]ASPxSpreadsheet Class
     ASPxSpreadsheet Members
     ASPxSpreadsheet Constructor
    [Expand]ASPxSpreadsheet Properties
    [Collapse]ASPxSpreadsheet Events
      Callback Event
      CellValueChanged Event
      DocumentCallback Event
      DocumentSelectorCloudProviderRequest Event
      DocumentSelectorFileUploading Event
      DocumentSelectorFolderCreating Event
      DocumentSelectorItemCopying Event
      DocumentSelectorItemDeleting Event
      DocumentSelectorItemMoving Event
      DocumentSelectorItemRenaming Event
      InitializeDocument Event
      Saving Event
    [Expand]ASPxSpreadsheet Methods
   [Expand]ASPxSpreadsheetLoadingPanelSettings Class
   [Expand]ASPxSpreadsheetSettingsBase Class
    InitializeDocumentEventHandler Delegate
    SaveFileDialogDisplaySectionMode Enumeration
   [Expand]SpreadsheetClientSideEvents Class
   [Expand]SpreadsheetDialogFormSettings Class
   [Expand]SpreadsheetDialogSettings Class
   [Expand]SpreadsheetDocumentSelectorCommonSettings Class
   [Expand]SpreadsheetDocumentSelectorSettings Class
   [Expand]SpreadsheetFileManagerCommonSettings Class
   [Expand]SpreadsheetFileManagerEditingSettings Class
   [Expand]SpreadsheetFileManagerFoldersSettings Class
   [Expand]SpreadsheetFileManagerUploadSettings Class
   [Expand]SpreadsheetFileManagerValidationSettings Class
   [Expand]SpreadsheetFormsSettings Class
   [Expand]SpreadsheetFormulaAutoCompeteStyles Class
   [Expand]SpreadsheetFormulaBarButtonImageProperties Class
   [Expand]SpreadsheetFormulaBarButtonSectionStyles Class
   [Expand]SpreadsheetFormulaBarStyles Class
   [Expand]SpreadsheetImages Class
   [Expand]SpreadsheetInitializeDocumentEventArgs Class
   [Expand]SpreadsheetInsertLinkDialogSettings Class
   [Expand]SpreadsheetInsertPictureDialogSettings Class
   [Expand]SpreadsheetRibbonContextTabCategoryCollection Class
    SpreadsheetRibbonMode Enumeration
   [Expand]SpreadsheetRibbonTabCollection Class
   [Expand]SpreadsheetSaveFileDialogSettings Class
   [Expand]WorksheetDisplayArea Class
  [Expand]DevExpress.Web.ASPxSpreadsheet.Localization
  [Expand]DevExpress.Web.ASPxSpreadsheet.Scripts
  [Expand]DevExpress.Web.ASPxTreeList
  [Expand]DevExpress.Web.ASPxTreeList.Internal
  [Expand]DevExpress.Web.ASPxTreeList.Localization
  [Expand]DevExpress.Web.ASPxTreeList.Scripts
  [Expand]DevExpress.Web.Captcha
  [Expand]DevExpress.Web.Data
  [Expand]DevExpress.Web.Internal
  [Expand]DevExpress.Web.Localization
  [Expand]DevExpress.Web.Mvc
  [Expand]DevExpress.Web.Mvc.BinderSettings
  [Expand]DevExpress.Web.Mvc.Controllers
  [Expand]DevExpress.Web.MVC.Scripts
  [Expand]DevExpress.Web.Mvc.UI
  [Expand]DevExpress.Web.Office
  [Expand]DevExpress.Web.Office.Internal
  [Expand]DevExpress.Web.Rendering
  [Expand]DevExpress.Web.Scripts
  [Expand]DevExpress.XtraCharts.Web
  [Expand]DevExpress.XtraCharts.Web.Designer
  [Expand]DevExpress.XtraCharts.Web.Scripts
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

ASPxSpreadsheet.CellValueChanged Event

Occurs after the cell content has been changed via the ASPxSpreadsheet UI.

Namespace:DevExpress.Web.ASPxSpreadsheet
Assembly:DevExpress.Web.ASPxSpreadsheet.v17.2.dll

Expanded Syntax

Expanded Event Data

The event handler receives an argument of type SpreadsheetCellEventArgs containing data related to this event.

Expanded Remarks

The CellValueChanged event fires after the cell content has been changed as a result of end-user interaction. The list below provides the possible reasons for this event being raised:

  • The cell content has been modified via the cell in-place editor or formula bar. The cell editor is closed and the entered value is committed to an active cell or selected cells when an end-user clicks outside the edited cell, or presses ENTER, CTRL+ENTER or CTRL+SHIFT+ENTER.

  • The cell content has been removed when an end-user pressed DELETE.

  • A new hyperlink has been added to a cell via the Insert Hyperlink dialog, or an existing hyperlink has been modified via the Change Hyperlink dialog.

The CellValueChanged event must have a static event handler and it raises for all documents opened within all instances of the ASPxSpreadsheet control. To identify a document for which the event was raised, use the event sender (of the SpreadsheetDocumentInfo type) containing the DocumentId property (OfficeDocumentBase<T>.DocumentId).

The code below demonstrates how a handler can be assigned to the CellValueChanged event in the Global.asax file's Application_Start method.

Note

By default, the CellValueChanged event does not occur when changing cell content via code. However, this event will also be triggered by changes made via an API if you set the RaiseEventsOnModificationsViaAPI property to true.

The CellValueChanged event does not occur when a cell value is changed after a formula has been recalculated, even if the recalculation has been caused by the ASPxSpreadsheet UI.

Expanded See Also

How would you rate this topic?​​​​​​​