Excel Add-In Version 7.8.7

March 31, 2021 - Build 7532


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:

  • Fixed Issue: In 7.7.0.6870, an unintended change was introduced, which prevents the ability to move a member from one cell to another cell in the same row by dragging and dropping the member with the right mouse button. Instead of moving the member to the appropriate cell, the member is pivoted. #2711

  • Fixed Issue: In 7.8.6.7413, an issue was introduced which prevents the use of named retrieve and send ranges. #2730

  • Fixed Issue: When a non-standard retrieve (zoom, pivot, etc.) operation is performed using a Spreadsheet Toolkit function, such as EssVZoomIn, and the specified range address extends beyond the retrieved data, the extraneous row/column cells are deleted. If a deleted cell is referenced by a formula, the formula results in a #REF! error after the retrieval. #2739

  • Fixed Issue: In the 7.7.0.6870 Release Notes, the Dodeca Spreadsheet Management System Integration section describes the ability to use named retrieve and send ranges in the Add-In. Starting with version 7.8.6.7413, only sheet-level named retrieve and send ranges are supported. For consistency, and to avoid unintended behavior, in 7.8.7, a named constant that represents a connection associated with a given retrieve or send range, must also be defined as a sheet-level name. #2740

  • Fixed Issue: The EssVZoomIn, EssVZoomOut, EssVRemoveOnly, and EssVKeepOnly do not allow the operation on non-contiguous cells. When non-contiguous cells are selected, EssVZoomIn returns an error status of -15 and the following error message: The function contains an invalid parameter. EssVZoomIn:selection. The specified range is a discontiguous range. #2748