Hi,

We export the tooltips from a xamDataGrid to an excel worksheet and it works good using a WorksheetCellComment for the tooltip content. But the size of the tooltips changes if we expand the cells in the worksheet. We tried to keep the size constant with the PositionMode property but it doesn't work.

Here is the code snippet:

Dim comment As Infragistics.Documents.Excel.WorksheetCellComment = New WorksheetCellComment()
        If Not (elements(i).ToolTip) Is Nothing Then
          comment.Text = New FormattedString(elements(i).ToolTip)
          _excelWorksheet.Rows.Item(_row).Cells.Item(column).Comment = comment
          _excelWorksheet.Rows.Item(_row).Cells.Item(column).Comment.PositioningMode = ShapePositioningMode.DontMoveOrSizeWithCells
        End If

Thanks in advance

Chema