Excel Add-In Version 7.5.0

June 19, 2018 - Build 6430

The supported versions of Excel include the following: Excel 2010, Excel 2013, and Excel 2016. Although not explicitly supported, there are currently no known issues when using the add-in with Excel 2007.

The supported versions of Essbase include 9.3.0 and higher.

This release contains the following fixes and changes:

  • Essbase Retrieve – Fixed issue where Excel auto-filtering was being removed when an Essbase retrieve was performed. #1938

  • In version 7.2.0.5810, the following inconsistency with the Classic Essbase Add-In behavior was addressed, but was not applied to retrieves performed using the EssVRetrieve and EssMenuVRetrieve VBA functions: When non-numeric text appears in cells located to the right of a cell (or cells) that contains a numeric value, the non-numeric text is not retained when a retrieve operation is performed. To be consistent with the Classic Essbase Add-In behavior, the non-numeric text is now retained. #1684

  • For consistency with the Classic Essbase Add-In, leading blanks or spaces are no longer removed when a cell value also contains trailing blanks when performing an Essbase operation. Note that any value intended to represent a member within the retrieve range which contains trailing blanks or both trailing and leading blanks is treated as an unknown member. #1981

  • Input Processing – Keyboard and mouse input processing functionality has been incorporated into the Dodeca Excel Add-In, rather than being accomplished via a distributed third-party assembly. The incorporated functionality makes use of portions of the following library, which is released under the MIT license and to which, alone, the constraints of the MIT license apply. #1959

    GlobalMouseKeyHook Copyright© 2010-2018 George Mamaladze (https://github.com/gmamaladze/globalmousekeyhook)

  • License Validation Failure – When the ShowWarningMessageForInvalidLicense configuration setting was False, and license validation failed because the application server was not available, an error message similar to the following was presented to the user: “Unable to write or send LicenseInfo request. Unable to connect to the remove server.” With this release, when the server is not available, the error message is suppressed or shown based on the ShowWarningMessageForInvalidLicense configuration setting. #1929

  • When the license or user validation fails, the following error occurs when the open workbook is closed after the “The Dodeca license could not be validated” notification is displayed, and then reopened within the same instance of Excel: EssbaseExcel.ActiveWorksheetName.Get failed. Exception from HRESULT: 0x800401A8 #1967