Dodeca Version 8.3.5

In Dodeca 8.3.5 and higher, the Comments Explorer's comment cells are automatically sized and wrapped to display full comments without interaction. #3644

Fixed Issue: When an Essbase connection is configured as stateful, i.e. the Stateless property is set to False, using tokenized values for the Server, Application, or Database properties causes a failed disconnect attempt to occur during token replacement. #3624

Fixed Issue: When an Essbase send operation is performed and there are no data changes, a data audit log record (with no items) is still written. This issue was introduced in 8.0.0. #3614

Fixed Issue: Under some circumstances, an Essbase selector tree can become unresponsive during a build and require that the view be re-opened to make further selections. #3658

Fixed Issue: When utilizing ParallelExecution and retrieving ranges on multiple sheets, under some circumstances, a retrieve range can be serialized incorrectly and result in the retrieve operation being rejected by the Essbase server. #3676

Fixed Issue: When utilizing ParallelExecution and sending ranges on multiple hidden sheets, an error similar to the following can occur: Unable to send sheet "<SheetName>". Unable to send range "'<SheetName>'!<RangeName>". EssbaseSpreadsheetGear.ActiveWorksheetName.Set failed. Cannot select a hidden sheet. #3648

Fixed Issue: When using the Save As Excel and Open In Excel tools, the following error can occur under some circumstances when the view is configured for comments: Unable to open "<View Caption>" in Excel. Object reference not set to an instance of an object. #3666

Fixed Issue: When inserting or updating data, if the view or application’s culture is anything but en-US, an error similar to the following can occur (where the date is presented in M/dd/yyyy H:mm:ss.fff format): The <Column Name> column value, <Date>, is invalid. Enter a date or a date and time. This issue was introduced in 8.3.3. #3678

Fixed Issue: When inserting data, if the Query.InsertSQL statement contains column identifiers wrapped in square brackets (as is commonly for Microsoft SQL server columns that are reserved words), those columns are not inserted. #3623

Fixed Issue: When attempting to insert blank cells (or blank values, generally) into numeric columns as NULL by casting, an error similar to the following can occur: Unable to apply parameter <Column Name> (position: <index>, type: <type>): The conversion from String to DECIMAL is unsupported. This issue was introduced in 8.1.0. #3621

Added a RowLimit property to the SQLPassthroughDataSet Query in order to support overriding the Dodeca server’s limit of 1,000,000 rows for a query result set. A value of 0 can be used to return an unlimited number of rows. #3664

Fixed Issue: The value lists used for method arguments that can be chosen via dropdowns are inappropriately shared. When an argument value is chosen from a dropdown list, other argument values that correspond to dropdown list values may appear to change. #3660

Fixed Issue: The BinaryArtifactOperations.CreateFromFile method overload appends ".xlsx" to the given filename, which can cause an error similar to the following (when, for example, "test.txt" is given for the Filename argument): Could not find file 'c:\temp\test.txt.xlsx'. This issue was introduced in 8.1.0. #2537

Fixed issue: When using the SaveDataTableRangeRow method, the following error occurs: Error saving DataTableRange sheet range row. The SqlPassthroughDataSetRange.MetadataServiceProvider reference is null. #3622

Fixed Issue: When attempting to remove the last visible worksheet in a workbook (which is not supported), the following error is displayed: "Object reference not set to an instance of an object." In Dodeca 8.3.5 and higher, a more appropriate error is presented: "Cannot delete the last visible worksheet." #3670

Fixed issue: When using the BeforeTokenTableBuild event link, the following exception occurs: Unable to cast object of type 'System.EventHandler`1[AppliedOLAP.Dodeca.Common.TokenTableBuildCancelEventArgs]' to type 'System.ComponentModel.CancelEventHandler'. #3647