Print Preview Looks Different (Problem)

  • Thread starter Thread starter Jeffrey A. Voigt
  • Start date Start date
J

Jeffrey A. Voigt

Can anyone tell me why this may be happening and how I can fix it? Take a
look at the screenshow below:

http://home.comcast.net/~jvelite/formatError.JPG

This is a screenshot of excel in Print-Preview mode. As you can see the
contents of the cell is cut off. Our application loads the contents through
xml and sets the row height to auto adjust based on the contents. In excel
everything looks great. However, when you switch to print preview there are
some instances where the cell contents is cut off just a hair.

This is causing some major problems and I can't figure out what is making it
do this.

Here are some more specifics. Our xml document is transformed via an xsl
file which makes sure the following is done:

Set paper to Legal
Set font to Arial (7pt) << Problem?
All columns have a predefined size..
All rows are set to auto adjust based on the contents.

Please let me know if there is anything that can be done.

Thanks,
- JV
 
Hi Jeff
All columns have a predefined size..
All rows are set to auto adjust based on the contents.
Click to expand...
You may have to set cells to allow word wrap
Set font to Arial (7pt) << Problem?
Click to expand...
It's not a default Arial Size have you tried using Arial Narrow, it allows a
few more character per line.

regards Aussie Bob C.
 
Yes, all cells do allow word wrap as you can see in the screenshot. I
understand what you are saying about the font too, I hope there is another
way around it though =). I will try Arial Narrow and see what happens.

Any more info would be appreciated =)

Thanks,
- JV
 
I don't know if anything can be done, but I've never seen a reliable way to make
sure that lines aren't chopped.

In fact, if I think that I may have a problem (you never what all printers will
do), I add an extra alt-enter character to the cell (as the last character).

If it chops that last "empty" line, I don't really care.

Not much of a solution, huh?
 
Well we changed the font to "Tahoma" and the size to "8pt"... However we are
still getting this problem. Is this a bug & what can I do to fix it?

Thanks,
- JV
 
Back
Top