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

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 wrote:

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

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!

"Dave Peterson" wrote:

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 wrote:

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

hughess7 wrote:

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

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


"Bill Sharpe" wrote:

hughess7 wrote:

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

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

hughess7 wrote:

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


"Bill Sharpe" wrote:


hughess7 wrote:


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

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

--
Thanks in advance for any help.
Sue


"Bob I" wrote:

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

hughess7 wrote:

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


"Bill Sharpe" wrote:


hughess7 wrote:


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

It is, but it may need to be installed.

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

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" wrote:

It is, but it may need to be installed.

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

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

hughess7 wrote:

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" wrote:


It is, but it may need to be installed.

hughess7 wrote:

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