QueryStorm Releases

Released: Aug 31, 2021

Updates in 2.5.x

2.5.7923.20438

Updated Sep 10, 2021

Features

  • 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

2.4

Updated Aug 10, 2021

Features

  • 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

2.3.7824.17314

Updated Jun 3, 2021

Fixes

  • 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

2.2.7734.36528

Updated Mar 5, 2021

Fixes

  • 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

2.2.7732.23346

Updated Mar 3, 2021

Fixes

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

2.2.7730.34357

Updated Mar 1, 2021

Features

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

Released: Nov 10, 2018

Updates in 1.13

Features

  • 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...