Excel Add-In Version 7.8.3

May 14, 2020 - Build 7209

The supported versions of Excel include the following: Excel 2010, Excel 2013, Excel 2016, and Excel 2019. 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 changes:

Member Selection Dialog

  • A new configuration setting, MemberSelectionDialog_CacheSizeAndLocation, has been added to control whether the screen location and size of the Member Selection dialog is cached and restored.

    When the MemberSelectionDialog_CacheSizeAndLocation setting is "true", which is the default, the screen location of the Member Selection dialog is cached when the dialog is closed and restored when the dialog is subsequently opened during the same session and across sessions, and the size of the dialog is cached and restored across sessions.

    The size of the dialog is always retained during the same session, regardless of the value of the setting. #2492

Spreadsheet Toolkit

  • Fixed Issue: When the EssVSetOption and EssVGetOption functions are used to set and get the WithinSelectedGroup and RemovedUnselectedGroup options, the options as applied are reversed. For example, calling the functions to set and get the WithinSelectedGroup options actually sets or gets the RemoveUnselectedGroup option and vice versa. #2415

Retrieve Sheets with Named Retrieve Ranges

  • Fixed Issue: The Retrieve Sheets with Named Retrieve Ranges tool retrieves the named retrieve ranges twice. #2500