Hi,
Is there a way when exporting to excel to get the cells tooltips as cells comments in excel?
thanks
Hello Hady,
I was able to achieve this through the following code:
private void ultraGridExcelExporter1_CellExporting(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.CellExportingEventArgs e)
{
WorksheetCellComment comment = new WorksheetCellComment();
FormattedString str = new FormattedString(e.Value.ToString());
comment.Text = str;
e.CurrentWorksheet.Rows[e.CurrentRowIndex].SetCellComment(e.CurrentColumnIndex, comment);
}
Please feel free to let me know if a question about our toolset comes up on your mind.
I wanted to know if you were able to solve your issue based on these suggestions or you still need help. Please let me know.
it's working but the comments in excel are collapsed. you need to resize them manually. is there a way to set the size?
We are still following your forum thread.
Have you been able to verify if you could provide us a small sample reproducing this behavior?Thank you for your assistance.
This could be caused by another code from your project or your excel version. If I could take a look at a sample reproducing this it would be great!
we did this. the comments are added but the problem is that the height of the commenst is 0 so they are not showing in excel
This should not be a problem. The only difference would be setting the comment, since in the mentioned version there is no such method as SetCellComment(), but you could use:
e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[0].Comment = comment;
Please feel free to let me know if a question about our tool set comes up on your mind.
actually we are using version 9.2 in this project.
could this be the problem?