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.
This approach seems to be working fine for me. Could you please take a look at my sample.
actually we are using version 9.2 in this project.
could this be the problem?
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.
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
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.