Moving shapes around - XL2007 bug?

[Mike]

Hi,

My company is switching over to XL2007 and I have some problems with how
2007 is handling shapes in a workbook I have created.

with shp
.top = .topleftcell.top+2
.left = .topleftcell.left+2
end with

in excel 2003 this works great for the worksheet
in excel 2007, for some reason, after this runs, the .topleftcell is now
actually the cell one row up and one column left of what started as the
..topleftcell.

Is this a bug in XL2007, or is there a change to the .top and .left
properties for shapes and ranges that could be causing this? Any workaround?

Another potentially related issue I've got is that whenever I open this or
another related workbook in XL2007, shapes (.jpgs and embedded excel charts)
that are not touched by macros are moving around - changing places or size on
a protected worksheet. If I close (not saving changes) and reopen,
everything may be fine, or something else may have moved/grown/shrank.

Any ideas? I'm opening and saving the files in Xl2003 compatibility mode,
as I'm one of the earlier people to switch over to 2007, but everyone is
doing so in the next while.

 

[Martin Brown]

Hi,

My company is switching over to XL2007 and I have some problems with how
2007 is handling shapes in a workbook I have created.

with shp
.top = .topleftcell.top+2
.left = .topleftcell.left+2
end with

in excel 2003 this works great for the worksheet
in excel 2007, for some reason, after this runs, the .topleftcell is now
actually the cell one row up and one column left of what started as the
.topleftcell.

Is this a bug in XL2007, or is there a change to the .top and .left
properties for shapes and ranges that could be causing this? Any workaround?

Be sure you have applied SP1 - many graphical errors and strange quirks
were fixed by that.

They changed the definition of some of the shape operations. Sometimes
the help actually tells you how. Unclear why it was done. I had some
cursors that were width zero vertical lines in XL2003 and became
diagonal lines to the origin in XL12007.

Another potentially related issue I've got is that whenever I open this or
another related workbook in XL2007, shapes (.jpgs and embedded excel charts)
that are not touched by macros are moving around - changing places or size on
a protected worksheet. If I close (not saving changes) and reopen,
everything may be fine, or something else may have moved/grown/shrank.

Any ideas? I'm opening and saving the files in Xl2003 compatibility mode,
as I'm one of the earlier people to switch over to 2007, but everyone is
doing so in the next while.

I have seen the odd one go invisible when clicked on for no apparent
reason, and a race condition where the drawing order on a multiprocessor
box means that shape object names may not be what you expect them to be.
Defending against these new features is tricky.

The worst one I have encountered is with the glacially slow charting in
XL2007 where under some circumstances you cannot modify the axis scale
reliably from VBA when large amounts of data is being plotted without
adding a long delay to what is already a very tedious slow process.

I have also seen some very strange behaviour with Dir() directory
searches in VBA using XL2007 and Vista where some files are missed.

Regards,
Martin Brown