Excel：令人难以置信的收缩和扩展控制 [英] Excel: the Incredible Shrinking and Expanding Controls
问题描述
代码中的任何内容都没有指示这一点，偶尔会发生在一个电子表格中，这个电子表格会受到魔术按钮或列表框的影响。
有没有人体验过这种喜悦？
这个问题似乎与Windows处理非本地分辨率在显示器上的方式有关，可以在几个方式
发生这个问题可能是一个完整的噩梦，但它只会间歇性地发生。
我们最近一直在测试由几十个人使用的excel工作表，并且已经开发了一个很好的原因和一些可能的修复。
原因似乎与屏幕用于其他本机分辨率以外的任何设置相关。如果用户将外部显示器插入笔记本电脑，并且不会仔细选择所得到的屏幕配置，这可能会轻松发生。例如，如果笔记本电脑插入投影机（可能是使用本机1024×768显示器的旧笔记本电脑），但笔记本电脑是1280×800，并且用户选择复制显示器，而不是延伸（Windows 7中的连接到投影机或显示控制面板中的设置），结果是两个屏幕上的非原始分辨率都是不可预测的，通常不令人满意的图像。我们发现这些设置几乎总是导致Excel按钮，尤其是ActiveX控件的严重问题。有时候，一再点击，它们缩小到不可读性;其他时候，它们扩展到覆盖整个屏幕。
大多数情况下，当我们指示用户使用扩展显示设置，结果是两个屏幕都使用原生分辨率，我们看不到问题。
还有基于代码的方法来最大限度地减少问题。我们尝试重新设置按钮和控件的位置和大小，当它们被点击时（如果你有很多按钮，它会增加很多繁琐的代码）。这有时候有效。我们还尝试将autosize属性从true切换为false并返回（这在开发人员模式下手动工作），并且这会修复更多的实例，但并不是全部。
Occasionally, I'll happen across a spreadsheet which suffers from magic buttons or listboxes which get bigger or smaller over time.
Nothing in the code is instructing this.
Has anybody else experienced this joy?
The problem seems to relate to the way Windows handles non-native resolutions on monitors and can be avoided in several ways
The problem can be a complete nightmare when it happens, but it only happens intermittently.
We have been testing recently an excel worksheet used by a few dozen people and have developed a good idea of the cause and some possible fixes.
The cause seems to relate to any setup where screens are used in something other than their native resolution. This can happen easily if a user plugs an external monitor into a laptop and doesn't choose the resulting screen configuration carefully. For example, if a laptop is plugged into a projector (perhaps an old one with a native 1024 by 768 display) but the laptop is a 1280 by 800 and the user chooses to duplicate the display rather than extending it (settings in "connect to a projector" or "displays" control panel in Windows 7), the result is an unpredictable and usually unsatisfactory image on both screens with both in non-native resolutions. We have found that these settings almost always cause serious problems with Excel buttons, especially ActiveX controls. Sometimes, on repeated clicks, they shrink to unreadability; other times they expand to cover the whole screen.
Mostly, when we instruct users to use the extend display setting and the result is two screens both using native resolutions, we don't see the problem.
There are also code-based ways to minimize the problem. We tried resetting the location and size of buttons and controls when they were clicked (which adds a lot of tedious code if you have a lot of buttons). This sometimes worked. We also tried toggling the autosize property from true to false and back (this works manually in developer mode) and this fixes more instances, but not apparently all.
这篇关于Excel：令人难以置信的收缩和扩展控制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
