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. Image for the cookie policy date

Excel like GridDataBound Comments

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

6 Replies

AD Administrator Syncfusion Team February 23, 2004 12:35 AM

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


SA Satish February 23, 2004 01:05 AM

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


AD Administrator Syncfusion Team February 23, 2004 02:43 AM

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


SA Satish February 23, 2004 03:04 AM

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 > >


SA Satish April 16, 2004 05:09 AM

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 >> >>


AD Administrator Syncfusion Team April 16, 2004 06:14 AM

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);
		}
	}
}

Loader.
Live Chat Icon For mobile
Up arrow icon