I have a gridview with some rows added by user (selected from the list and added to the gridview).
Each row has its special meaning and is defined by number VP.
Some rows are "locked" because user should not enter this value (in this example only 1 row is locked).
Values for locked rows should be automatically calculated when user changes values in current editing row/cell.
Equation for each calculation can be different.
Each cell is represented by Spin Edit control with hidden buttons.
Example from the image.
Row with VP=827 always depends on value in row with VP=101. Any changes in row 101 should automatically reflect changes in row 827.
For this example 827 cell is calculated like this:
if 101 cell is empty -> 827 is empty
if 0 < 101 <= 8 is -> 827 = 1
otherwise 827 = 0
This change should reflect immediately when value of cell in row 101 changes, however calculated values should only be posted when row 101 is Updated.
I am using GridView Toolbars for CRUD operations.
There are few more relations between these rows, but the idea is the same.
Master row's cell is edited and its pre-defined dependant row's cell is calculated.
Is this possible?
I hope you will understand what I mean.
As far as I understand, the row values you want to calculate then should be saved to GridView's data source. If so, please note that the Inline editing mode does not allow you to modify multiple rows simultaneously. You can edit values of only one row.
As a possible solution, I recommend you consider using the Batch Edit mode instead.
Also, I suggest you refer to the ASPxClientGridView.batchEditApi help topic. This topic contains method definitions, which should help you change cells values. You can use the ASPxClientGridView.batchEditApi.SetCellValue method to set a value to a cell.