Hello.
When using the Cell Change Event, if you use ClearFill(), it takes an infinite loop. Is there any way to prevent this?
xaml - radspreadsheet <
ActiveSheetChanged
=
"radSpreadsheet_ActiveSheetChanged"
/>
C# Code
private void radSpreadsheet_ActiveSheetChanged(object sender, EventArgs e)
{
radSpreadsheet.ActiveWorksheet.Cells.CellPropertyChanged += cells_CellPropertyChanged;
}
private void cells_CellPropertyChanged(object sender, CellPropertyChangedEventArgs e)
{
var isSameValue = e.Property.UseSameValueAsPreviousOnInsert;
var column = e.CellRange.FromIndex.ColumnIndex;
var row = e.CellRange.FromIndex.RowIndex;
CellSelection cell = (sender as Cells)[row, column];
var value = cell.GetValue().Value.RawValue;
if (string.IsNullOrEmpty(value))
{
cell.SetFill(Defines.RedFill);
if (column == 2)
{
cell.Worksheet.Rows[row].Remove();
}
}
else if (value == Defines.NoParam)
{
cell.SetFill(Defines.YellowFill);
}
else
{
cell.ClearFill(); // This cellChanged event loop.
}
}
Thanks.