Dodeca Version 8.0.3
October 12, 2021 - Build 36
This version of 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 (188.8.131.52), NetAdvantage 2020, Volume 2 (20.2.30), Aspose.Cells 19.5.0, Syncfusion Essential Studio 184.108.40.206, GdPicture.NET 220.127.116.11, 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 18.104.22.168 are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions 22.214.171.124 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 sections:
Application Behavior and Performance
Fixed Issue: Client-startup performance degradation occurs in 8.0/8.0.1/8.0.2 when the View Selector contains a large number of views. The behavior was encountered for an application that uses a
ViewSelectorTreeto display a view hierarchy containing almost 2000 categories and views. This issue was introduced in 126.96.36.1999. #2982
Fixed Issue: When a view or metadata editor is opened, a momentary but noticeable flash of a small square section in the upper left corner of the current active window is shown. This issue was introduced in 188.8.131.529. #2977
Fixed Issue: There are cases when a comment, after being saved from the client, does not appear as a comment after the view is rebuilt, or when another view references the same comment. The issue is related to the computation of the key hash used to identify the comment, which is based on the key items, so the behavior is not encountered for all comments and appears to occur inconsistently. This issue was introduced in 184.108.40.2069. #2971
Fixed Issue: The following error occurs when comments are loaded during the build processing if a cell within a comment range has the same key items as another cell in the same comment range. This issue was introduced in 220.127.116.119. #2972
Error syncing the comment. The given key was not present in the dictionary.
Fixed Issue: Comment audit logging includes an entry when a comment is deleted in the Comments Explorer, but not when a comment is deleted in the cell. #2866
Dodeca Metadata and Essbase Servlets
Fixed Issue: The Dodeca metatadata and Essbase servlets fail to deploy in Websphere. This issue was introduced in 18.104.22.1689. #2954
Fixed Issue: When an Essbase Excel view’s
DataCellDoubleClickPolicyis OpenViewForDrillthrough, and the user double-clicks a data cell, the opened drill-through view’s window is displayed, but the Essbase Excel view’s window is then reactivated temporarily before the opened view’s window is activated again. This issue was introduced in 22.214.171.1249. #2914
Fixed Issue: When an asynchronous Essbase view uses a context menu or toolbar that contains the Zoom In (Next Level), Zoom In (All Levels), or Zoom In (Bottom Level) tools and a zoom in operation is initiated by clicking any of these tools, the result of the operation always reflects the zoom level defined by the view’s
EssProperties.ZoomLevelproperty. This issue was introduced in 126.96.36.1999. #2961
Fixed Issue: When an asynchronous Essbase view uses multiple selectors associated with the same Essbase connection and the user cancels or dismisses the login dialog, an error similar to the one below can occur. This issue was introduced in 188.8.131.529. #2997
Unable to open view "Income Statement". The view "Income Statement" window cannot be initialized. Unable to setup selectors. Unable to create selector "3_Product". Adding the specified count to the semaphore would cause it to exceed its maximum count.
Fixed Issue - When attempting to copy from a workbook saved from Excel 2019 and paste into a workbook in Dodeca, the following error can occur: Corrupt workbook stream. #2965
Open View Tool Controllers
Fixed Issue: In 8.0, the
ShowViewAsActiveWindowtool argument was added to support the ability to control whether the view opened by an Open View tool controller becomes the active window, which is the default, or the current view is retained as the active window. A
ShowViewAsActiveWindowmethod argument was also added to the
OpenViewworkbook script method. In 8.0/8.0.1/8.0.2, the opened view always becomes the active window, regardless of the argument value, except when called by the
OpenViewworkbook script method from within the
CellDoubleClickedevent link, in which case the current view is always retained as the active window. #2613, #2979
SQL Passthrough DataSets
Fixed Issue: When the query
DatabaseCursorTypeproperty is set to ForwardOnly, the following error occurs when the client attempts to connect to a Snowflake database. A similar error will occur with any database that requires the ForwardOnly cursor. This issue was introduced in 184.108.40.2069. #2962
SQLPassthroughDatSet: <data set ID>, DataTableName <data table name>, SQL Error Code: 200035, SQL State Code: 0A000, ResultSet type 1004 is not supported.
Fixed Issue: When a
DateTimecolumn is used to store a time (without a date), and the value of the time is entered and saved from the client, a subsequent attempt to rebuild or close the view results in the error below. This issue was introduced in 220.127.116.119. #2986
Specified argument was out of the range of valid values. Parameter name: Invalid date-time serial number.
Fixed Issue: When a
DateTimecolumn is used to store a date (without a time), and the value of the date is entered and saved from the client, the date saved in the database is the day prior to the entered date. This issue was introduced in 18.104.22.1689. #2975
Fixed Issue: A column declared in the database as a
Dateis returned from the server and displayed in the client as a
DateTimevalue. Although this issue was encountered using an Oracle database, the issue may also exist with other databases. This issue was introduced in 22.214.171.1249. #2974
Workbook Analyzer Utility
A workbook that contains any defined names that refer to an address which starts with an exclamation mark, such as "!$B$79:$AB$17", is not compatible with the SpreadsheetGear grid control used by the client, and cannot be opened in Dodeca. #2953
In 8.0/8.0.1/8.0.2, the Workbook Analyzer Utility fails with the following error when attempting to clean a workbook which contains incompatible defined names: Analysis failed with exception: WorkbookParser is null.
This issue has been addressed, which allows the workbook to be analyzed and cleaned. In addition, the analysis detects and lists the incompatible defined names.
Workbook Script Editor
Fixed Issue: When a Windows Display Scale and layout is set to 125%, the user is not able to insert a workbook script function from the dropdown list or to enter a value in the Edit Value dialog in the Workbook Script Editor. #2963
Fixed Issue: The Bookmark buttons do not work. This issue was introduced in 126.96.36.1999. #2990
Fixed Issue with
ServerTimefunction: When the optional TimeZone argument is not specified, the following error occurs. This issue was introduced in 188.8.131.529. #2966
Unable to send the ServertimeService request. The specified TimeZone is invalid.
Fixed Issue with
AddDataCachemethod: When the method is used with an Essbase view, which has the
Asynchronousproperty set to True, and the method’s Initialize argument is TRUE, the values in the data cache are not cleared. This issue was introduced in 184.108.40.2069. #2969
Fixed Issue with
OpenViewmethod: Refer to Open View Tool Controllers for the details. #2613, #2979
Reversed change to the
CSVFileoverload: In 8.0, the overload was changed to require that the extension of the file, which is specified as the Filename argument, must have a .csv extension. This requirement has been removed in 8.0.3. #2994
New Method Argument: A FileTrimWhitespace argument has been added to the
CSVFileoverload to allow for controlling whether whitespace in field values will be trimmed. In prior versions, field values were trimmed whenever a separated values file was converted for import. #2976
New Method Arguments: AttachViewAsPDF_Compliance and AttachViewAsPDF_Optimization arguments have been added to
SendEmailmethod to allow for compliance management and size optimization of attached PDFs. The AttachViewAsPDF_Compliance option can be set to None to ensure that image transparency is retained in attached PDFs. #2980
AttachViewAsPDF_Compliance - Indicates whether to produce a PDF/A-1b compliant PDF. The default is PDF/A-1b.
AttachViewAsPDF_Optimization - Indicates whether to produce a standard or size-optimized PDF. the default is Standard.