April 24, 2013
This version uses SpreadsheetGear 2012 (7.0.5.140), NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells 7.0.3.0, and Syncfusion Essential Studio 10.4.0.71.
The release notes for this version contain the following sections:
SQLPassthroughDataSet
View Status Icons
Workbook Script Editor
Workbook Script Functions, Methods, Properties, and Event Links
SQLPassthroughDataSet
- Issue: A customer encountered a (previously unreported) error when executing a SQLPassthroughDataSet: "Unable to read data from the transport connection: The connection was closed." After modifying the query to use the IncrementalMaxRows property in order to perform incremental calls to the server (until all the rows were retrieved), duplicate rows were sometimes (but not always) returned to the client.
Resolution: A statement cache timeout was set to 3 minutes on the server to prevent the statement from being flushed from the cache. This is considered to be adequate, since it would be unlikely to have a long period of time between the incremental calls to the server. (#1177)
View Status Icons
- The images displayed on the view tab and in the view status bar have been updated to use an image format that renders with cleaner edges, which is especially noticeable on a dark background. (#1184)
Not ready to build
Ready to build
The other view status icons include the following:
image::image222.jpeg[image] Cancelled
image::image223.jpeg[image] Error
image::image224.jpeg[image,width=23,height=26] Selection Changed
image::image225.jpeg[image] Ready
image::image226.jpeg[image,width=24,height=23] Waiting for Essbase login
image::image227.jpeg[image,width=26,height=26] Waiting for server response
image::image228.jpeg[image] Warning
image::image229.jpeg[image] Working
Workbook Script Editor
- Fixed issue with the Find dialog: When a procedure row is selected, and there are no occurrences of the Search string below the selected row, but there are occurrences above the selected row, none of the occurrences are found. (#1175)
Workbook Script Functions, Methods, Properties, and Event Links
- AddProperty Method: Added optional Delimiter argument, which can be used in conjunction with the AppendToValue argument when set to True. (#1180)
Fixed Issue: RenameWorksheet method throws an "Object reference not set to an instance of an object" exception when the SheetToRename argument value resolves to an empty string.
Resolution: When the SheetToRename argument resolves to an empty string, thr following exception is thrown: "The SheetToRename argument resolves to a null or empty string." (#1176)
- SetSelector Method: Added Enabled argument to allow the enabling/disabling of the selector control and, if applicable, the docked treeview or listbox control. (#1181)
Fixed Issue: When the ShowSelectorControlAsDialog method is used to display a selector dialog in the BeforeBuild event for a SQLView, the control is enabled for the first build, but disabled for the second and subsequent builds of the view.
Resolution: The selector control is enabled for the first and all subsequent builds. (#1182)