Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving shapes around - XL2007 bug?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving shapes around - XL2007 bug?
Mike wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Shapes | Excel Discussion (Misc queries) | |||
inserted shapes keep moving | Excel Discussion (Misc queries) | |||
XL2007 - Shapes - Adjust 'Smiley Face' | Excel Programming | |||
Moving Shapes within VBA | Excel Programming | |||
Moving Shapes with the mouse | New Users to Excel |