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 188.8.131.5270, 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 184.108.40.20613, 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 220.127.116.1170 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 18.104.22.16813, 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
EssVKeepOnlydo 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