I have a problem with aligning two shapes (rectangles) and drawing a curved connector between them. I generate a complex flow chart for run book dependencies using VBA. This routine worked flawless in Excel 2003 (albeit different workstation and different printer), but I am experiencing alignment issues since the migration to 2010. I am describing my problem using two manually created shapes and a connector.
My process:
step 1: create a rectangle without any of the 2010 features (shadow, reflection, 3d etc) - just a basic shape
step 2: create a copy (copy & paste) of the first rectangle - move the 2nd rectangle to the right
step 3: align the shapes vertically (using 'align top')
step 4: draw a straight connector between the shapes (from shape1 right side to shape 2 left side)
no problems
Now instead of drawing a straight connector, I draw a curved connector and would sill expect to see a straight line and the shapes are aligned properly. Unfortunately the curved connector shows a wiggle which I want to get rid off. Aligning to top or bottom does not solve the problem, manually trying to align is nearly impossible.
What I have noticed/tried:
- the height of he connector is shown as 0.04 - when changed to 0 the connector is/becomes straight - but as soon as you move the shape, the problem is back
- 'snapping to grid' or 'snapping to shape' does not solve the problem
- using different shapes types (textbox, flowchart etc) makes no difference
- when I align the 2nd shape via VBA and position shape 1 on 57.75 and shape 2 on 57.74992 - the resulting connector is straight!
- when I rotate both rectangles by 180 degrees (upside down) they align properly ('align to top') and the resulting connector is straight - even when shapes are moved back and forth
- saving as Excel 2003 does not provide a solution
My feeling so far is that there is something strange about the shape object and the connector. It could be Excel 2010 related, display driver or printer driver related, but it is annoying me terribly. I have tried google but have been unable to find any matching problem description.
Any ideas?
Bookmarks