Forums Ultimate UI for Windows Forms
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
Close
felipe
268
Image Export to excel
posted

Hi team,

 

I got an ultragrid filled up and contains images and colors on the rows.

The filter does work , it sorts well  in the ultragrid.

 

When exporting to excel , it replaces the color with the name of it and the image is not into the cell, its just floating over the cell, so if I filter or sort over excel the images stays on the same position they appear.

 

Any idea regarding this,

 

This is how I fill the ultragrid row  color value over UltraGrid2_InitializeRow

 

  If overall >= 9 Then

            e.Row.Cells("Top2, Mid4, Bot5").Value = Color.Green

 ElseIf overall >= 5 And overall <= 8 Then

            e.Row.Cells("Top2, Mid4, Bot5").Value = Color.Yellow

 ElseIf (overall <= 4) Then

            e.Row.Cells("Top2, Mid4, Bot5").Value = Color.Red

 

        End If

 

 

Thanks.

  • 48586
    Verified Answer
    posted

    Hello, ­­­­­

     

    I am just checking about the progress of this issue. Let me know If you need my further assistance on this  issue?

     

    Thank you for using Infragistics Components.

  • 48586
    Verified Answer
    posted

    Hello,

     

    As far as I know basic functionality of Excel doesn’t allow cells' values to be Image or Color. Excel works with formulas and functions, which could not be executed onto a Pictures and Colors. So the issue which you are facing comes from the Excel limitations.

     

    Please let me know if you have any further questions.