void spreadsheetControl1_CustomDrawCell(object sender, DevExpress.XtraSpreadsheet.CustomDrawCellEventArgs e)
{
CellKey cellkey = new CellKey((e.Cell.Worksheet.Index + 1), e.Cell.ColumnIndex, e.Cell.RowIndex);
if (calculationService.CircularReferencedCells.Contains(cellkey))
{
e.Graphics.DrawRectangle(new Pen(Color.Red, 1), e.Bounds);
}
}
private void shcMain_CustomDrawCell(object sender, DevExpress.XtraSpreadsheet.CustomDrawCellEventArgs e)
{
if (SelectedData == null)
{
return;
}
if (e.Cell.Value != null)
{
foreach (var data in SelectedData)
{
if (data.Key + 1 == e.Cell.RowIndex && data.Value.Contains(e.Cell.ColumnIndex + 1))
{
var shift = 2;
var rect = e.FillBounds;
rect.X = rect.X + shift;
rect.X = rect.X + shift; rect.Height = rect.Height - shift;
rect.Width = rect.Width - shift;
e.Graphics.FillRectangle(Brushes.MediumBlue, rect);
}
}
}
}
