PDFCreator and Excel Total # of Pages

2008-04-14 16:49:05 by asjones

I am using PDFCreator 0.9.5 and have run into a strange issue. I have an Excel file that has multiple sheets/tabs. I have successfully used previous versions of PDFCreator with Excel to print multiple sheets to a PDF file.

Many of my Excel files have a footer in them of the format Page # of

However I just realized that it looks like with version .9.5 when I print, the option varies from one sheet to another what that total number of page is.

So in he output it may say 16 total pages, then 17 total pages, then 26 total pages, backt to 16 etc. On another document the total pages jumps from 9, 12, 14, back to 9.

If I print to a standard printer my total number of pages is consistent and correct.

Any thoughts? Any chance for a new version with a potential fix? I am assuming this a problem with PDFCreator and not Ghostscript.

I really love PDFCreator and have used it for a while but am stumped on this problem.

Any other new features or functions coming out soon on a new version?


thanks for everyone's time and hard work on PDFCreator.

Alan

2008-04-16 18:51:53 by asjones

I just wanted to update my issue.

I have tested this out with several other Excel files that all have multiple sheets/tabs, but different formatting on each sheet. All have problems with the total number of pages information.

Excel does not have this problem with a regular printer and the previous version of PDFCreator did not have this problem.

Any ideas or thoughts?

thanks

Alan

2008-05-16 05:35:09 by asjones

This does seem to be an issue with other users with Excel who print multiple sheets that may have slightly different formatting.

This does not occur with the previous version of PDFCreator.

I am thinking of switching back. Could someone look into this bug. I don't know if it is a Ghostscript issue or what.

I would be happy to test any betas that may have possible fix.


thanks

Alan

2008-05-22 14:16:07 by ray_diack

Hi Alan

I just had the same issue - well similar anyway. I'm new to PDFCreator. We set up a PDFCreator server (shared printer on a server, with autosave enabled, that dumps PDFs to c:\PDFs\%username%.)

I had a user complaining that her multiple worksheet Excel 2003 doc kept creating PDF's with a random amount of pages. For us, the fix was to look at the Page Setup properties of each worksheet in the workbook, and verify that the quality settings were identical (600dpi). If the quality settings are different, it will split the PDF into multiple PDF's, because Excel sends multiple jobs to the PDFCreator printer instead of one job.

Hope that helps?

Ray

2008-05-22 22:22:28 by thesmilyface

This is correct and we should add this to our faq.

Frank

2008-05-24 03:47:55 by asjones

Thanks for the replies but in my case I checked and verified all my sheets say 600 dpi. Older versions did not have this problem on these files....

I also don't mind if multiple PDF files are created I can have used in other unrelated cases PDFCreator's collect and merge option so you can print several PDF files and bring them together.

In my case they all come out at one file but the total page numbers are not consistent, but the DPI is the same.

I am still open to other ideas.

thanks for the idas.


Alan

2008-05-24 10:26:27 by thesmilyface

Hi Alan,

is it possible to get these file?

Frank

2008-05-24 15:43:01 by asjones

the files themselves have internal budget type stuff.... I probably could "clean" things up and send them to you.

What email address should send them to?

thanks

Alan