QueryStorm Releases

Released: May 31, 2022

Updates in 2.7.x


Updated Feb 8, 2023


  • Editing scripts was impossible after closing and reopening them.
  • Phantom "lib" and "bin" files were appearing in extension projects after build.
  • Failing async functions were crashing Excel instead of returning an error and logging the details.
  • Workbook apps that have settings were bugged in multiple ways.
  • Workbook variables now have a specific type (e.g. "double", "string"... instead of "object").
  • Sporadic deadlocks were occurring when using the {@some...

Released: Feb 11, 2022

Updates in 2.6.x


Updated Feb 26, 2022


  • Added the ability to recreate output tables when running SQL scripts.


  • Fixed bugs (IDE):
    • Double-clicking an error in a file which was not previously opened would only open the file, not go to the offending line.
    • C# indentation strategy was not working well with lambdas so reverted to a simpler indentation strategy.
    • IDataContext could not be resolved from C# scripts.
    • Importing a workbook project into the workbook was failing to update files...

Released: Aug 31, 2021

Updates in 2.5.x


Updated Sep 10, 2021


  • Added support for configuring SSL in Postgres connection strings.
  • When using [BindTable] the binder can now detect the table name based on the property type, if it is a table wrapper class (but not if it is Tabular).
  • SQL preprocessor now forbids illegal combinations of declarations (e.g. can only use {@tbl} in a handler but not in a function or query) and gives better error information.
  • Added a "netstandard.dll" reference into the default config...

Released: Aug 10, 2021

Updates in 2.4.x


Updated Aug 10, 2021


  • Trusted documents - This version prompts the user to confirm that they trust the workbook before allowing it to run. Once a workbook app is trusted, the user will not be prompted again.
  • Context menus - Context menus can now be defined much more easily compared to using the native Microsoft Excel API for context menus (i.e. CommandBars).
  • App settings - Apps can now define settings much more easily by creating a class that exposes configuration properties and...

Released: Jun 1, 2021

Updates in 2.3.x


Updated Jun 3, 2021


  • Fixed compilation of projects with references to local system DLLs.
  • Minor fixes to ribbon class template.
  • Fixed publishing packages with native DLLs.
  • Prevent creating multiple projects in a workbook, as this scenario is not yet supported.
  • Better handling for project load errors.
  • Better handling for async function crashes.
  • Fixed a focus issue with the undocked QueryStorm window where all text input would go to Excel.
  • Fix for project deletion issues (add...

Released: Jan 18, 2021

Updates in 2.2.x


Updated Mar 5, 2021


  • Refactoring the app contract: - shortcut service now allows unregistering shortcuts.
  • An app's configuration can now supply a handler for the "OK" button in the config dialog


Updated Mar 3, 2021


  • Fixed issue with "Configure extensions" dialog (in the runtime) that prevented from changing the selected item in the list.


Updated Mar 1, 2021


  • QueryStorm extensions can now define shortcuts and allow users to configure...

Released: Nov 10, 2018

Updates in 1.13


  • Preprocessor now allows resolving to unquoted strings (e.g. column names), by starting the expression inside the curly brackets with # sign e.g.: select {#columnName} from myTable
  • (Here columnName is a named range containing the name of the column to resolve. Cell references are also valid (e.g. {#A1} or {#Sheet1!A1}).)
  • C# engine:
    • Column names that have illegal C# identifier names are normalized and are now accessible as properties (not just via indexer).
    • Properties can be decorated...