G
Guest
I have a client who has just bought a new PC. This PC has a large flat
screen and we are running with "Large Fonts" on so as to make the best from
the screen.
On a second PC, we still have the "Normal Fonts" in place.
Now the problem we have is with an Excel spreadsheet that prints out onto a
pre-printed form in Landscape mode. From the older PC with "Normal Fonts"
there is no problem and everything prints out as it should.
On the new PC with "Large Fonts", the printout seems to loose one pixel per
line. This means that the spreadsheet does not fit the pre-printed form
anymore. The first line printed is a small way out of line, but by the time
it has printed the last line it is almost half an inch out of place.
This issue is caused by the font scaling. I have reproduced this problem on
three different PCs; Office 97 and Office 2003; two differetent printers (HP
and Dell). The issue is always consistent. (Yes - all service packs
applied, all printer drivers updated)
Here is a simple test. Open up a blank sheet. Now write "test data" in box
A1. Then scroll down to find the bottom left corner of your printed page and
write "test data" again. Now scroll to the bottom right corner and top right
corner to repeat this. You should now have a simple sheet with text in each
corner. Make sure we are setup for Portrait printing. Save this page.
Set the fonts on your desktop to be "Normal fonts" (making sure to reboot if
asked). Open up the test sheet and print it to your printer using portrait
mode.
Take the printed sheet, and using a highlighter pen or coloured biro,
carefully colour in the exact location of the printed results. Then feed
that page back into your printer to allow the second test to "over print" on
the exact same page.
Change your fonts on the desktop to be "Large fonts" (again making sure to
reboot when asked). Now, with that same piece of paper in the printer, load
up your test sheet again and send it out of the printer.
One would expect that the two printouts would exactly line up. Well, they
_should_ line up. BUT you will see that the text on the right hand side of
the printout is misalligned by a long way. Text on the left side is fine,
its the right hand side that has the problem.
The four "test data" phrases we placed on the sheet should printout at the
exact same location no matter what the font scaling is set to. Instead,
there is a clear "creep" from left to right as the error appears. There is
no "creep" from to top bottom.
My client is having a huge problem with this as it effects the landscape
printouts they are doing to a fixed form. When printing in Landscape mode,
the error is transformed through 90 degrees, so things line up left to right,
but not top to bottom.
Any help, suggestions, etc will be tried. But I am pretty sure that this is
a real BUG in Excel. Espeically as I can reproduce this in any XP PC or
Printer I have tested this on. It is especially odd that it also occurs in
Excel 97 and Excel 2003.
Cheeers,
MAllen
screen and we are running with "Large Fonts" on so as to make the best from
the screen.
On a second PC, we still have the "Normal Fonts" in place.
Now the problem we have is with an Excel spreadsheet that prints out onto a
pre-printed form in Landscape mode. From the older PC with "Normal Fonts"
there is no problem and everything prints out as it should.
On the new PC with "Large Fonts", the printout seems to loose one pixel per
line. This means that the spreadsheet does not fit the pre-printed form
anymore. The first line printed is a small way out of line, but by the time
it has printed the last line it is almost half an inch out of place.
This issue is caused by the font scaling. I have reproduced this problem on
three different PCs; Office 97 and Office 2003; two differetent printers (HP
and Dell). The issue is always consistent. (Yes - all service packs
applied, all printer drivers updated)
Here is a simple test. Open up a blank sheet. Now write "test data" in box
A1. Then scroll down to find the bottom left corner of your printed page and
write "test data" again. Now scroll to the bottom right corner and top right
corner to repeat this. You should now have a simple sheet with text in each
corner. Make sure we are setup for Portrait printing. Save this page.
Set the fonts on your desktop to be "Normal fonts" (making sure to reboot if
asked). Open up the test sheet and print it to your printer using portrait
mode.
Take the printed sheet, and using a highlighter pen or coloured biro,
carefully colour in the exact location of the printed results. Then feed
that page back into your printer to allow the second test to "over print" on
the exact same page.
Change your fonts on the desktop to be "Large fonts" (again making sure to
reboot when asked). Now, with that same piece of paper in the printer, load
up your test sheet again and send it out of the printer.
One would expect that the two printouts would exactly line up. Well, they
_should_ line up. BUT you will see that the text on the right hand side of
the printout is misalligned by a long way. Text on the left side is fine,
its the right hand side that has the problem.
The four "test data" phrases we placed on the sheet should printout at the
exact same location no matter what the font scaling is set to. Instead,
there is a clear "creep" from left to right as the error appears. There is
no "creep" from to top bottom.
My client is having a huge problem with this as it effects the landscape
printouts they are doing to a fixed form. When printing in Landscape mode,
the error is transformed through 90 degrees, so things line up left to right,
but not top to bottom.
Any help, suggestions, etc will be tried. But I am pretty sure that this is
a real BUG in Excel. Espeically as I can reproduce this in any XP PC or
Printer I have tested this on. It is especially odd that it also occurs in
Excel 97 and Excel 2003.
Cheeers,
MAllen