Features

• All dialogs have been polished and are now consistent across the IDE, runtime, and user apps.

Fixes

• The Runtime will no longer crash after an Excel file has been opened in the Windows Explorer's Preview pane. QueryStorm apps will connect to the correct instance of Excel (not the one in the preview pane). This should solve all issues related to the preview pane in Windows Explorer.

Fixes

• Fixed issues with scripts for defining custom data contexts.

Fixes

• Fixed an issue with the QueryStorm Runtime where Excel was crashing when starting apps that register context menu commands, e.g. MondayLink.

Fixes

• VBA API was broken in the last few versions (since 2.9.8553.18963).

Fixes

• Fixed Monday.com data context issues.

Fixes

• Fixed the "Function Insights" functionality in the code editor.

Fixes

• Compilation (build) was failing to resolve .NET references on machines that don't have the .NET SDK (installed with Visual Studio).
• Excel would hang for 15s on close whenever a dialog was shown by the IDE, runtime, or an app.
• QueryStorm runtime would not load if a running file explorer instance has started Excel in the preview pane.
• Switching to the latest version of ExcelDNA to fix a bug that was crashing Excel on load when apps that define context menus are used.

Features

• Apps can now specify a 'minRuntimeVersion'.
• Added HTTP request infrastructure for throttling and API key management (request/try/retry loop).
• Improved handling of licensing prompts (avoid multiple prompts for licensed functions evaluating in multiple cells).
• 'IDialogServiceExt' interface has been added which allows apps to show dialogs from XAML files and VM objects.
• Added support for C# scripts returning 'ExpandoObjects'.
• IDialogService: All dialogs are now shown center screen, close on 'Esc' key and allow hyperlinks that open the browser.
• All licensing dialogs will now share remembered username regardless of app.
• Synchronization context is now assigned inside async Microsoft Excel functions (so execution after async calls will resume on the main thread).

Fixes

• Fixed referencing BCL types in the IDE (using ReferenceAssemblies folder instead of GAC).