private void spreadsheetControl1_CustomDrawRowHeader(object sender, CustomDrawRowHeaderEventArgs e)
{
// Cancel default painting for the row header.
e.Handled = true;
// Display a row number for every fifth row.
if ((e.RowIndex + 1) % 5 == 0)
{
// Specify font style.
e.Appearance.FontStyleDelta = FontStyle.Bold;
// Return the row header bounds.
Rectangle textBounds = e.Bounds;
// Specify row header text.
string text = (e.RowIndex + 1).ToString();
// Specify text alignment.
StringFormat format = new StringFormat {
LineAlignment = StringAlignment.Center,
Alignment = StringAlignment.Center
};
// Draw row header text.
e.Graphics.DrawString(text, e.Font,
e.Cache.GetSolidBrush(Color.FromArgb(91, 155, 213)), textBounds, format);
}
}
private void spreadsheetControl1_CustomDrawRowHeader(object sender, CustomDrawRowHeaderEventArgs e)
{
e.Handled = true;
Color foreColor = Color.Black;
Rectangle textBounds = e.Bounds;
Font headingFont = new Font(e.Font, FontStyle.Regular);
Worksheet settingsSheet = spreadsheetControl1.Document.Worksheets[0];
string text = settingsSheet.Cells[e.RowIndex, 9].DisplayText;
//string text = "cai gi do";
//if (text != String.Empty)
{
StringFormat formatHeaderText = new StringFormat();
formatHeaderText.LineAlignment = StringAlignment.Center;
formatHeaderText.Alignment = StringAlignment.Center;
formatHeaderText.Trimming = StringTrimming.EllipsisCharacter;
e.Graphics.DrawString((e.RowIndex + "h - " + (e.RowIndex + 1) + "h").ToString(), headingFont, e.Cache.GetSolidBrush(foreColor), textBounds, formatHeaderText);
}
}
