Dodeca Version 8.4.3.59

January 31th, 2025 - Build 59

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.3.23.102), NetAdvantage 2021, Volume 2 (21.2.46), Aspose.Cells 24.10.0, Aspose.Slides 24.10.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:

Authentication Providers - SAML

  • Added support for signing SAML authentication requests and requesting that the identity provider sign assertions. The SAML service provider metadata generated by the client has been updated to include the service provider’s signing certificate and single logout service bindings. #3930

Commentary

  • Fixed Issue: The Comment Attachments Editor was not available for a view unless comments were explicitly enabled. This issue has been resolved, allowing the Comment Attachments Editor to be accessible regardless of the comment settings for the view. #3950

Excel AutoComplete

  • Fixed Issue: When an autocomple range’s ShowDropDownButton property is set to True, the values in the dropdown list were not ordered correctly. This issue has been resolved. The dropdown list now displays values in the correct order when ShowDropDownButton is enabled. #3953

  • Fixed Issue: When an autocomplete range’s ListLoadPolicy property is set to OnViewBuild, an object reference error would occur when running the view. This issue has been resolved. The autocomplete range now correctly handles loading lists without on build without triggering an object reference error. #3954

  • Fixed Issue: When the range address used to populate values in an autocomplete list is modified and saved, the dropdown list continued to display the old values. This issue has been resolved. The dropdown list now correctly reflects the updated range values after saving. #3955

PowerPoint View Exports

  • Fixed Issue: When copying a table over a range that contains hidden rows, the hidden rows were incorrectly displayed in the PowerPoint slide. This issue has been resolved, ensuring that hidden rows remain hidden when the table is copied. #3895

Toolbars Configuration Editor

  • Fixed Issue: In the Toolbars Configuration Editor, opening the Ribbon Designer and then cancelling the dialog caused tools to disappear from the ribbon. This issue has been resolved, ensuring that cancelling the Ribbon Designer does not affect the toolbar configuration. #3927

Workbook Scripting

  • New Method Argument: A PreserveFormulas argument has been added to the following methods and overloads. When PreserveFormulas is set to TRUE, cell formulas are copied verbatim rather than being adjusted to reference the source workbook. #3918

    • BinaryArtifactOperations.ImportSheet

    • BinaryArtifactOperations.ImportWorkbook

    • BinaryArtifactOperations.AddSheet

    • BinaryArtifactOperations.AddWorkbook

    • CopyFromBinaryArtifact.Sheet

    • CopyWorksheet.FromFile

    • CopyWorksheet.AllWorksheetsFromFile

  • New Method Overload: The CopyWorksheet method has a new overload, AllWorksheetsFromFile, which copies all worksheets from an Excel file into the current view. #3918

    Method Arguments - CopyWorksheet Overload

    • Filename: Specify the name of the file to copy from.

    • Folder: Specify the full path to the folder that contains the file.

    • SheetCondition: The SheetCondition argument can be used in conjunction with the AllSheets argument to copy all sheets with exceptions. Defaults to TRUE.

    • ValuesOnly: Whether to replace cell formulas with cell values. Defaults to FALSE.

    • SheetName: Specify the name of the sheet to copy.

    • NewSheetName: The name of the new sheet.

    • ToPositionPolicy: Select how to specify where to copy the worksheet to. Defaults to "Last".

    • ToPosition: If SpecifyToPosition is ToPositionOfSheetNamed then enter a sheet name. If SpecifyToPosition is ToPositionNumber then enter a number.

    • Password: The password assigned to the saved workbook.

    • PreserveFormulas: Whether to copy cell formulas verbatim rather than allowing them to be adjusted to refer to the source workbook. Defaults to FALSE.