Dodeca Version 7.8.3

Fixed Issue: In version 7.7.0.6870, Essbase Excel Views, a dependency was introduced in the Export to Excel tool on the AllowSave property, which requires the property be set to True to enable the tool. This dependency has been removed; however, with the change in 7.7.0.6870, the tool is automatically disabled when a point-of-view selection changes. After building or refreshing, the tool is enabled. #2480

Enhancement: The MemberExpansionFilters of the EssbaseSelectorTreeView have been extended to support members being hidden or shown on the basis of the number of their ancestors that are represented in the tree. This can be useful for displaying a list of arbitrary members as root nodes in the tree while limiting the number of expandable descendant generations. #2484

Fixed Issue: When the view’s EssbaseConnectionID is tokenized, clicking almost any tool in the designer results in an error similar to the following: Unable to refresh tool controller "EssbaseAdhocOperationRedoMenu". The Essbase connection "[T.Cube]" does not exist. #2445

An inconsistency between Excel and Dodeca, which is related to auto-filtering, has been addressed. It is exhibited when a single cell (or adjacent cells in a single row) is copied and pasted into a selected range, which is within a filtered range, and the selected range intersects rows that are hidden as a result of an active filter. Under these conditions, Excel does not paste values into the hidden cells. In Dodeca, the values are pasted into the hidden cells.

Fixed Issue: When an HFM connection is assigned to an adhoc view, an error similar to the following is encountered when attempting to open the view: #2456

Fixed Issue: The CELL("width", …​)` worksheet function does not recalculate when column widths or column hidden state is changed. For example, when the column is within a group, and the user collapses the group. #2444

Fixed Issue: When the application’s CulturePolicy and a view’s CulturePolicy are set to UseWindowsCulture, and the regional settings for window’s culture uses a non-comma List Separator, the Unhide Rows and Columns tool fails when the hidden rows or columns are represented by discontiguous ranges. The error message is similar to the following: EssbaseSpreadsheetGear.SetRowsHidden failed: "1:1,11:13" is not a valid range or reference for sheet "Income Statement." #2475

Fixed Issue: The argument value editor dialog does not retain the font size after being changed, following the second subsequent edit. #2467

Fixed Issue: When the Properties section contains more properties than can fit vertically in the Workbook Script Editor window , the following error occurs when the Event Links section is toggled from hidden to visible: The Event Links command failed with the following error: SplitterDistance must be between Panel1MinSize and Width - Panel2MinSize. #2470

Fixed Issue: When a SQL View has a dataset range configured with the AutoBuildOnViewBuild property set to False, and the BuildDataSetRange workbook script method is subsequently called, the dataset range is not retrieved. If the Workbook Script Debugger is open when the method is called, an error similar to the following is displayed: Error building the SQLPassthroughDataSetRange 'MyDataSetRange'. SQLExcelView.BuildAsync does not support multiple concurrent invocations. #2443

Fixed Issue: When a workbook script deletes rows from a named retrieve range after building the view, and then calls EssbaseRetrieve.Range to synchronize the representation of the data retained in memory to reflect the deletions, any workbook script Essbase functions, which use the internal representation, will subsequently return results based on the data retrieved during the build. #2457