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 (, NetAdvantage 2020, Volume 2 (20.2.30), Aspose.Cells 19.5.0, Syncfusion Essential Studio, GdPicture.NET, 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 are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions 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 ViewSelectorTree to display a view hierarchy containing almost 2000 categories and views. This issue was introduced in #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 #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 #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 #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 #2954

Essbase Views

  • Fixed Issue: When an Essbase Excel view’s DataCellDoubleClickPolicy is 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 #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.ZoomLevel property. This issue was introduced in #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 #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.

Excel Behavior

  • 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 ShowViewAsActiveWindow tool 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 ShowViewAsActiveWindow method argument was also added to the OpenView workbook 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 OpenView workbook script method from within the CellDoubleClicked event link, in which case the current view is always retained as the active window. #2613, #2979

SQL Passthrough DataSets

  • Fixed Issue: When the query DatabaseCursorType property 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 #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 DateTime column 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 #2986

    Specified argument was out of the range of valid values. Parameter name: Invalid date-time serial number.

  • Fixed Issue: When a DateTime column 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 #2975

  • Fixed Issue: A column declared in the database as a Date is returned from the server and displayed in the client as a DateTime value. Although this issue was encountered using an Oracle database, the issue may also exist with other databases. This issue was introduced in #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 #2990

Workbook Scripting

  • Fixed Issue with ServerTime function: When the optional TimeZone argument is not specified, the following error occurs. This issue was introduced in #2966

    Unable to send the ServertimeService request. The specified TimeZone is invalid.

  • Fixed Issue with AddDataCache method: When the method is used with an Essbase view, which has the Asynchronous property 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 #2969

  • Fixed Issue with OpenView method: Refer to Open View Tool Controllers for the details. #2613, #2979

  • Reversed change to the UpdateBinaryArtifact method CSVFile overload: 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 UpdateBinaryArtifact method’s CSVFile overload 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 SendEmail method 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.