Dodeca Version 8.3.6

August 20th, 2024 - Build 1329


This version of the Dodeca uses the .NET Framework, version 4.7.2 and higher on the desktop. The components used in this version of Dodeca are SpreadsheetGear 2017 (8.7.12.102), NetAdvantage 2021, Volume 2 (21.2.46), Aspose.Cells 22.10.1, Syncfusion Essential Studio 20.3.0.49, GdPicture.NET 14.1.0.112, Microsoft WebView2 1.0.1722.45, and Xceed Zip 3.6.7363.15420.

This version of Dodeca has two server-side services that run inside a Java Application Server. The Dodeca service is supported and tested on Java 1.8. The Dodeca-Essbase service for all Essbase versions prior to, and including, Essbase 11.1.1.3 are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions 11.1.1.4 and higher is supported and tested on Java 1.6. Both services are known to run on Java 1.7, 1.8, 1.9, and 1.10.

The release notes for this version contain the following items:

Application Startup

  • Fixed Issue: When a ClickOnce query string parameter contains a plus sign (%2B), the literal plus sign is incorrectly decoded to a space when the parameter is processed. If a plus sign is required in a query string parameter, it should be URL-encoded as %2B. #3765

Essbase Connector

  • Fixed Issue: When sending data to Essbase, under some circumstances, an error similar to the following can occur: Unable to perform Essbase update operation. Lock requested by user [<user>] is currently held by another user [<user>] performing [ActionNotFound], and waiting is currently not allowed. Requested block is [[<member>][…​]]. This issue was introduced in 8.3.0. #3766

  • Fixed Issue: Data audit log records are not created when sending data to missing cells or cells containing date or text measures. #3743

Essbase Views

  • Fixed Issue: When closing a view with unsaved changes, the user is prompted with an opportunity to save changes, but pressing Yes does not send the changed data to Essbase. This issue was introduced in 8.0.0. #3466, #3761

Excel AutoComplete

  • Fixed Issue: When an autocomplete range’s ItemNotInList policy is set to LimitToList, invalid values can be added by using the formula bar or clicking on another cell during cell text input. #3691

PowerPoint Export

  • Fixed Issue: When a view Export is configured with the ExportFileOption set to UpdateExisting and both the AllowUserToSpecifySourceFile and AllowUserToSpecifySaveAsFile set to True, if the chosen SaveAsFilePath is the same as the SourceFilePath, an unhandled exception similar to the following occurs: Add slide failed. Slide Name: ""; Exception: CustomLayouts.Item : Integer out of range. 2 is not in Index’s valid range of 1 to 1. #3803

  • Fixed Issue: When a view Export is configured to use a binary artifact as a source file, when attempting to set the SourceBinaryArtifactID, the UI can become locked until a binary artifact is selected. #3804

  • Fixed Issue: When a view Export is configured with the ExportRangesOption set to AllSheets, an unhandled exception occurs if the workbook contains a hidden sheet. #3805

  • Fixed Issue: When a view Export is configured with the ExportFileOption set to UpdateExisting and AllowUserToSpecifySaveAsFile set to False, if the chosen SaveAsFilePath is the same as the SourceFilePath, the chosen file is not updated. #3806

  • Fixed Issue: When a view Export is configured with the ExportFileOption set to UpdateExisting and AllowUserToSpecifySaveAsFile set to True, if the chosen SaveAsFilePath is the same as the SourceFilePath, a new file with a numeric suffix is created instead of updating the chosen file. #3807

  • Fixed Issue: When adding an export range to a view Export with the Export Ranges Editor, an error similar to the following can occur: Unable to handle cmdAdd.Click event. List box contains too many items. #3534

  • Fixed Issue: If PowerPoint is already running on the client computer when an export occurs, the exported file is not opened and displayed to the end-user. #3553

Selectors

  • Fixed Issue: When the selector list associated with a selector combobox depends upon another selector, under some circumstances, duplicate items can appear in the dependent selector combobox. #3755

SQLPassthroughDataSets

  • Fixed Issue: When executing a stored procedure in a insert or update statement, the ProcessGeneratedKeys setting is not honored, causing the operation to fail with the following error: The statement must be executed before any results can be obtained. This issue was introduced in 8.0.0. #3819

Toolbars Configuration Editor

  • Fixed Issue: When using the Ribbon Designer to edit a ribbon that contains a ribbon group without a caption, the following error occurs: Unable to process the "Ribbon Designer" command. Key required, Parameter name: Key. #3671

View Selectors

  • Fixed Issue: When an application’s ViewSelectorObjectTypeID is set to ViewSelectorExplorerBarTreeHybrid and a view is opened with a double-click, the containing explorer bar group can shrink and display a vertical scrollbar. #3687

Workbook Scripting

  • Fixed Issue: When an error occurs in a workbook script that contains a Workbook Script Set, but no procedures of its own, the underlying error message is suppressed, and the following error is presented instead: Value cannot be null. Parameter name: source. #3759

  • Fixed Issue with @MbrAlias function: When the @MbrAlias function is used without specifying the optional ConnectionID argument, the function can fail with the underlying error suppressed, and the following error is presented instead: Unable to cast object of type 'System.Exception' to type 'AppliedOLAP.Dodeca.Common.WorkbookScriptException'. #3701

  • Fixed Issue with EssbaseRunScript method: When the BackgroundExecute argument is checked and an error occurs during execution, the property specified by the ResultPropertyName argument receives both the boolean result and the error details. #3723