Printing to PDF missing words

[hughess7]

Hi all

When I preview/print an excel sheet on our HP printer it comes out as
desired. When I preview or print the same sheet as a PDF it chops off words
from the right hand side of the page. You still get the full border
surrounding the text but only about half the width of the sentences are
shown. To complicate matters further I believe this is an intermittent
problem although at the moment I can't get it to work at all.

This is causing us a major problem as we need to submit a load of reports as
PDF and I can't get it working properly. We use Adobe 6 standard, the printer
driver is Adobe PDF. I have also tried printing to a file and using distiller
to then convert to PDF but I get the same results.

I think it is an Excel / compatibility issue maybe rather than Adobe as I
believe the same thing happens using another free PDF software package also.

HELP please!!!

Thanks in advance for any help.
Sue

 

[Dave Peterson]

There are times when I've printed on a normal ink and paper printer and similar
things happen.

If I can't use a different printer, then only thing I've done to avoid it is to
change the data in excel. Either widen columns, change fonts, add alt-enters
(to force new lines in the cell).

I think it's just a problem that WYSIWYG is not really WYSIWYG.
(WYSIWYG = What You See Is What You Get)

 

[hughess7]

It is a VERY complicated spreadsheet and has 20 different sheets approx that
are all printed to one PDF file (although it does the same if just one sheet
/ page printed). The font is already small to fit on one page so adjusting
layout is not an option really. It does print ok to our printers though so I
don't think WYSIWYG is the issue - it is converting to PDF only that causes
the problem...

Obviously this is a requirement so we are a bit stuck!

 

[Bill Sharpe]

This is causing us a major problem as we need to submit a load of reports as
PDF and I can't get it working properly. We use Adobe 6 standard, the printer
driver is Adobe PDF. I have also tried printing to a file and using distiller
to then convert to PDF but I get the same results.

Adobe is up to version 9. Consider upgrading to see if that helps.

Bill

 

[hughess7]

Thanks, but as I put in my original post the same thing happens using other
PDF software apps eg Primo and PDF995 so I don't think it is an Adobe issue
as such. Therefore the company is reluctant to spend money at the moment on
an upgrade that probably won't fix the problem.

I think it is something to do with excel and I was hoping to find others
that have had the same problem and found a fix... thanks anyway.

Sue

 

[Bob I]

What happens if you print to Microsoft Office Document Image Writer?

 

[hughess7]

Never used this, is it part of Office 2003? Will have a look tomorrow when I
am back in the office.

 

[Bob I]

It is, but it may need to be installed.

 

[hughess7]

Brilliant thanks!! That worked a treat. I hadn't even noticed that option
before, printing the created TIFF to PDF retains the formatting too so we can
still save as PDF without any text being missing/truncated . Thanks Bob...

 

[Bob I]

You're quite welcome, glad to hear it fixed your issue!