Edit shape with snap to grid on only allows movement down and righ

[reb197]

To reproduce this problem:

Switch on Align->Snap to Grid.
Draw a rectangle in the middle of the sheet.
Edit Shape->Convert to freeform
Edit Shape->Edit Points

Try dragging the top left point around - you can move it to the right and
below its original position but not above or to the left of it.

Adding an additional point completely throws it. The additional point snaps
to a mysterious grid all of its own!

Anyone have a workaround / fix for this?

 

[ShaneDevenshire]

Hi,

What program are you using? None of my versions of Excel have a command
called Edit Shape. Also, my versions have a command Draw, Change AutoShape
but they won't let me convert a rectangle to a freeform?

 

[reb197]

Hi,

I'm using Excel 2007.

The shape functions are under the Insert menu.

Thanks

 

[Andy Pope]

Hi,

Looks like this might be a bug.
I thought a possible work around would be to turn of the Snap to grid
and use the ALT key to align to cell border. Whilst this allows you to
drag the point in any direction when you press ALT the point jumps
straight back to it's starting position.

Cheers
Andy

 

[ShaneDevenshire]

Hi,

Actually its under Drawing Tools, Format, Insert Shapes group, Edit Shape.

Well you learn something new everyday! I haven't been doing much with shapes
in 2007 so I missed this obscurity.

This is apparently a bug.

 

[reb197]

Hi,

I didn't know about the alt key so thanks - that's a useful tip - but shame
the bug persists to that too.

Cheers
Rob.