Print Preview Looks Different (Problem)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeffrey A. Voigt - 17 Feb 2005 22:16 GMT

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

Reply to this Message

Robert Christie - 18 Feb 2005 08:19 GMT

Hi Jeff

> All columns have a predefined size..
> All rows are set to auto adjust based on the contents.

You may have to set cells to allow word wrap

> Set font to Arial (7pt) << Problem?

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.

> Can anyone tell me why this may be happening and how I can fix it? Take a
> look at the screenshow below:
[quoted text clipped - 22 lines]
> Thanks,
> - JV

Reply to this Message

Jeffrey A. Voigt - 18 Feb 2005 15:08 GMT

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

> Hi Jeff
>
[quoted text clipped - 33 lines]
> > Thanks,
> > - JV

Reply to this Message

Jeffrey A. Voigt - 28 Feb 2005 20:37 GMT

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

> 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
[quoted text clipped - 49 lines]
> > > Thanks,
> > > - JV

Reply to this Message

Dave Peterson - 18 Feb 2005 21:43 GMT

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?

> Can anyone tell me why this may be happening and how I can fix it? Take a
> look at the screenshow below:
[quoted text clipped - 22 lines]
> Thanks,
> - JV

Signature

Dave Peterson

Reply to this Message