QueryStorm

Excel Plugin adds powerful development and data processing capabilities into Microsoft Excel.

Published by QueryStorm
Distributed by ComponentSource since 2018

Prices from: $ 371.42 Version: 2.12.x NEW Updated: Apr 12, 2024

Screenshot of QueryStorm

QueryStorm 2.5.x

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 file as many current NuGet packages rely on it.

Fixes

  • Fixed the problem with the default workbook data context that prevented its use (the workaround was creating an explicit data context).
  • Fixed encoding issue with .cs files that are created via a code fixer (e.g. extract class into its own file).

2.5 Hotfix #1

Updated Sep 1, 2021

Features

  • Added syntax highlighting for the new with keyword in C#.
  • Logging compilation warnings even if build succeeds (previously warnings were shown only when a build failed).

Fixes

  • Fixes issue caused by the SQLite upgrade which was preventing existing projects that use SQLite from being opened.

2.5

Updated Aug 31, 2021

Features

  • Roslyn has been updated from v3.5 to v3.11 and as a consequence, the version of C# in QueryStorm has been upgraded from C# 7.1 to C# 9. New features this adds are:
    • Record types [C# 9].
    • Indices and ranges [C# 8].
    • Async streams [C# 8].
    • Nullable reference types [C# 8].
  • The version of SQLite used by QueryStorm has been upgraded from 3.15.2 to 3.36.0 which introduces the availability of SQLite window functions. These make it easy to perform calculations that depend on surrounding rows. A typical example would be calculating a running total or a moving average.
  • Introduces a new Cached attribute that can be applied to user defined Microsoft Excel functions.
  • Adds support for opening txt files in the IDE.
  • Allow binding component properties with enum types.
  • Limited the Package Manager to stable NuGet packages since, most often, choosing a stable release is the correct option.

Fixes

  • Fixed logging in C# scripts via the static DebugHelpers.Log() method.
  • Fixed several issues with return values of custom Excel functions (e.g. when returning Task<IEnumerable<T>> results were not laid out correctly).
  • Fixed a race condition with QueryStorm Apps that define a ribbon (they were crashing on load occasionally).
Back to QueryStorm Releases