Dodeca Version 8.3.3

October 30, 2023 - Build 84

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.5.0, Syncfusion Essential Studio 20.3.0.49, GdPicture.NET 14.1.0.112, Microsoft WebView2 1.0.1518.46, 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:

Commentary

  • Fixed Issue: When using the Comments Explorer to reply to a comment, if the comment being replied to does not contain a subject, an error similar to the following occurs: Unable to respond. Object reference not set to an instance of an object. #3565

EPM Cloud Planning Connector

  • When utilizing DeviceCode authentication, an OfflineAccess property has been added (and can be set to False) to prevent the inclusion of the offline_access scope. This is useful for EPM Cloud applications that do not allow offline access and/or the utilization of refresh tokens. #3589

Essbase Connections

  • Fixed Issue: When an Essbase connection is configured as stateful, i.e. the Stateless property is set to False, closing the client application after using the connection does not always disconnect the corresponding Essbase connections on the server.

    Since connections in Dodeca are not shared across instances of the client application, the behavior of the Dodeca-Essbase Connector has been changed, such that each client instance is provided a dedicated Essbase connection pool. When the client application is closed, each connection associated with the client instance is disconnected (and the connection pool is disposed). Connections with elevated permissions, which are used for certain privileged operations, are now marked as stateless and automatically disconnected after the privileged operation is complete. #3503

License Status Reporting

  • In Dodeca 8.3.3 and higher, licensed user count overages for the Dodeca Excel Add-In are only indicated when running an administrative application in the Dodeca Excel Add-In management tenant. #3558

PowerPoint Export

  • Fixed issue: If the user cancels a PowerPoint export when prompted to choose the destination ("save as") file, an unhandled exception occurs. #3552

  • Fixed issue: When a view Export is configured with AllowUserToSpecifySaveAsFile set to False, if the SaveAsFilePath file path does not include a fully qualified folder path, an unhandled exception occurs after an error similar to the following: No folder specified for file: "<filename>". #3533

  • 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

Request / Response Logging

  • Added support for logging arbitrary HTTP requests and responses via the standard, administrative Log Application Request and Response XML to Client tool. In Dodeca 8.3.3, this primarily applies to HTTP requests sent in service of the EPM Cloud Planning Connector. Sensitive headers such as Authorization, Username, and Password are excluded from the captured requests and responses. #3578

Ribbons

  • In previous versions, when the Ribbon Designer is used to add a tab to a ribbon or a group to a tab, the new tab or group’s Key is a string that is similar to 22342a3a-8e8c-4ae7-80cf-6f661dd199bc, which is not descriptive and is not easy to access or change. The SetToolbarVisible method can be used in a workbook script to set the visibility of a group, and the group’s Key must be specified as the ToolbarKey. In 8.3.3, the Ribbon Designer has been changed to set the Key value to the tab or group’s Caption. #3524

    • If the tab or group’s caption matches the key of an existing tab or group, such as New Group, then a unique Key is constructed, such as New Group1.

    • If the tab or group’s caption is subsequently changed by the developer, the key and caption will no longer match, but the key can be changed by navigating to the ToolbarsManager → Ribbon → Tabs, and for a given Tab to the tab’s Groups collection.

    • If the tab or group was created prior to 8.3.3 and a new tab or group is created in 8.3.3 or a later version, the key of any pre-existing tab or group is also changed to the associated caption.

SQL Connections

  • Fixed Issue: Tokenization of the SQL Connection’s DataSource property is not supported, although the documentation displayed in the SQL Connections Metadata Editor property grid indicates that it is. In Dodeca 8.3.3 and higher, the following SQL Connection properties can be tokenized: ConnectionURL, DataSource, LoginDialogCaption, Username, and Password. #3507

SQL Excel Views

  • Fixed Issue: When one or more SQLPassthroughDataSet records is added, updated, or deleted within a SQL Excel view, and the user attempts to close the view before saving the changes, pressing the Save button when prompted does not save the records. This issue was introduced in 8.3.0. #3547

SQLPassthroughDataSets

  • Fixed Issue: When SQLPassthroughDataSet records are queried that contain DateTime columns and data with millisecond precision, the Dodeca client loses milliseconds on the records and treats the data as changed. This causes the view to prompt the end-user that there unsaved changes to the data (when the user hasn’t made any changes), and further, causes milliseconds to be dropped from the values that contain them when changes are saved. #3546

  • Fixed Issue: When inserting or updating a null value into an Oracle database column, if the SQLPassthroughDataSet column definition’s JDBCType property is set to NUMERIC, the null value is not inserted (or updated), and an error occurs. #3523

Workbook Analyzer

  • Fixed Issue: Trailing empty columns are not removed when the Remove empty trailing columns option is chosen. #3514

Workbook Script Editor

  • Fixed Issue: Masked password argument values can be copied by any user with access to the Workbook Script Editor. #3572

  • Fixed Issue: When the Expand/Collapse All button tool is pressed after deleting a procedure, an error similar to the following occurs: The "Expand all procedures" command failed with the following error: Object reference not set to an instance of an object. #3538

Workbook Scripting

  • Fixed Issue: When using the CommentOperations method with the DeleteByCommentID overload, if the specified comment is not in context in the view, an error similar to the following occurs: Object reference not set to an instance of an object. #3518

  • Fixed Issue: The BeforeDataSetRangesBuild, AfterDataSetRangeBuild, and AfterDataSetRangesBuild events were not being raised in the SQL Excel view. This issue was introduced in 8.3.0. #3529