Bottom borders doesn't display properly

[YasserKhalil]

Hello everyone
In the Sample excel file, if you click Print Preview, you will notice that the bottom border doesn't appear properly in some pages.
The excel file is output of a code that adjust the settings and some formats .. and the code also sets vertical page break
How can I fix that bottom border problem?

[HansV]

If you look closely, not only the bottom borders are missing in print preview, but some borders between the rows too. Which ones depends on whether you zoom in or not. This is a limitation of the on-screen display. I actually printed the document on paper, and all the borders were printed correctly.

I don't think you can do anything about it (except perhaps getting a super high-resolution monitor).

[HansV]

This is what I see in print preview:

S3411.png

S3412.png

And a photo of the first page of the printed output:

IMG_20200710_205458.jpg

[YasserKhalil]

Thanks a lot, Mr. Hans

[LisaGreen]

Limitation of the screen rendering IMHO.

Print it anyway and see what happens

Lisa

[LisaGreen]

Oops... Sorry Hans!!!!

Fingers engaged before eyes and brain!!!

Lisa