Excel preview shows many pages but strange or no output

Some Excel sheets show a strange behavior when you print them or do a print preview. This can be caused by the wrong DPI setting for the Excel sheet you are looking at.

It is easily fixed if you change the DPI setting to something meaningful.

First, you click the small icon on the Page Layout tab.

excel page layout

Second, you change the print quality to something like 300 dpi.

excel page setup

Now, you should be able to print your document.

Color problems with a background PDF

Some PDF documents change the colors when they are used as background for another PDF. This is often the case for PDF files created with other tools where the color information is not fully compatible.

Print PDF to a new PDF with Bullzip

You can often get the colors right if you print the existing background PDF to a new PDF using the Bullzip PDF Printer. Simply open the background PDF in Adobe Reader and print it to the Bullzip PDF Printer. Then use the new PDF as the background PDF.

If this doesn’t work, you can try the same procedure with at different PDF viewer. Instead of Adobe you can use Sumatra PDF Reader, which is a free reader available for download on the Internet. This has often produced good results.

PDF Compatibility Level

You can also try to change the compatibility level of the PDF that you create. This can also be used when you create the background PDF by printing it from another reader as mentioned above.

PDF Color Model

In the PDF options dialog, there is an option to change the color model used, when creating a PDF. Try to experiment with that as well.

Hopefully, one of the strategies mentioned here will help you solve the color issue when using another PDF as a background. These methods should all preserve the vector based information intact and deliver the best quality possible.

 

Merging of PDF files

In this article, I will try to explain why some users experience problems when merging multiple documents.

The printer is designed to process print jobs in parallel. This means that it will start processing a job even before the previous job has finished processing. Consequently, you can run into trouble if you expect to merge the current print job with a previous one that has not finished yet. The result is that you get a document with missing pages.

One solution is to wait for the previous job to finish before you start the next one. This requires that you control the creation of the documents in the print queue.

Another solution is to tell the PDF printer to stop processing jobs in parallel mode and do it one by one. You control the processing with a registry setting called GUITimeout. The use of the GUITimeout setting is described in the BioPDF documentation.

Switching to sequential mode will lower the performance when processing multiple jobs. Another side effect is also that on Citrix or Terminal Servers, one user can block the job processing for another user. Other than that, the setting is safe to use.

DEP crashes programs on Windows Server 2008 R2

If you experience random crashes on Windows Server 2008 R2, you may have a problem with the DEP (Data execution protection).

On Windows 2008 R2 there seems to be a problem with DEP. We have seen the crashes stops if users disable it for the gui.exe process or entirely. Often the crashes are logged by the Windows Event Log. According to the log they stem from random DLL files with no association with the PDF printer.

Here is how to disable it:

Open Control Panel, click on System and Security→ System → Advanced system settings. In the Advanced tab, click on the Settings button in the Performance section (the first one). In Performance Options, Data Execution Prevention has its own tab.

The odd thing about this finding is that has only been seen on Windows Server 2008 R2. Earlier or later versions of Windows Server has not shown this problem.

Autodesk/AutoCAD/Revit and PDF creation

When you want to create PDF documents from the Autodesk/AutoCAD/Revit products there are some parameters, you can use to optimize the PDF creation.

Depending on what you are printing or plotting the size of the resulting PDF may vary a lot. Especially drawings containing rasterized images or scanned images with a lot of noise dots will create huge print jobs and therefore large PDF files. If you are facing a size or performance issues, there are a couple of tricks that you can use.

  • Lower the DPI of the printer.
  • Change the raster graphics settings in your plotter configuration.
  • Reduce the paper size.

The information that goes into a PDF is a product of these settings. If you lower the DPI the 50% of what it was before then your document will typically become 4 times smaller. If you keep the DPI but doubles the paper size then the size of the print job is also approximately twice the size.

Sometimes the operating system and the printer drivers used by the PDF printer will also have an effect on size.

Here is a list of steps you can take to reduce the PDF size produced by AutoCAD.

Open the print dialog

First you open the print dialog and select the Bullzip PDF Printer. Then you click the Properties button to change the printer properties.


Raster Graphics

In the Plotter Configuration Editor, you can lower the raster image quality to a suitable value for your scenario. Try setting them to half the maximum value as shown here.


Change the DPI setting

After that you can click the Custom Properties and change the DPI. Lowering the DPI will potentially reduce the quality of the output. However, it may not mean much depending on what your PDF should be used for.


Save the plotter configuration

When you have found your preferred combination of settings, you can save the plotter configuration to a file and select that the next time you want to print to PDF. In the dialog shown here, the plotter name is now my PC3 file with all the settings.

Why do I see a trial message in my PDF

The PDF printer comes with all the features available. Some features are only meant to be used by uses with a license. However, you can still try everything without a license, so that you can decide if the feature works for what you want to do. When you use a feature that is unavailable in your current license type, you will get a trial message in the bottom of the printed page. It will look something like this:

TRIAL MODE − a valid license will remove this message. See the keywords property of this PDF for more information.

You can see why the trial message was put there and determine which type of license you need. Open the PDF file properties in Adobe Reader by pressing Ctrl+D or use the menu File->Properties.


The property will open and the Keywords section will tell you the name of the feature, you are using and which type of license it belongs to.


If you already have a license and want’s to upgrade to a higher feature level then you should write to our support.

PDF is printed as an image

When you print to PDF from some programs, you end up with a PDF that looks like a printed image instead of text. In a PDF like that, you cannot select or copy text because the PDF reader cannot determine what is text and what is graphics.

This situation occurs when the printing program sends everything to the PDF printer as an image. The recent versions of popular browsers such as Firefox, Google Chrome, and Opera does this. There is nothing much you can do about this other than trying to use another program to print. Try using the Microsoft Edge browser or Internet Explorer. They both print the text as text so that you can select it and search it in the PDF.