PDF-cells are not filled completly

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

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



  • 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
  • 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
  • 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,
  • Replied 28 September 2020, 8:48 pm EST

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


    Best Regards!
  • 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,
  • 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
  • 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,
  • 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
  • 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,
Need extra support?

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

Learn More

Forum Channels