Dodeca Version 8.7.4

Enhancement: SQL connections using an OAuth CredentialsPolicy now support connecting to databases that authenticate directly via OpenID Connect identity tokens (such as Amazon Redshift using a Trusted Token Issuer configured in AWS IAM Identity Center). Support has also been added for authorization connectors that return specialized credentials, such as the Amazon Authorization connector, which leverages SSO to retrieve temporary IAM access keys. #3882

Fixed Issue: When a Workbook Script procedure renames or moves the active worksheet (e.g., via the RenameWorksheet method) during execution, restoring the originally selected range after the procedure completes can throw an exception, because the selection was captured by worksheet name rather than a live reference to the worksheet. #4477

Fixed Issue: Opening the Workbook Script Debugger during an event that runs before the Workbook has been instanced (e.g., AfterTokenTableBuild) could throw an exception while initializing the debugger’s tools, because they checked for visible worksheets before a Workbook existed. #4467

Fixed Issue: Worksheet names containing valid, non-alphanumeric characters (e.g., an apostrophe) were not handled correctly, which could cause an exception similar to the following: Object reference not set to an instance of an object. #4468

Fixed Issue: Calling the ExecuteProcedure method from a script set procedure invoked during the AfterTokenTableBuild event could throw an exception similar to the following: SpreadsheetGear.IWorkbookSet.GetLock must be called to acquire a lock on the workbook set. #4469