Hi,
Is there a way when exporting to excel to get the cells tooltips as cells comments in excel?
thanks
Hello Hady,
This approach seems to be working fine for me. Could you please take a look at my sample.
it's working but the comments in excel are collapsed. you need to resize them manually. is there a way to set the size?
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.
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.