+ Reply to Thread
Results 1 to 5 of 5

Excel 2010 - shape alignment problem

  1. #1
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Excel 2010 - shape alignment problem

    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?
    If you like my contribution click the star icon!

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2010 - shape alignment problem

    I can confirm the same behaviour in 2013. It is perhaps deliberate - intended to illustrate that it is not a straight connector - or perhaps a bug. Is there a reason for using a curved connector when you want it to look straight?

  3. #3
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Excel 2010 - shape alignment problem

    @romperstomper,

    many thanks for your reaction. Frustrating that it is there in 2013 as well. I am using the curved connector because the VBA solution generates a flow of shapes representing activities for a runbook (> 500 tasks per day), with many branches and connections between tasks reflecting dependencies between steps. I personally think the curved connector looks the prettiest.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2010 - shape alignment problem

    Then I fear you are stuck using one of the workarounds you mentioned, or checking if the two shapes are at the same level and, if so, resetting the connector height.

  5. #5
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Excel 2010 - shape alignment problem

    @romperstomper, I have not given up hope yet, maybe somebody knows the root cause / solution. Thanks for your feedback though!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1