Excel Image Display Issues

Excel Image Display Issues

Most issues with incorrect image offsets are fixed in CMM-Manager 2021. However, there can still be issues for some users, and there are some troubleshooting methods described below to help resolve most issues.

Issues with the System Clipboard

The main method CMM-Manager outputs images to an Excel spreadsheet are by utilizing the system clipboard. If many applications are running that can potentially contend with the system clipboard, there could be issues with image output into an Excel spreadsheet.

  1. It is recommended making sure no other Office suite applications are running at CMM-Manager run-time. This includes Word, Outlook, PowerPoint, other instances of Excel, etc.
  2. Make sure no Clipboard manager applications might be running on the system.
  3. On newer builds of Windows 10, there is a Clipboard history manager that may be running which can be disabled:
    1. Search for Clipboard settings:

    2. Turn the Clipboard history from On to Off if set:

Issues with multiple monitors with mixed DPI settings

There is a noted issue when using Excel on a setup including multiple monitors set at different DPI scaling settings (example: 125% and 100%).

The image outputs will look okay when Excel is launched on the primary monitor:

There can be issues with the image output location looking slightly offset when Excel is set to launch on one of the secondary monitors:

If you are experiencing the problem described, please follow these steps to temporarily disable multiple monitor DPI awareness in MS Excel:
  1. Start MS Excel
  2. Click File > Options.
  3. In the General tab, at the very top of the options list, select Optimize for compatibility, then click OK.
    Note: if you do not see this option, then you should not be affected by this issue.

  4. The Optimize for compatibility option can also be selected on the bottom status bar if you click on Display Settings.

  5. Close and restart Excel.
The next time a report is exported from CMM-Manager, the images should now display properly in Excel.

    • Related Articles

    • Edit Report Header - Image or Text

      It's possible to replace text in the top of Report Header with your own image as shown below. CMM-Manager Report Header From Preferences... CMM-Manager Preferences>Report Choose the Image option and then specify .BMP image as shown here... ...
    • Troubleshooting CAD surface picking issues

      Depending on the design of the imported CAD, picking certain surfaces could yield unintended results as described below: Inability to select a specific edge accurately Points vector normal are not consistent across an edge  Points generated from a ...
    • Possible PDF View/Save issues and resolutions

      On more than one occasion, there have been reports of QX PDF Writer (aka NM PDF Writer for versions earlier than CMM-Manager 2020) not working as intended. Below is a list of possible issues and troubleshooting steps to resolve: Issue Troubleshooting ...
    • VB Script - End program or display error if Dim is Out of Tolerance

      You can retrieve report data into VB using the “GetReportInfo()” function. double GetReportInfo( CString sReportName, CString sReportType, int nIndex ) Return Value The value at the specified cell of the report if the function is successful. The ...
    • Troubleshooting - JogDisplayCsy error when connecting with Direct 2.0

      Please follow the instructions below to resolve the above titled issue: Close CMM-Manager For customers running CMM-Manager versions older than 2021, proceed to step a through c Download the hotfix here - ...