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
  • Jump To Answer

  Posted 29 December 2020, 3:09 pm EST - Updated 3 October 2022, 2:27 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.

  

  1740×1017 491 KB

  

  3792×2157 788 KB

• 

  license

  • Post Options:
  • Link
    Copy

  Posted 29 December 2020, 3:10 pm EST - Updated 3 October 2022, 2:26 pm EST

  i’m using blow dlls.
  
  

• 

  license

  • Post Options:
  • Link
    Copy

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

• 

  wknauf

  • Post Options:
  • Link
    Copy

  Posted 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

  Posted 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

  Posted 29 December 2020, 9:20 pm EST - Updated 3 October 2022, 2:27 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…
  
  

  

  878×668 42.9 KB

  

  866×665 30.1 KB

• 

  wknauf

  • Post Options:
  • Link
    Copy

  Posted 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

  Posted 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

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 25 April 2023, 3:31 pm EST

  Hello,

  Apologies for the delay in response.
  
  This issue has been fixed back in 2022v2 builds. Please update your project with the latest builds to resolve this issue.

  Regards,
  
  Prabhat Sharma.