These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Excel to PDF - Right Text Alignment lost in conversion

Forum Index > PDF Creation > Excel to PDF - Right Text Alignment lost in conversion
2008-12-17 15:05:03
resorte
Registered: Dec 17 2008
Posts: 17
Answered

I am using:

Windows XP SP 2
Acrobat Professional 8.1.2
Microsoft Office Professional 2003

I have had this problem for approximately six years through different versions of both Excel and Acrobat.

There is one string of text in my Excel template that has always showed up mis-aligned after being converted to PDF. I have messed about with this text for years in effort to resolve this glitch. To make matters worse, it seems to mis-align inconsistently as in it is often mis-aligned by different amounts in different documents.

I would be happy to email XLS or PDF files if it would help to resolve this problem. Your help would be much appreciated, these are six year glitches looming over me!

Here are some images to illustrate the issue:

Correctly aligned in Excel before conversion:

[img]http://i41.tinypic.com/2lxw1fq.jpg[/img]

Mis-aligned PDF after conversion:

[img]http://i41.tinypic.com/21ngmqu.jpg[/img]

My Product Information:
Acrobat Pro 8.1.2, Windows
Top
2008-12-19 05:07:46
#1
abhigyan
Expert
Registered: Nov 29 2007
Posts: 223
Can you post the XLS and PDF files somewhere (one option is share.acrobat.com)
Top
2008-12-19 05:26:37
#2
resorte
Registered: Dec 17 2008
Posts: 17
Hello, You can find the XLS file which I have uploaded here to the Excel Help forum here:

http://www.excelforum.com/excel-new-users/666030-text-alignment-madness.php


Thanks for your reply, I hope you have some ideas about this issue. It has stumped me for many years.
Top
2008-12-19 05:42:52
#3
abhigyan
Expert
Registered: Nov 29 2007
Posts: 223
Well, I see a minor shift but nothing as drastic. One thing I noted was that print quality of your Excel worksheet's was set to 144 dpi. Try changing the dpi to something like 600 or 1200 dpi in "Page Setup" dialog of Excel.
Top
2008-12-19 06:23:31
#4
resorte
Registered: Dec 17 2008
Posts: 17
Once again, that you much for your help on this one especially. Raising the print quality to 1200 dpi leads to a satisfactory but not perfect alignment. 2400 dpi is even better! I am just so surprised this is a necessary step just to get text alignment to show up correctly! How would one ever know that? hmmm

Anyways, Thanks again!!!
Top
2008-12-26 06:23:45
#5
highliter
Registered: Aug 27 2008
Posts: 7
On the same topic, coverting Excel to PDF.
My problem is , that the print of the page shrinks to much.
For example if my XL margin is set 0.5" all around , the converted version will be at about 1.5" .
That makes the print and layout much smaller.
P.S. I have A lot of Forums done in XL and now that I have Acrobat 9 Pro Extended, I want to make them as PDF forums.

I have Windows XP Pro SP-3 and Office 2002.
Top