We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to have Excel like comments in a GridDataBoundGrid?

Platform: WinForms |
Control: GridDataBoundGrid(Classic) |
Published Date: April 30, 2011 |
Last Revised Date: July 10, 2014

 

The GridDataBoundGrid just displays the values from the DataSource. It doesn't store any cell style properties apart from the cell text. You have to provide such properties on demand through Model.QueryCellInfo. To have Excel comment tips for the cells, you can have a hashtable to maintain the comments for each cell. You can provide the comments in Model.QueryCellInfo and if edited by users, you can store this in Model.SaveCellInfo.

C#

ArrayList comments;

private void GridQueryCellInfo(object sender, GridQueryCellInfoEventArgs e)

{

if(e.RowIndex > 0 && e.ColIndex == 2)

{

ExcelTip.GridExcelTipStyleProperties style = new ExcelTip.GridExcelTipStyleProperties(e.Style);

style.ExcelTipText = (string)this.comments[e.RowIndex - 1];

e.Handled = true;

}

}

private void GridSaveCellInfo(object sender, GridSaveCellInfoEventArgs e)

{

if(e.RowIndex > 0 && e.ColIndex == 2)

{

ExcelTip.GridExcelTipStyleProperties style = new ExcelTip.GridExcelTipStyleProperties(e.Style);

this.comments[e.RowIndex - 1] = style.ExcelTipText;

e.Handled = true;

}

}

VB

Private comments As ArrayList

Private Sub GridQueryCellInfo(ByVal sender As Object, ByVal e As GridQueryCellInfoEventArgs)

If e.RowIndex > 0 AndAlso e.ColIndex = 2 Then

Dim style As ExcelTip.GridExcelTipStyleProperties = New ExcelTip.GridExcelTipStyleProperties(e.Style)

style.ExcelTipText = CStr(Me.comments(e.RowIndex - 1))

e.Handled = True

End If

End Sub

Private Sub GridSaveCellInfo(ByVal sender As Object, ByVal e As GridSaveCellInfoEventArgs)

If e.RowIndex > 0 AndAlso e.ColIndex = 2 Then

Dim style As ExcelTip.GridExcelTipStyleProperties = New ExcelTip.GridExcelTipStyleProperties(e.Style)

Me.comments(e.RowIndex - 1) = style.ExcelTipText

e.Handled = True

End If

End Sub

Sample:

http://websamples.syncfusion.com/samples/kb/grid.windows/GDBGComments/main.htm

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon