Dodeca Version 8.4.1

December 13th, 2024 - Build 77

This version of the Dodeca Framework uses the .NET Framework, version 4.7.2 and higher on the desktop. The components used in this version of Dodeca are SpreadsheetGear 2023 (9.2.44.102), NetAdvantage 2021, Volume 2 (21.2.46), Aspose.Cells 24.8.0, Aspose.Slides 24.8.0, Syncfusion Essential Studio 25.1.39, GdPicture.NET 14.1.0.121, 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 8, 11, 17, and 21. The Dodeca-Essbase connector (for all Essbase versions) is supported and tested on Java 8, 11, 17 and 21.

This release notes for this version contain the following items:

Dodeca Shell

  • Updated the LiquibaseSchemaMigrator code that powers the upgrade command to enhance robustness against unexpected artifacts in older Dodeca repositories. This update also adds support for custom upgrade bundles, addressing occasional repository upgrade issues reported in the field and ensuring a smoother upgrade experience. #3926, #3922, #3928, #3894

Essbase Connector

  • Fixed Issue: The absence of the JAXB-API XML parsing libraries in the default Java distribution (starting with Java 11) caused errors in the Essbase Connector. The JAXB-API library is now included in the Essbase Connector distribution, preventing users from encountering the following error: Implementation of JAXB-API has not been found on module path or classpath. #3913

PowerPoint Exports

  • Fixed Issue: When scaling a PowerPoint export, the image on the resulting PowerPoint slide is not centered. If no scaling is used, the image is centered. #3845

  • Added support for a Chart export type, which allows charts to be exported to PowerPoint. #3846

View Selectors

  • Enhanced the usability of the ViewSelectorExplorerBarTreeHybrid view selector type by eliminating horizontal scrollbars within each section and introducing a vertical scrollbar for the entire selector when necessary. #3885

  • A new setting, CacheNodeExpansions has been added to manage the caching of the view selector node expansion states. When CacheNodeExpansions is set to True, the expansion states of view selector nodes are cached for future sessions. Conversely, setting CacheNodeExpansions to False ensures that these view selector expansion node states are not cached, providing a fresh state upon each session. #3844

Workbook Scripting

  • Fixed Issue: The @ACell() function may return an incorrect cell address when debugging workbook scripts containing nested ExecuteProcedure methods. #3841

  • Fixed Issue: Hidden worksheets that contain dataset ranges built using the BuildDatasetRange method during the AfterDatasetRangesSave event were briefly unhidden in the UI. #3639

  • New Event Link: An UnknownMembersDetected` event has been added. The new event occurs when a retrieve operation detects unknown members. #3295

    The event link’s properties include:

    • Operation, The name of the Essbase operation.

    • RangeName, The defined name or reference of the retrieved range. When the "used range" is the retrieved range, the property value is null.

    • SheetName, The name of the sheet that contains the range.

    • StrictMode, Whether the Essbase operation was done with strict mode on. (True/False)

    • UnknownMemberNames, A semicolon-delimited string of the unknown member names.

Workbook Scripting Functions

  • New Function: The UnknownMembers function returns a semicolon-delimited string of the unknown member names. #3295

    Usage
    @UnknownMembers(<WorksheetName>, <RangeName>)
    Parameters

    • WorksheetName - Optional (defaults to the active worksheet.); The name of the Worksheet that has unknown members on it.

    • RangeName - Optional (defaults to entire worksheet); The name of the range that has unknown members in it.