PDF-cells are not filled completly

PDF-cells are not filled completly

Posted by: mikael.stridfeldt on 17 September 2020, 7:38 pm EST

• 

  mikael.stridfeldt

  • Post Options:
  • Link
    Copy

  Posted 17 September 2020, 7:38 pm EST

  Hello
  In spread.net 13 the cells arent filled and the cell borders are not drawn as rectangles. Image shows the form in program above and the pdf under:
  
  
  I provided an example project:
  Spread_Win_cells_and_fills_error.zip
  
  Best regards
  Mikael
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 20 September 2020, 10:00 pm EST

  Thank you Mikael, for reporting this. I can observe the problem at my end as well hence, have forwarded it to the concerned team for fix [ID: 12015].
  
  Regards,
  Ruchir
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 22 September 2020, 9:41 pm EST

  Hello Mikael,
  
  1. Regarding the cell background color, can you please ensure that the Zoom% in PDF is 100. Because background is exported as command, when the Zoom is not 100%, they may not match and the issue also depend on PDF Viewer. With the specified zoom, the issue may be seen in a PDF Viewer but not other PDF Viewer.
  So, to please try to set viewer zoom to 100%. This has resolved the problem for me.
  2. Regarding the cell border extending: This is a bug in control and will be fixed in a future release version [ID:12015]. I will get back to you as soon as there is an ETA available.
  
  Regards,
• 

  mikael.stridfeldt

  • Post Options:
  • Link
    Copy

  Replied 22 September 2020, 11:25 pm EST

  Hello
  I all settings where included in the xml. Do you suggest any corrections in it ?
  
  Looking forward to test the new release :)
  
  Best regards
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 23 September 2020, 9:44 pm EST

  Hi Mikael,
  
  >I all settings where included in the xml. Do you suggest any corrections in it?
  Loading the xml in spread and after exporting it to PDF, to observe the cell backcolors fill properly, please set the Zoom to 100% in the PDF viewer.
  
  Regards,
• 

  mikael.stridfeldt

  • Post Options:
  • Link
    Copy

  Replied 23 September 2020, 10:06 pm EST

  Hello Ruchir
  The problem is the pdf and not the view zoom. If i export a pdf from excel its nice and filled no matter what zoom im using.
  
  Best regard
  
  
  
  
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 24 September 2020, 7:47 pm EST

  Hello Mikael,
  
  Like mentioned earlier, the issue with backcolor and borders is a well-known generic issue with exporting to PDF. Because border and background are exported as command, when you don't use 100% zoom, they may not match. And the issue also depends on PDF Viewer. With the specified zoom, the issue may be seen in a PDF Viewer but not other PDF Viewer.
  I checked this with Microsoft Excel and it too shows extended cell borders and cell background color not being filled correctly, when the zoom is not 100%. Please see attached files, that show the issue with MS-Excel as well.
  
  Regards,Files.zip
• 

  mikael.stridfeldt

  • Post Options:
  • Link
    Copy

  Replied 27 September 2020, 4:40 pm EST

  Hello
  When you say exported as a comman. What do you mean ?
  I see that you got same problem when zooming out to 66,7 % from excel.
  
  But there is a huge difference still between the spread and the excel. When i zoom in on the excel exports thay are nice, and many people zoom in to read. If i zoom in on a excel export i see this:
  
  
  From the spread:
  
  
  Best regards
  Mikael
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 28 September 2020, 8:44 pm EST

  Hi Mikael,
  
  Though, the outputs from Excel and Spread are similar at 100% zoom, I can see the difference at higher zoom%. So, I have forwarded it to the devs and they will try to improve/fix it post v14 release.
  
  Thanks & regards,
• 

  mikael.stridfeldt

  • Post Options:
  • Link
    Copy

  Replied 28 September 2020, 8:48 pm EST

  Hi Ruchir
  Great! As soon as it out i will test it.
  
  
  Best Regards!
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 12 November 2020, 6:33 am EST

  Hello Mikael,
  
  We are pleased to share that the Spread v14 release is live. So, you're requested to verify the problem reported here. Should you face any problem, please let us know.
  
  Download link for Spread.NET v14: https://www.grapecity.com/spreadnet/download
  
  Regards,
• 

  mikael.stridfeldt

  • Post Options:
  • Link
    Copy

  Replied 15 November 2020, 6:54 pm EST

  Hello Ruchir
  I have tried the V 14 spread and its sad to report the is still there:
  
  
  I have attached a project with the an excel that shows the problem:
  Spread_Win_Cell_and_edge_error.zip
  
  Best Regards
  Mikael
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 17 November 2020, 6:19 pm EST

  Hi Mikael,
  
  The Spread v14 release fixes the other issues (shape quality and color filling, in PDF), however, the mis-alignment issue is from old implementation and hasn't been fixed yet. The team is keeping track of this issue and will try to improve/fix it in next release(s).
  Confusion caused is regretted.
  
  Regards,
• 

  mikael.stridfeldt

  • Post Options:
  • Link
    Copy

  Replied 17 November 2020, 6:24 pm EST

  Hi Ruchir
  No confusion caused its hard to fix all bugs at once :)
  How often do you make releases?
  
  Best regards
  Mikael
• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Replied 21 November 2020, 5:35 pm EST

  Hi Mikael,
  
  Thank you for understanding.
  
  Spread releases one major version annually followed by (generally) 2 service packs with ~4 months interval.
  
  Thanks & Regards,