Dodeca Version 5.3.1

Modified the Sign On and Set Active Essbase Connection tool, which was introduced in the 5.3.0 release, as follows: 1) When an Essbase Service is selected or the Enter key is pressed in the Essbase Service, User Name, or Password field and all of these fields have a value, the control automatically attempts to sign on using the specified credentials. 2) When a database node is double-clicked with the left mouse button, the database represented by the node is set as the active connection. 3) When the User Name or Password field is activated, the existing text is automatically selected to allow for the value to be replaced. (#965)

Known Issue when the Excel sheet header or footer includes a double ampersand (&&) in a section. The output header or footer in the PDF is either correct, incorrect, or results in an error depending on the actual content and spacing:

Fixed issue encountered with the Save As PDF and Open In PDF Viewer tools when the width of the print range in the worksheet exceeds the width that can be accommodated by a PDF page and multiple pages are created for each sheet in the output PDF. The specific issue encountered during internal QA testing was that in the second page created for a sheet that contains group footer rows where some cells contain right-justified text, the content of the cells in the column to the right was being overwritten. (#958)

The Open in (Local) PDF Viewer and Open In (External) PDF Viewer tools perform the conversion of the view’s grid content to a temporary Excel file on the main thread, then launch the conversion of the temporary Excel file to a PDF on a background thread. In the 5.3.0 release, all the processing was performed on the main thread, which prevented the user from interacting with the view and the rest application during the processing. Since concurrent invocations of the Open In PDF Viewer tools are supported, the user is able to interact with the view as soon as the saving of the workbook to a temporary Excel file is completed and the conversion of the Excel file to a PDF is started. (#964)

Fixed issue with SQL connections not being explicitly closed after executing a SQPassthroughDataSet’s queries for the following: 1) Workbook script BuildRangeFromScript method’s SQLPassthroughDataSet overload, 2) WindowsUserRolesFromSqlPassthroughDataSet authentication service, 3) EssbaseUserRolesFromSqlPassthroughDataSet authentication service, and 4) SQLPassthroughDataSet Metadata Editor’s Test DataSet tool. (#957)

Fixed issue introduced in 5.3.0 that results in a data row error "Error converting nvarchar to decimal" when attempting to save a decimal value that has any digits to the right of the decimal point. (#966)

Fixed Issue: The Copy to Formula Evaluator Tab tool in the Method Arguments toolbar on the Breakpoints tab fails to copy the value of the active cell to the Formula Evaluator tab when the cell is not in edit mode. (#962)

Fixed Issue: The EssbaseRunCalc method’s BackgroundCalc argument value renders in the editor as a shaded checkbox. The argument’s default value is false, which now renders as an unchecked checkbox. (#961)

Fixed Issue [EssbaseReport Method] — The EssbaseReport method was not using the specified ConnectionID argument value. (#955)

New Method [RepaintGrid] — The RepaintGrid forces a repaint of the grid control. This method should be used with discretion, since performance could be impacted and repainting already occurs after a top level method has completed execution. This method will typically only be used when a procedure that is executed from within a CellByCell or ForEach loop modifies the grid content or formatting, and the change needs to be displayed before the next iteration of the loop. It is highly recommended that this method only be used after it has been determined that the behavior is not as intended without explicitly repainting the grid. (#959)