Printing issues

[Phatz]

using excel - if I enter text into a field which results in the text
flowing over into multiple lines - the field lookd grest on the screen,
but when I print or print preview the lines of text step two characters
to the left every line. Hence the text dissappears off top the left and
gets progressively worse as you go down the page.

Please please please help soneone - this is driving me mad!


Phatz

 

[J Laroche]

Phatz wrote on 2005/02/15 15:02:

using excel - if I enter text into a field which results in the text
flowing over into multiple lines - the field lookd grest on the screen,
but when I print or print preview the lines of text step two characters
to the left every line. Hence the text dissappears off top the left and
gets progressively worse as you go down the page.

Please please please help soneone - this is driving me mad!


Phatz

Can you tell us what are the cell's horizontal and vertical text alignment,
horizontal indent, text control (wrap, etc), text font, size and style, and
all other unusual settings?

Do you need to put so much text in one cell?

JL
Mac OS X 10.3.8, Office v.X 10.1.6

 

[Phatz]

JL

It's all very basic - Arial Regular 12pt (I've tried various other
fonts also).

Cell Format: Horizontal - set to general, Vertical - set to top
Text control: Wrap text checked, Merge cells checked.

The aim of the file is for invoicing - therefore I need to write
sometimes a lenghty description down. It therefore is sensible to set
the cells as above.

Got any ideas?

Phatz

 

[DRDurham]

JL

It's all very basic - Arial Regular 12pt (I've tried various other
fonts also).

Cell Format: Horizontal - set to general, Vertical - set to top
Text control: Wrap text checked, Merge cells checked.

The aim of the file is for invoicing - therefore I need to write
sometimes a lenghty description down. It therefore is sensible to set
the cells as above.

Got any ideas?

Phatz

I have seen a problem similar to what you describe with a file in which
the Page Setup was set to zoom to a certain percentage and the Print
Quality was set to "Normal." Which version of XL for the Mac are you
using? I suspect that if the Print Quality of your file is "Normal"
that file might have been created in a different version or even
perhaps in Windows. The default print quality for XL 2004 on the Mac is
"High". The print quality would be saved with the file and if it were
set to something else it might get converted to "Normal" when opened in
your version. "Normal" is not NORMAL and prints at a lower quality. I
was able to fix the problem that I found by either changing the
percentage of zoom OR changing "Normal" to "High". High is obviously
the best solution. I believe this was sent to Mac Office Testing as a
possible problem in at least XL2004 and perhaps earlier. The fix
however is easy. Please let us know if this helps.
Thanks,

D.R.Durham

 

[Phatz]

Mr Durham

You are a diamond - perfect and such a simple solution. I have been
though the houses with Microsoft tech support and there only resolve
was that I should wait for the updates and eventually there would be a
fix for my issue.

Thanks once again

a much happier chap - phatz