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

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

• 

  license

  • Post Options:
  • Link
    Copy

  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.
  
  
  
• 

  license

  • Post Options:
  • Link
    Copy

  Replied 29 December 2020, 3:10 pm EST

  i'm using blow dlls.
  
• 

  license

  • Post Options:
  • Link
    Copy

  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

  

  wknauf

  • Post Options:
  • Link
    Copy

  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
• 

  license

  • Post Options:
  • Link
    Copy

  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!!!!!!!!!!!!!!!
  
• 

  license

  • Post Options:
  • Link
    Copy

  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....
  
• 

  wknauf

  • Post Options:
  • Link
    Copy

  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
• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  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