This version of the Dodeca 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 2017 (8.1.58.102), NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells 17.1.0.0, Syncfusion Essential Studio 13.4.0.63, and GdPicture.NET 11.0.6.
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 11.1.1.3 are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions 11.1.1.4 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:
In previous releases, the default admin toolbars, which is used when an application’s UseDefaultAdminToolbarsConfiguration property is set to True, was not locked by default.
When the toolbar is not locked and a user attempts to move the application window, especially across monitors, it is easy to inadvertently click the mouse on the toolbar (instead of the window title bar), then drag the mouse, which results in floating the main menu instead of moving the application window.
The default admin application toolbars have been changed to be locked by default. #2174
You can configure any toolbars configuration to be locked by default. From the Toolbars Configuration Metadata Editor:
Enhancement – Added support for configuring the SaveAsPdfAsync, OpenInLocalPdfViewer, and PDFOpenExternal standard tools. Available configuration arguments include the following:
Compliance | Specifies the compliance of the resulting PDF; PDFA1b by default. |
Optimization | Specifies the optimization of the resulting PDF; Standard by default. |
ScaleSheets | Specifies whether sheets will be scaled in order to fit on one page each; False by default. |
This enhancement can be used to correctly render PDF documents from workbooks that contain images with transparency by setting the Compliance argument to None. #2167
Enhancement – Binary Artifact and Essbase Outline XML have been added to the list of “Metadata Types to Search.” #2173
The ability to search the following properties for all metadata types, including Binary Artifacts, is now supported:
For an Excel binary artifact, the search capability does not include searching the content of the associated Excel file.
[1]: The date and date/time field values are based on Coordinated Universal Time (UTC) (i.e. Greenwich Mean Time). The format is based on sortable date and time pattern, and is a defined standard (ISO 8601), which is the same for all cultures: yyyy-MM-ddTHH:mm:ss
, where yyyy
is the year as a four-digit number; MM
is the month, from 01 to 12; dd
is the day, from 01 to 31; T
is a constant; HH
is the hour, using a 24-hour clock from 00 to 23; mm
is the minute, from 00 through 59; ss
is the second, from 00 through 59.
For example: 2019-01-25T18:59:16.
To search for a date, the format of the specified string should be yyyy-MM-dd
and the value should allow for the UTC adjustment.
[2]: The following table indicates the searchable Type property values for each metadata type:
Metadata Type | Database Type (Searchable) Values |
---|---|
Application | WindowsApplication |
Binary Artifact | Excel, XML, PDF, StyleLibrary, WorkspaceLayout, Other |
Essbase Connection | EssbaseConnection |
Essbase Outline XML | Essbase Outline XML |
Essbase Script | Calc, MDX, MemberQuery, ReportScript |
Hierarchy | Hierarchy |
Selector | Date, Essbase, Generic, SQL |
Selector List | <Selector ID> |
SQL Connection | SQLConnection |
SQLPassthrough DataSet | SQLPassthroughDataSet |
Toolbars Configuration | ToolbarConfig |
View | AdhocEssbase, Excel, ExcelEssbase, MdxEssbase, OutlineViewer, PDF, ReportingServices, ScriptEssbase, SQLExcel, WebBrowser |
View PropertySet | AdhocEssbase, Essbase, Excel, ExcelEssbase, MdxEssbase, OutlineViewer, PDF, ReportingServices, ScriptEssbase, SQLExcel, View, WebBrowser |
Workbook Script | WorkbookScript |
For the Application, View, and View Property Set metadata types, the type is matched for a single metadata instance both as the Type property value and an embedded “information” property value. For instance, searching for AdhocEssbase returns two matching properties for each adhoc Essbase view.
The error only occurs when a query that does return rows is executed after the query that does not return rows.
The ShiftEntireColumnExcel option was added in 7.5.0.6430 and modified in 7.6.0.6549.
Del
) and cut (Ctrl+X
) #2182