Dotted Linestyle is not seen in Print of the excel

[PariDhillon]

Hi,

I am setting the default gridlines of excel worksheet to
"Dotted" (dotted linestyle) programmatically. Everything works fine
but when i do a print preview or take a print of the same worksheet, i
see some of the vertical dotted lines missing.

It seems to be an excel issue to me but i am not sure. Is there any
workaround?

One solution that i came across was to Scale my page to 100% of the
normal size(Setting in page tab of Page Setup). But it is not a very
user-friendly output. Can someone help me out on this issue?

Thanks in advance!!

 

[Per Jessen]

Hi

To print gridlines goto File > Page Setup > Sheet > In the Print section,
check Gridlines > Ok

Regards,
Per