Forums Home / Spread / Spread for WinForms
Posted by: mikael.stridfeldt on 18 September 2020, 4:38 am EST
mikael.stridfeldt
Posted 18 September 2020, 4:38 am EST - Updated 30 September 2022, 1:23 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
Posted 21 September 2020, 7:00 am 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
Posted 23 September 2020, 6:41 am EST
Hello Mikael,
Regards,
mikael.stridfeldt
Posted 23 September 2020, 8:25 am 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
Posted 24 September 2020, 6:44 am 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
Posted 24 September 2020, 7:06 am 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
Posted 25 September 2020, 4:47 am 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
Posted 28 September 2020, 1:40 am EST - Updated 30 September 2022, 1:24 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
Posted 29 September 2020, 5:44 am 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
Posted 29 September 2020, 5:48 am EST
Hi Ruchir
Great! As soon as it out i will test it.
Best Regards!
Ruchir.Agarwal
Posted 12 November 2020, 3:33 pm 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
Posted 16 November 2020, 3:54 am EST - Updated 30 September 2022, 1:24 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
Posted 18 November 2020, 3:19 am 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
Posted 18 November 2020, 3:24 am 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
Posted 22 November 2020, 2:35 am 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,
