Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
450
Export tooltip to excel with fixed size
posted

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