My goal is to use a column to track the max value across a series of columns for each row in a Quantum Grid. As a value is entered in a cell it will be compared to the value in the "Max" column for the row and, if the new value is greater then it is copied to the Max column
I am trying to use the OnEditValueChanged event handler for the series of data columns but when the new value is greater than the Max and the value is copied to the Max column it no longer appears in the data column to which the value was entered. If the entered value is <= the Max value the new value appears in the entered column as expected (because nothing is copied to another column). As you can see from my code I tried loading the column edit value but that didn't work either.
Any help appreciated as I am pushing a deadline.
procedure TfrmMain.gtvShopShCoxxPropertiesEditValueChanged(Sender: TObject);
if ((Sender as TcxCurrencyEdit).EditValue > gtvShopShMaxPayout.EditValue) and
//gtvShop.Controller.FocusedColumn.EditValue := (Sender as TcxCurrencyEdit).EditValue;
gtvShopShMaxPayout.EditValue := (Sender as TcxCurrencyEdit).EditValue;