Excel Print Problem: When pages are scaled drawing move

[Guest]

I wish I could attach a screenshot, a picture really is worth a thousand
words...

We have a few workbooks that contain drawing objects "on" certain rows,
these worksheets are *scaled* to fit on to certain paper sizes.
Now previewing and printing on Office 2003 (XP and Vista OS) works just fine
but on Office 2007 (again tested on XP and Vista) the drawing objects creep
down the page on both the preview and the actual printed page. When scaled
to 100% everything works as expected.

To test things out I created a fresh Excel 2007 format document and placed a
graphic on the first row, scrolled down to row 100 and placed a graphic
there. Print preview shows everything as expected. Now setting the scale to
50% and print preview shows the graphic from line 1000 on row 1008 with the
graphic on row 1 on row 1!

I've tried to eliminate everything, for example a fresh installation of XP
SP2 printing to the XPS printer results in the same bug. For reference we
have 3 flavours of workstations and HP Colour LaserJets (PCL5c) served on an
SBS server (but like I said I've tried to eliminate everything I could think
of).

This is driving me mad, can anybody help?

 

[emulchaey]

I wish I could attach a screenshot, a picture really is worth a thousand
words...

We have a few workbooks that contain drawing objects "on" certain rows,
these worksheets are *scaled* to fit on to certain paper sizes.
Now previewing and printing on Office 2003 (XP and Vista OS) works just fine
but on Office 2007 (again tested on XP and Vista) the drawing objects creep
down the page on both the preview and the actual printed page. When scaled
to 100% everything works as expected.

To test things out I created a fresh Excel 2007 format document and placed a
graphic on the first row, scrolled down to row 100 and placed a graphic
there. Print preview shows everything as expected. Now setting the scale to
50% and print preview shows the graphic from line 1000 on row 1008 with the
graphic on row 1 on row 1!

I've tried to eliminate everything, for example a fresh installation of XP
SP2 printing to the XPS printer results in the same bug. For reference we
have 3 flavours of workstations and HP Colour LaserJets (PCL5c) served on an
SBS server (but like I said I've tried to eliminate everything I could think
of).

This is driving me mad, can anybody help?

James - Did you happen to find a solution to your issue? We are
having the exact same problem and have found no answers on this
issue. Thanks in advance.

 

[Guest]

I'm afraid not, I've looked long and hard, spending days on this issue. I'm
100% positive that it's an Office 2007 bug.
I seems like the only way Microsoft will help is if they're paid to look at
the problem through a support issue, who know how long it'd take.
There are so many other little issues with Office 2007 that we've decided to
wait even logner before rolling it out; basically like Vista I don't think it
was ready for release, with the release of VSTO 2008 they may be nearing
feature completeness and then maybe Microsoft will work on the bugs which
*reduce* funcionality vs Office 2003.

 

[James Brown]

This bug seems to have been fixed with the release of Office 2007 SP1. Just
a few more bugs to go and it'll be useable ;-)

 

[Shawna]

I have downloaded SP1 but I am still having the same problems. Is there some
trick to making it work? Thanks.

 

[James Brown]

Sorry Shawna but there was no trick, after installing 2007 SP1 on our
machines the issue went away. If I learn anything that can help I'll post
here.

James

 

[Shawna]

Thanks.

Sorry Shawna but there was no trick, after installing 2007 SP1 on our
machines the issue went away. If I learn anything that can help I'll post
here.

James

 

[Shawna]

I just received a call from Microsoft Support and it is a bug and they will
be fixing it in an update soon.