Dodeca Version 6.7.8

August 4, 2014 - Build 4546

This version of the Dodeca Framework uses the .NET Framework, version 2.0, Service Pack 1 and higher on the desktop. The components used in this version of Dodeca are SpreadsheetGear 2012 (, NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells, Syncfusion Essential Studio 11.3035.0.30, and GdPicture.NET

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.6. 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 are supported and tested on Java 1.6. Both services are known to run on Java 1.7, although extensive testing has not been performed on that Java version.

The release notes for this version contain the following:


  • A new comment range setting, StoreNumericCommentAsNumberOnSheet, allows for numeric comment values to be formatted as numbers within the comment range. When set to True, any comment value that represents a number is stored in the cell as a double and any non-numeric value is stored as text. (#1306)

  • A new comment range setting, AutoUpdateSameCommentInOtherCommentRanges, is applied when a comment is added, deleted, or updated in a cell. In previous releases, any change to a cell comment would result in all of the other comment ranges being searched to determine whether the same comment (i.e. the exact same evaluated key/item string) also exists in the other comment range. If so, the matching comment would be updated on the sheet to reflect the changes.

    Since the duplication of comments across comment ranges is unlikely, and because the searching of the other comment ranges can potentially be costly, the AutoUpdateSameCommentInOtherCommentRanges was added to avoid the unnecessary overhead incurred by this processing. By default, the setting is False.

    If the same comment can reside in multiple comment ranges where cell editing of a comment is allowed, this property should be set to True. (#1307)

  • Modified the progress text displayed in the view’s status bar when comments are being loaded, while building the view, to include the CommentRange.Caption. (#1309)

View Selector Tree

  • Fixed an issue with the Export Excel Template not appearing on the context menu when a view item is clicked with the right mouse button. This issue is only encountered with the other "allow" view selector properties are set to False. (#1304)


Workbook Scripting

  • New Method: The Calculate method allows for all workbooks to be calculated on demand. The AllWorkbooksAsNeeded overload calculates formulas in all workbooks as needed. Volatile formulas and formulas involved in circular references are always calculated. The AllWorkbooksFull calculates all formulas in all workbooks.

    To use this method, the calculation mode must be set to Manual, which can be done using the SetCalculationOptions method. (#1308)