Posted 8 September 2017, 2:59 pm EST
I have two cells of PercentCellType both containing numbers, one upper value one lower value.
The value in the upper cell must always be higher than the value in the lower cell.
upper cell 70%
lower cell 60%
The MinimumValue of the upper cell is the value of the lower cell.
So it can not occur that the user reduces the value of the upper cell lower than 60% in the axample above.
When editing the lower cell I have to adjust the MinimumValue of the upper cell. E.g. I edit 65% in the lower cell
then the MinimumValue of the upper cell must also be 65%.
When I use the SpinButton I can handle the EditChange event to adjust the Minimum-/MaximumValues of the corresponding other cell.
That works fine.
However when the user enters the editable cell itself (instead of using the SpinButton) the event EditChange may occur with a value that is
lower then the MinimumValue I have set (and vice versa).
Does this mean that I must forbid editing in cell itself in order to get allowed values (greater than minimum and lower than maximu)?
Or can I trigger on a different event than EditChange in order to get allowed values only?