Not working to display images and cell border line into excel when i save grid

Posted by: license on 29 December 2020, 3:09 pm EST

  • Posted 29 December 2020, 3:09 pm EST


    I had set border color and style as blow into grid normal style in grid's Constructor
    Please refer to the photo for the rest other of the description

    ---------------------------
    this.Styles.Normal.Border.Color = System.Drawing.Color.DarkGray;
    this.Styles.Normal.Border.Style = C1.Win.C1FlexGrid.BorderStyleEnum.Flat;
    ---------------------------

    Not working to display images and cell border line into excel when i save grid to excel with method(SaveExcel)

    some body help me please.


  • Replied 29 December 2020, 3:10 pm EST

    i'm using blow dlls.
  • Replied 29 December 2020, 5:36 pm EST

    i solved to show images into excel. but i don't know yet how to merge image part in excel and showing border like program's grid showing.
  • Marked as Answer

    Replied 29 December 2020, 6:58 pm EST

    About the borders: I asked the same question some time ago, and implemented a workaround.
    See here: https://www.grapecity.com/forums/winforms-edition/saving-c1flexgrid-to-excel#as-another-user-asked-the-

    Hope this helps

    Wolfgang
  • Replied 29 December 2020, 8:50 pm EST

    Wow!!!!!!

    Sir "wknauf"
    !!!!!!!!!! It has been solved with your code !!!!!!!!!!!
    so thank you!!!!!
    thank you very much!!!!!!!!!!
    God bless you!!!!!!!!!!!!!!!
  • Replied 29 December 2020, 9:20 pm EST

    But I have just one problem -> Image Merge like text when i export grid to excel.

    i have been two case...blow pictures....
  • Replied 29 December 2020, 9:27 pm EST

    Hi,

    this seems like a bug to me, so it is up to C1 support to comment on this. It will probably help if you could a small self running sample which reproduces this.

    You might work around this by doing some postprocessing using "C1Excel" and reset the image in all unwanted cells.

    Best regards

    Wolfgang
  • Replied 3 January 2021, 8:28 pm EST

    Hi,

    I was able to replicate the second case of the Image Merge issue and have escalated it to the developers and will let you know as soon as there is an update.[Interal Tracking Id: 24131]

    Please provide a sample showing the first case i.e multiple images in merged range, so that we investigate this better.

    In the meantime, you can use C1Excel API to do some postprocessing and modify the image according to your requirement. Please refer to the sample attached which changes the size of the image to fit in the merged range.

    Exporting Border is not currently supported. You can use Wolfgang’s workaround for the borders.
    Wolfgang, Thank You! for that.

    Regards,
    Prabhat Sharma.
    FGExcel.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels