Misalignment of controls after insertion or categories addition

Hi Jeffrey,

The mis-alignment of controls is a bug in Excel that’s very annoying. We’ve built a workaround into Modano to address this as follows:

1. Activate the workbook containing the mis-aligned/misplaced controls; then
2. Go to the Build tab, Content group, Forms menu, Refresh Workbook Controls.

This should fix your workbook.

The issue is caused by the fact that Modano tries to insert controls such that they hide when their rows or columns are collapsed (if grouped) and/or hidden. If this issue persists on your computer, you can switch off this functionality by unchecking the ‘Allow controls to move and size with cells if possible’ check box within the Modano Options dialog – which you can access via the Modano tab, Options – as shown below:

This should resolve your issue one way or another.

M.

A few more comments on this guys:

1. The issue seems most common when users are using high-resolution monitors that require scaling – i.e. resolution greater than the default 1920x1080 that we use, often scaled up to 125% or 150% because everything is too small. Always check for this, and try running at 100% scaling or using your primary monitor if you have multiple screens.
2. Unfortunately the Refresh Workbook tool (Controls Build tab, group, Refresh Workbook Controls) sometimes, but not always, works.
3. This issue appears more common to older versions of Excel, so ask the client to update to the latest version of Excel (via the File tab, Account button, Office Updates menu).
4. If all else fails, you can always replace the dropdowns with in-cell list validation, which can be most easily done by cutting and pasting the cell link cell block off to the right or into a new row (grouped to level 3 and hidden), changing its cell style to Number with 1 decimal place, and entering an INDEX/MATCH formula into it. Then no changes to dependent cell block formulas are required.

Hope this helps, it's very frustrating stuff.