Update 27-Jun-2018: Although we have a fix for this issue on an internal build, it appears that Microsoft Office version 1807 (which is currently only available on the Office Insider track) fixes this issue. The missing user-interface problem was caused by a bug in Microsoft Office 1805/1806 updates. We will release our fix shortly, but the 1807 version update will also become available to everyone over the next month or so. If you want to get it immediately see How to get Office 365 insider builds.
Microsoft has recently released updates to both Windows (the April 1803 update) and Microsoft Office 2016 to provide support for multiple monitor high DPI (dots-per-inch) displays.
In the early days of Microsoft Windows, monitors were assumed to have 96 DPI and all applications worked on that assumption: with a user interface fixed on that assumption. In the last 15 years, monitors with higher DPI have started to appear with the benefit that on-screen text and graphics look much smoother because there are so many more dots per inch. That caused problems for many applications which were fixed to assume 96 DPI, causing their user interface to scale improperly on high-DPI monitors. Applications like Analyse-it supported high DPI monitors and adjusted their user interface appropriately... until now.
These days many of us have 2 or more monitors hooked up to a PC as it's a much quicker and more efficient way to work. Often these monitors are different sizes and often have different DPI, and the recent changes to Windows and Microsoft Office are designed to address varying DPIs. Instead of applications scaling their user-interface to one system-wide DPI setting, they now scale according to the monitor application is displayed on. If you have the latest updates to Windows and Office, and drag the Microsoft Excel main window between monitors with different DPIs you will see the application user interface rescale properly for the monitor.
This is a major new improvement and under the hood there are some major changes to Microsoft Windows to support it. Unfortunately, as with all major changes to Windows, it breaks some existing applications, especially add-ins like Analyse-it that are at the mercy of what the host application (Microsoft Excel in this case) decides to do with respect to user interface scaling. In the case of Analyse-it, when the new multiple monitor DPI awareness feature is enabled in Microsoft Excel 2016 the Analyse-it user interface does not appear properly in the task panes.
We are now working on a fix for this issue, but in the meantime, if you are experiencing this problem follow these steps to temporarily disable multiple monitor DPI awareness in Excel:
We will update this blog post when we have a fix available.
Microsoft officially released a couple of days ago, and Analyse-it version 4.20 now adds support for Excel 2016.
Over the next few weeks we will tweak the Analyse-it user interface so it matches the new Office 2016 user interface styles. Line styles on the plots in Excel 2016 now also appear a lot thicker, due to anti-aliasing (smoothing), so we will decide whether to address that in a future update – let us know what you think.
In clearly titling this blog post, we’ve probably already revealed the answer, but... Can you spot the difference between the two rows of values in the Excel spreadsheet shown below?
Sorry, it’s a trick question, because (visually) there is no difference. The difference is how the values are stored by Microsoft Excel. The value 57 in the cell on second row is actually stored as a text string, not a number.
A customer contacted us last week to ask how to refer to cells on an Analyse-it report worksheet, from a formula on another worksheet. The customer often used Analyse-it's refresh feature, to repeat the statistical analysis and update the statistics, and direct references to cells on the report were being lost on refresh.
As an example, suppose you have used Analyse-it linear regression to calculate the linear relationship between installation cost and the number of employees required, distance to the site, and the cost of machine being installed. Analyse-it would calculate the effect of each variable on the final cost, technically known as regression coefficients, which you can then use to predict installation costs for jobs in future.
Although the charts in Analyse-it are large so they’re easy to read when printed, sometimes you need to print a chart to fill the full page. You can do so easily, without resizing the chart, in just a few steps:
Chart size is only limited by the page size your printer supports.