Devexpress Gridview Cell Value Changed Event

This cell can be located using its row and column indexes. ApplyFilterToColumn method. The first interesting thing to realize is that editing is actually active by default in the grid. CommitEdit method and pass in the Commit value. BatchEditStartEditing event, which is raised when a cell starts to be edited and the ASPxClientGridView. Please review the following example, which should be helpful: How to update a row's style immediately after a an inplace editor's value is changed. When used, all changes made within the DataGrid are transmitted to the data source immediately. The GridView control raises the Sorting event when a Sort button (a button with its CommandName property set to "Sort") is clicked, but before the GridView control handles the sort operation. Selection Changed Event column whenever the value of any cell changes. Constantly evolving—no other datagrid is updated as often—it has more features than any other offering and a flexible, extensible object model. Set the SettingsEditing. GetAutoFilterEditor(column) Returns the editor used to edit the value in the auto filter row for the specified data column. SwitchColumn. Devexpress Gridview Cell Value Changed Event. DashboardItemControlUpdated event handler. Note that before that, you should locate the row (card) and column (card field) in which the cell resides. Apr 08, 2019; 2 min to read; This example demonstrates how to use the Range. Cell value changed event(?) in DataGrid on "ofyourData" in that case if any data is been changed in grid this will fireup. I am using a DevExpress. The first interesting thing to realize is that editing is actually active by default in the grid. In the event handler, a filter criteria is created and applied to the grid using the ASPxGridView. GridView - Auto Filter Row allows you to type a value of an invalid type in EF server mode; GridView - Cells are merged incorrectly when exporting a grouped view to Excel; GridView - SVG icons are hidden in the focused row when the Cell Merging feature is enabled. I'd like to have an event fired when the value of that column is edited, so to trigger some operations. The RowCellClick event does not fire when a user clicks on a row cell if Grid data is editable and the ColumnViewOptionsBehavior. The DevExpress ASP. Now, the GridView is bound to a List of objects. The editor will be invoked and its contents will be replaced with the pressed character. Mode property to 'Batch' to enable batch edit mode. GetClientVisible: Obsolete. Need the value of cell of the row on which user double click on RadGrid How to get the values from Access Database and set in Gridview in C# winforms Devexpress? How to show records on cell double click event in datagrid view to new winform using datagrid view?. The CellValueChanged event fires on the server side after a cell's content has been changed as a result of end-user interaction. I have a gridview, Which I am editing. SwitchColumn. DevExpress MVC Extensions ship as part of DevExpress Universal, DXperience and ASP. NET Subscriptions and are backed by a 60 day unconditional money-back guarantee. The last parameter is a boolean value which tells the method whether to execute an Insert (false) or Update (true). To set the focus on a particular record of a DevExpress GridView we have to set theFocusedRowHandle property. GridViewDataCheckColumn changes are not displayed in the command column, but are displayed in the preview changes panel It's not possible to add a new row in Batch Edit mode in IE9 BootstrapGridView - It's not possible to scroll the grid to the required row with the ScrollToVisibleIndexOnClient property and the MakeRowVisible method in a. I suppose that you are using ASPxGridView in Batch edit mode. If the value is A then it is set to Absent and if the value is P then it is set to Present. Cookies store useful information on your computer to help us improve the efficiency and relevance of our site for you. Note that before that, you should locate the row (card) and column (card field) in which the cell resides. SetRowCellValue is void method! To get the focused row and previous row, you have to handle the gridview. Let's say you want to change color of GridView's cell depending of value. cancel = true. NET Spreadsheet enables you to execute custom server code in response to a sheet cell value change. DevExpress control, when the Table relationships, sub table shows the Grid settings, display a default Grid is not set, but the column header name for the data source column name need to change the column header description must write a custom Grid, step:. Mode property to 'Batch' to enable batch edit mode. each application requiring an unique postgresql database and thus a different connection pool for each database. FocusEditor(column) Moves focus to the specified edit cell within the edited row. Change Cell Value In Gridview Devexpress. Option 1 – Format with the Text Function. This Blog demonstrates the events of DevExpress GridView Control. Source: Gets the grid that raised the event. This example demonstrates how easy it is to programmatically add data of different types to worksheet cells. This article explains how to get a row's cell value from a Grid View of a checked CheckBox in ASP. InvalidRowException - similarly to per-cell validation, these events allow you to validate new cell values and respond to invalid ones. Otherwise the event should fire. A changed font with the ASCII/High/Complex Script/East Asian content type specified is incorrectly written in a run in the saved. This results in a ListView that acts very much like the WPF ListBox, with some subtle differences. setCellValue is set individually for each column. Do one of the following: Click a cell. C# code fo formatting cells background as following. ListView with a GridView In the previous ListView articles, we have used the most basic version of the WPF ListView, which is the one without a custom View specified. The CellValueChanged event fires on the server side after a cell's content has been changed as a result of end-user interaction. So, our formula is formatting the value in cell B10 based on the VLOOKUP value returned from cells B4-C5. Is available a functionality for gridview to raise single event when cell is focused? The problem is that now I have 2 events: FocusedRowChanged and FocusedColumnChanged events, but I need only one (e. Source: Gets the grid that raised the event. All user changes are maintained on the client side until the Save cha. SetCellValue method. I want to assign a BandedGridView object to a grid's main view dynamically according to my columns count with VB code. Mode property to 'Batch' to enable batch edit mode. In many situations we want to bind a fully, in-place operational GridView with a dynamically changing data source. ValidateRow, ColumnView. Regards, Andrew. Note that standard processing is deactivated at the end of the code snippet by setting e. SelectionChanged event is also raised. Note that before that, you should locate the row (card) and column (card field) in which the cell resides. Within this event handler, you can implement validation logic and set a valid value for a cell. Change number format based on a cells value Posted on June 12, 2017 December 28, 2018 by Excel Off The Grid Imagine a situation where you have built a dynamic report or dashboard that you a really proud of. Focus: Sets input focus to the grid. NumberColumn. In the handler, if the current cell is a check box cell, call the DataGridView. Text returns an empty Value of cell in gridview is empty (using RowDataBound event). ValidateRow, ColumnView. This example demonstrates how easy it is to programmatically add data of different types to worksheet cells. To catch the moment when an end-user changes some value in its cell, please handle the EditValueChanged event of a corresponding RepositoryItem. The GridView control raises the Sorting event when a Sort button (a button with its CommandName property set to "Sort") is clicked, but before the GridView control handles the sort operation. Indicates that you should save the current value of the unbound column's cell to a data source in the event handler. gridview goes to normal mode(I mean not in the edit mode). How to: Change a Cell or Cell Range Value. GetAutoFilterEditor(column) Returns the editor used to edit the value in the auto filter row for the specified data column. Mode property to 'Batch' to enable batch edit mode. Cookies Support - the ASPxGridView control fully supports cookies that allow your site's visitors to personalize pages. Hi I would like to retrieve the value of a cell in my gridview, but all the text values are always empty! Im using the following code: But always the line of e. If the selection includes full rows, the Selector. Hello, is it possible to draw lines of different kinds (size, color, brush) in a devexpress grid cell ? thanx Use tableview's oncustomdrawcell event. Below is an example of a GridView showing student details, in which we want to show the Customized Summary value of the […]. NET Subscriptions and are backed by a 60 day unconditional money-back guarantee. Now, the GridView is bound to a List of objects. RowData: Gets an object that contains information on the currently processed row. Devexpress Gridview Cell Value Changed Event. Recommend:move Rows up and down or change row color if the row cell value are the same gridview devexpress winforms c#. React Grid - Editing. This article shows how GridView can be templated programmatically at run time and how is it possible to do edit, insert and delete operations on it. Focus: Sets input focus to the grid. The editor will be invoked and its contents will be replaced with the pressed character. Available if parentType is "filterRow" or "searchPanel". This event is available in the Data Grid and TreeList controls. Gets and sets the delay between the moment a user stops typing a filter value and the moment it is applied. and you can trap what got changed. The cellValue (rowIndex, visibleColumnIndex, value) method updates a cell's value. XtraGrid – Embed Editors into Grid Cells In this lesson, I’ll demonstrate how to assign the in-place editors supplied in the XtraEditors library to Grid Columns and Card fields. Usability - There is no API to get a cell range from which the series name is retrieved. The event doesn't fire when a cell's value is changed using the methods provided by the data source. My goal is to provide a master/slave db server using a passive slave for redundancy. By accessing this site, you consent to the use of cookies. If the value is A then it is set to Absent and if the value is P then it is set to Present. My data shown by DevExpress GridControl in my Vb. I have a GridView and inside it is a checkbox. A grid column used to display and edit date values. NET GridView ? please look at the scenario explained [Answered] RSS 4 replies Last post Jun 19, 2014 11:32 PM by Kevin Shen - MSFT. GridView Row Edit, Delete and Update « Devils WorkMar 27, 2009 … Hi, i can't filter yet the gridview with dropdownlist, i think what the razon is the (! IsPostBack) for binding the gridview(it's have rowupdating and …. Value property of a cell or range object. New events give programmers control over how the data grid reacts when the current visual row is changing or has changed, and allows the change to be canceled in certain situations. The CellValueEventArgs. value is not good , I want show user a message like "the value you enter is not good " , then I need the value auto changed back to old value and prevent the cellvaluechanged event happend. Value property to add data of different types to worksheet cells. FocusedCellChanged, may be fired after FocusedRowChanged and FocusedColumnChanged events). This cell can be located using its row and column indexes. As the image shows, this feature can be very useful when your data changes frequently and the Data Grid is bound to a RealTimeSource. ValueChanged client-side event is used to send a callback to the server side, invoking the grid's ASPxGridView. Based on value of Weight, Rate , CNF & AWB it will change the value of Freight , TTLCNF anfd TTLFright. Item whcih is our bound DataRowView. SwitchColumn. A grid column used to display and edit date values. makes no sense, because you dont set the value of the TextEdit, just the value of the Cell. In this example, you can switch a grid cell into edit mode by clicking it. I am using a DevExpress. Introduce a collection to store GridCell class (it is our class that has the RowHandle and Column properties) instances and populate it when a cell value is changed. For example, if the user change the value of Row2Column1 to 3, then Row2Column3 = Row2Column2 * Row2Column1 after TextChange event. Addition Two Textbox value by Java script On keyDown Event in Gridview Devexpress gridcontrol sum of row cell values in specific column cell How to add rows in devexpress GridControl just like we add rows in a normal datagridview. Should you have any further questions, feel free to. Check whether a. For this purpose, the Spreadsheet provides the CellValueChanged event. The DevExpress ASP. For instance, you can define a rule to fill cells with a color depending on the cell value in relation to the value range of the bound field. If the cell's data field is known, you can pass it instead of the column index. I want to use JavaScript TextChange(onChange) event to change the value of a cell in GridView. cs (VB: Form1. InvalidRowException - similarly to per-cell validation, these events allow you to validate new cell values and respond to invalid ones. I have Gridview and I want to set click Event on the all cells in a Row ? How to Complete my Task ?? I tried this code but when i double click on the cell the new Form will come in Back / Behind of current Form. ValueChanged client-side event is used to send a callback to the server side, invoking the grid's ASPxGridView. It also provides unbeatable performance by handling millions of rows and thousands of columns, and integrates easily into any WPF app. The cellValue (rowIndex, visibleColumnIndex, value) method updates a cell's value. For instance, you can define a rule to fill cells with a color depending on the cell value in relation to the value range of the bound field. NET Subscriptions and are backed by a 60 day unconditional money-back guarantee. void dataGridView1_CellClick_1(object sender,. In this mode, an end user uses in-line editors to edit grid data. The example works with the GridTutorials demo application that comes with the Developer Express XtraGrid Suite. Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. updateValueTimeout: Number. It is impossible to use the FindCell method in the CustomFieldValueCells event to remove multiple cells. This cell can be located using its row and column indexes. makes no sense, because you dont set the value of the TextEdit, just the value of the Cell. This problem was also raised in a StackOverflow Question which seemed to advocate for handling the MouseUp event on the DataGridView and then call the EndEdit method, thereby ensuring that the grid would evaluate whether or not the Cell's value had, indeed, changed and fire the corresponding event appropriately I must admit, this works, but. A grid column used to display and edit date values. In our circumstance, Cell B5, which has a value of 1,000,000 is the closest value below B10,. How to: Change a Cell or Cell Range Value. Technically you can run the export functionality at any point, but if you use this event you can take advantage of the standard Export button supported by the Data Grid. In addition, you can also select multiple grid records and click the «Delete Selected Records» button. The GridView control raises the Sorting event when a Sort button (a button with its CommandName property set to "Sort") is clicked, but before the GridView control handles the sort operation. Refer to the Demos and Sample Applications topic to learn more. NumberColumn. The CellValueChanged event fires when: a user has changed the in-place editor's value and now closes this editor; the SetRowCellValue method or other Grid API was used to change a cell value in code. Get the Cell Value From GridView in C# to explain about GridView and other events in it, because there are a lot of good articles about that. Devexpress Gridview Cell Value Changed Event. I need to get cell id and value, How can we get? protected void GridCellChanged(object sender, EventArgs e) {//Get Changed. When used, all changes made within the DataGrid are transmitted to the data source immediately. The example below will highlight the values in the first column when the value in the check box column returns true. Consider the following picture I get the selected row values in the three textboxes shown in the figure when i click a cell using following code. For example, if the user change the value of Row2Column1 to 3, then Row2Column3 = Row2Column2 * Row2Column1 after TextChange event. ImageColumn. So if you bind the grid before the event being called. Gets and sets the delay between the moment a user stops typing a filter value and the moment it is applied. The DevExpress ASP. ApplyFilterToColumn method. void dataGridView1_CellClick_1(object sender,. cancel = true. DashboardItemControlUpdated event handler. How to: Change a Cell or Cell Range Value. each application requiring an unique postgresql database and thus a different connection pool for each database. 6m developers to have your questions answered on Change cellvalue when other cell is changed of UI for WinForms GridView. NET Spreadsheet enables you to execute custom server code in response to a sheet cell value change. Explanation : 1. C# code fo formatting cells background as following. Inside the OnRowDataBound event handler of the GridView, the Cell value is compared with different quantity ranges and based on the following quantity range values, the background color of the GridView Row will change. How to change background color of a cell in Devexpress Grid when i click select them? If this is your first visit, be sure to check out the FAQ by clicking the link above. Indicates that you should save the current value of the unbound column's cell to a data source in the event handler. New here? Start with our free trials. The CellValueChanged event is not fired when a cell's value is changed using the methods provided by a data source. The CellValueChanged event fires on the server side after a cell's content has been changed as a result of end-user interaction. For more information, please see the following KB article: How to put an image in a grid cell. The DevExpress ASP. The last parameter is a boolean value which tells the method whether to execute an Insert (false) or Update (true). We can get the RowHandle of the GridView by passing the primary key value. By accessing this site, you consent to the use of cookies. Devexpress Gridview Cell Value Changed Event. ApplyFilterToColumn method. I think this is best practice because you are working with your DataSource and not with GridView directly. If new cell values do not pass validation, end-users are kept on the current row to either correct all errors, or press Esc and undo the changes. This background color formatting will be based on the values of the grid data cells in the same row but different columns. Once in edit mode, cell values can be modified by using the appropriate DevExtreme cell editor (for instance, a drop-down calendar is used to edit date values). When used, all changes made within the DataGrid are transmitted to the data source immediately. You can manage the editing state and edit data programmatically. The CellValueChanged event fires on the server side after a cell's content has been changed as a result of end-user interaction. Nevertheless, the end user can't edit anything unless one setting is changed: the property NavigationStyle on the View must be changed to CellNavigation (by default it's RowNavigation). All demos ship with full source code and are included in the DevExpress MVC distribution. Set the SettingsEditing. The DataGrid widget ships with «in-cell» editing capabilities. Value: Gets or sets a value of the unbound column's cell. Getting Started and Ongoing Feedback. Value property of a cell or range object. XtraGrid – Embed Editors into Grid Cells In this lesson, I’ll demonstrate how to assign the in-place editors supplied in the XtraEditors library to Grid Columns and Card fields. This problem was also raised in a StackOverflow Question which seemed to advocate for handling the MouseUp event on the DataGridView and then call the EndEdit method, thereby ensuring that the grid would evaluate whether or not the Cell’s value had, indeed, changed and fire the corresponding event appropriately I must admit, this works, but. Search Components, Applications, Add-ins and Cloud Services. Getting Started and Ongoing Feedback. Refer to the Demos and Sample Applications topic to learn more. DevExpress control, when the Table relationships, sub table shows the Grid settings, display a default Grid is not set, but the column header name for the data source column name need to change the column header description must write a custom Grid, step:. updateValueTimeout: Number. Should you have any further questions, feel free to. CommitOnValueChanged attached property. In addition to edited cell values, it allows you to get the cell values before user edits. Please review the following example, which should be helpful: How to update a row's style immediately after a an inplace editor's value is changed. Change number format based on a cells value Posted on June 12, 2017 December 28, 2018 by Excel Off The Grid Imagine a situation where you have built a dynamic report or dashboard that you a really proud of. value: any: The editor's. The DevExpress ASP. Net Gridview How to set the color of cell in devexpress xtragrid not based on cell value. The background color of the chart's pane is changed in the DashboardViewer. 1, some format rules can be animated. NET Subscriptions and are backed by a 60 day unconditional money-back guarantee. The CellValueChanged event fires on the server side after a cell's content has been changed as a result of end-user interaction. To enable editing, the editing | mode field is set to "row". It is impossible to use the FindCell method in the CustomFieldValueCells event to remove multiple cells. This example shows how to update GridControl's data source right after a cell editor value has been changed. value: any: The editor's. ag-Grid is feature rich datagrid designed for the major JavaScript Frameworks. Thus, changes will be accepted without changing focus, and the CellValueChaned event will fire. BatchEditStartEditing event, which is raised when a cell starts to be edited and the ASPxClientGridView. Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. Change number format based on a cells value Posted on June 12, 2017 December 28, 2018 by Excel Off The Grid Imagine a situation where you have built a dynamic report or dashboard that you a really proud of. I suppose that you are using ASPxGridView in Batch edit mode. Hi All, I have the below to assign a value to cell in gridview on the rowediting event which I am not sucessfull. The editing state contains information about rows and cells being edited, and rows that have been created or deleted but not yet committed. I need to get cell id and value, How can we get? protected void GridCellChanged(object sender, EventArgs e) {//Get Changed. If user enter in TxtPrice then I need to caculate, Total Price. This example demonstrates how you can display icons in grid cells. Focus a cell and click the Navigator control's Edit button:. These events are executed on the client side and have been engineered to maximize performance. Assiging a value to this property. # re: GridView Insert, Edit, Update and Delete - The Ado. Value: Gets or sets a value of the unbound column's cell. Performance degradation with a big number of pivot grid fields and complex hierarchies in Legacy data processing mode. The CellValueChanged event fires when: a user has changed the in-place editor's value and now closes this editor; the SetRowCellValue method or other Grid API was used to change a cell value in code. Now, I click into the checkbox cell, changing the ToggleState of the checkbox, but do not leave the cell by clicking on a different row. Set the SettingsEditing. Hi , I have handle the gridview_CellValueChanging and in the event , I detect , if e. STEP 5: Adding New Data in GridView. If the cell's data field is known, you can pass it instead of the column index. InvalidRowException - similarly to per-cell validation, these events allow you to validate new cell values and respond to invalid ones. Introduce a collection to store GridCell class (it is our class that has the RowHandle and Column properties) instances and populate it when a cell value is changed. CustomCallback event. How to: Change a Cell or Cell Range Value. In addition, you can also select multiple grid records and click the «Delete Selected Records» button. GridControl supports single row selection,multiple row selection and multiple cell selection modes. NET Spreadsheet control (ASPxSpreadsheet) enables you to execute custom server code in response to a sheet cell value change. New events give programmers control over how the data grid reacts when the current visual row is changing or has changed, and allows the change to be canceled in certain situations. and you can trap what got changed. The event does not fire when a cell value changes on a data source level. Exports a grid data to a file in the specified format. I have Gridview and I want to set click Event on the all cells in a Row ? How to Complete my Task ?? I tried this code but when i double click on the cell the new Form will come in Back / Behind of current Form. The trigger point is an event handler for the onExporting event. The CellValueEventArgs. Devexpress Gridview Cell Value Changed Event. This event fires up after editing the field and clicking outside the field BUT it does not return the new value but the old value. ValueChanged client-side event is used to send a callback to the server side, invoking the grid's ASPxGridView. The DevExpress ASP. FocusedRowHandle :Specifies the focused row's handle. I have datatable with unknown columns count in my form (data comes from Pivot table in SQL). See our Single Data Row Selection online demo. For example, if cell value is larger than 10 then background color should be red. A View raises the CellValueChanged event after a cell's value has been changed: An end user has changed a cell's value and closed its in-place editor. NET Grid exposes a rich set of client-side events. cancel = true. NumberColumn. RowData: Gets an object that contains information on the currently processed row. Devexpress Gridview Cell Value Changed Event. Hi All, I have the below to assign a value to cell in gridview on the rowediting event which I am not sucessfull. NET Spreadsheet enables you to execute custom server code in response to a sheet cell value change. ApplyFilterToColumn method. Exports a grid data to a file in the specified format. A View raises the CellValueChanged event after a cell's value has been changed: An end user has changed a cell's value and closed its in-place editor. Mode property to 'Batch' to enable batch edit mode. All user changes are maintained on the client side until the Save cha. I have added a event GridCellChanged on OnTextChanged. In this mode, an end user uses in-line editors to edit grid data. For example, if the user change the value of Row2Column1 to 3, then Row2Column3 = Row2Column2 * Row2Column1 after TextChange event. The best place for it is the ColumnView. New here? Start with our free trials. BeginUpdate - Workbook. CommitEdit method and pass in the Commit value. This enables you to provide an event-handling method that performs a custom routine, such as updating a status label with the currently selected row, whenever this event occurs. ValueChanged client-side event is used to send a callback to the server side, invoking the grid's ASPxGridView. In this example, you can switch a grid cell into edit mode by clicking it. The BindingList got the Event ListChanged. Once in edit mode, cell values can be modified by using the appropriate DevExtreme cell editor (for instance, a drop-down calendar is used to edit date values). XtraBars Suite. Devexpress Gridview Cell Value Changed Event. This background color formatting will be based on the values of the grid data cells in the same row but different columns. Option 1 – Format with the Text Function. For instance, you can define a rule to fill cells with a color depending on the cell value in relation to the value range of the bound field. The control's ASPxClientEdit. The CellValueChanged event fires on the server side after a cell's content has been changed as a result of end-user interaction. If the inner key value parameter is null, the grid creates a new row and switches the grid to edit mode. You can handle the SelectedCellsChanged event to be notified when the collection of selected cells is changed. A grid column used to display and edit numeric values. We've created an example to show you how to use the StartRowEdit method and implement custom command buttons inside a DevExpress Blazor Data Grid component. Universal SubscriptionOur Best Value – includes over 600 UI Controls, our award-winning reporting platform, DevExpress Dashboard, the eXpressApp Framework, CodeRush for Visual Studio and more. Change number format based on a cells value Posted on June 12, 2017 December 28, 2018 by Excel Off The Grid Imagine a situation where you have built a dynamic report or dashboard that you a really proud of. The CellValueEventArgs. Cookies Support - the ASPxGridView control fully supports cookies that allow your site's visitors to personalize pages. Focus: Sets input focus to the grid. Now I will explain how to get row values from a GridView when the checkbox is selected using ASP. I have a gridview, Which I am editing. If the cell's data field is known, you can pass it instead of the column index. Introduce a collection to store GridCell class (it is our class that has the RowHandle and Column properties) instances and populate it when a cell value is changed. My data shown by DevExpress GridControl in my Vb. Focus a cell and click the Navigator control's Edit button:. The DataGrid exposes a CellEditEnding event which looks like a good candidate for this, from the event arguments we can locate the current EditingElement (i. ValueChanged client-side event is used to send a callback to the server side, invoking the grid's ASPxGridView. The DevExpress ASP. Thus, changes will be accepted without changing focus, and the CellValueChaned event will fire. void dataGridView1_CellClick_1(object sender,. Addition Two Textbox value by Java script On keyDown Event in Gridview Devexpress gridcontrol sum of row cell values in specific column cell How to add rows in devexpress GridControl just like we add rows in a normal datagridview. Consider the following picture I get the selected row values in the three textboxes shown in the figure when i click a cell using following code. This enables you to provide an event-handling method that performs a custom routine, such as updating a status label with the currently selected row, whenever this event occurs. The first interesting thing to realize is that editing is actually active by default in the grid. In addition to edited cell values, it allows you to get the cell values before user edits. In some cases, they are essential to making the site work properly. The RowCellClick event does not fire when a user clicks on a row cell if Grid data is editable and the ColumnViewOptionsBehavior.