March 9, 2011
This version uses SpreadsheetGear 2010 (6.0.3.190) and NetAdvantage 2010, Volume 2 (10.2.20102.1004).
The release notes for this build contain the following sections:
Essbase Adhoc View
PDF Support
Relational
Workbook Script Debugger
Workbook Script Metadata Editor
Workbook Scripting
Essbase Adhoc View
- 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)
Refer to the Essbase Adhoc View section of the 5.3.0.2646 release notes for additonal information about the Sign On and Set Active Essbase Connection tool.
PDF Support
- 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:
Section Spec Output Header Section
Profit && Loss Profit & Loss
Profit &&Loss Profit
Profit&&Loss Profit
P && L P & L
P&&L Error: Such header or footer is not supported yet!
The workaround is to include a space on either side of the double ampersand. (#960)
- 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)
This illustrates the issue:
This is the same PDF after the issue was resolved:
- 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)
As presented to the user, there is no distinction between these steps, so during processing on the main thread, the progress text reads "Conversion to PDF started--".
When the background thread processing begins, the progress text reads "A PDF Viewer will be opened when the conversion is complete." At this point, the user is free to interact with the view, including launching another PDF Viewer instance.
Refer to the PDF Support section of the 5.3.0.2646 release notes for additonal information.
Relational
- 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)
Workbook Script Debugger
- 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)
Workbook Script Metadata Editor
- 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)
Workbook Scripting
- 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)