March 31, 2021
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
Dodeca Excel Add-In for Essbase Release Notes