Excel like GridDataBound Comments

[Satish]

Hi,
Is it possible to create a comments like Excel for each cell.
Sample application would be appricated.
Thanks
Satish

[Administrator]

There is a KB article on this topic with samples.

http://www.syncfusion.com/Support/article.aspx?id=10369

[Satish]

Hi Clay,
The example mentioned in the KB Article is not working. :)
I am getting error at after Application.Run(new Form1());
--------------------------------
An unhandled exception of type ''System.IO.FileNotFoundException'' occurred in system.windows.forms.dll

Additional information: File or assembly name Syncfusion.Shared, or one of its dependencies, was not found.
------------------------------

Thanks
Satish

>There is a KB article on this topic with samples.
>
>http://www.syncfusion.com/Support/article.aspx?id=10369

[Administrator]

The KB code ships with a particular ExcelComment DLL and does not include this project. So, unless you have the exact version of our libraries that was used to build this DLL, then you will get the problem you are seeing. We will correct this. Here is a solution project that includes the source for the excel comment dll so you can build it along with the sample project using the version of our DLL''s that you have. This should avoid the problem you are seeing. ExcelCommentGDBG_8721.zip

[Satish]

Hi Clay, Its great service. It work perfectly as what i wanted. Thanks Satish >The KB code ships with a particular ExcelComment DLL and does not include this project. So, unless you have the exact version of our libraries that was used to build this DLL, then you will get the problem you are seeing. We will correct this. > >Here is a solution project that includes the source for the excel comment dll so you can build it along with the sample project using the version of our DLL''s that you have. This should avoid the problem you are seeing. > >ExcelCommentGDBG_8721.zip > >

[Satish]

Hi Clay, Removing the Comments function in DataGridBound is not working. Any idea? Thanks Satish >Hi Clay, >Its great service. It work perfectly as what i wanted. >Thanks >Satish > >>The KB code ships with a particular ExcelComment DLL and does not include this project. So, unless you have the exact version of our libraries that was used to build this DLL, then you will get the problem you are seeing. We will correct this. >> >>Here is a solution project that includes the source for the excel comment dll so you can build it along with the sample project using the version of our DLL''s that you have. This should avoid the problem you are seeing. >> >>ExcelCommentGDBG_8721.zip >> >>

[Administrator]

In the SaveCellInfo routine, add an else clause to remove it if the text is empty and the key exists.

private void gridDataBoundGrid1_SaveCellInfo(object sender, GridSaveCellInfoEventArgs e)
{
	if(e.RowIndex > 0 && e.ColIndex > 0)
	{
		ExcelTip.GridExcelTipStyleProperties excelStyle =  new ExcelTip.GridExcelTipStyleProperties(e.Style);
		if(excelStyle.ExcelTipText.Length > 0)
		{
			object key = GetHashCode(e.RowIndex, e.ColIndex);
			if(this.excelTipsCache.ContainsKey(key))
				this.excelTipsCache[key] = e.Style;
			else
				this.excelTipsCache.Add(key, e.Style);
		}
		else
		{
			object key = GetHashCode(e.RowIndex, e.ColIndex);
			if(this.excelTipsCache.ContainsKey(key))
				this.excelTipsCache.Remove(key);
		}
	}
}