Use Windows-powered virtual printers to print Excel tables without a tabular line problem resolution (2)

Test:

After the day before the test, ultimately there is no obvious decision in the end is the driving problem, or printer problems. But according to the possibility to troubleshoot, the most obvious point is that the other test environment to add a picture, you can print out the table line , I always think this is a breakthrough, but the moment is not thinking.

So I would like to see the existence of a table in Word will not have the same problem, unfortunately no, for this I tentatively for Office bug, on Google search keywords, office Excel can not print gridlines, Fortunately, the same problem seems to have been seen: http://209.116.186.218/#newwindow =1&q=office+excel+can+not+print+gridlines

There is a section in front of the vaguely, in the middle there is a sentence: in the Excel document, Print Preview and Print>printer properties>advanced>document Options>print optimizations:change setting to Disable. Save the file.

According to the above description I went to check the printer properties advanced settings in the printing optimization, the default is enabled, I changed to Disabled, and then print the test or no table lines.

Although there is still no form line, but this gives me a revelation: The printer settings in the presence of an optimized option, this option must be a driver in some of the switches, and I found in front of the picture when the print is no problem, So it is very likely that there are pictures and no pictures when performing the rendering when the different routes resulted in different results. Well, there's a good chance that this is the option, but the other options need to be changed.

So I try to change the other options, mainly the following "graphics mode" option, but it has no effect ah.

At this time, I suddenly thought, I saw this post, I saw Microsoft's description of the form line printing, there is an introduction if you can not print out the form line, you need to turn off the page settings in the "draft method."

I did the test before I accidentally hook up here, did not cancel off, so I canceled and then went to print the test, surprised to print out the form line. Quickly restore the previously changed unrelated settings, and found that the printing optimization is really the cause of the absence of a table line ah.

Solve:

OK, here it is basically solved, a little summary of the whole process of attention to the place:

1, test the time to try not to have multiple variables, and test no effect after you have to remember to restore back to the default settings ah (above I do not think of "by the draft" Here, I do not know how long it will take to find this problem).

2, do not underestimate the print-driven GPD file Ah, there are so many settings, there are a lot of default option parameters is very important.

3, for the virtual printer, there is no need to have such a "Print optimization" option, go to GPD to remove this option, but also to ensure that the default is disabled.

Use Windows-powered virtual printers to print Excel tables without a tabular line problem resolution (2)