| Note | Description | Comments |
|---|
| Feature | New transformative directives | Support for net present value (pebblestream:npv) and yield (pebblestream:yield) calculations. Support for pivot (pebblestream:pivot) from triple store format to columnar format. |
| Feature | New annotative directives | Added column type directives text, number, boolean, and date |
| Feature | Improved calculation speed. | General performance improvements. |
| Bug Fix | Parser | Address several Excel formula parsing annoyances |
| Bug Fix | INT, FLOOR, and CEILING formulas | Each failed to compute when the reference points to an empty string of an empty cell |
| Note | Description | Comments |
|---|
| Feature | Vast speedups of SUM, SUMIF, and SUMIFS for sliding and growing ranges | Summing over ranges like A$1:A[n] and A[m]:A[m+n] are up to 100 times faster. |
| Feature | Intelligent indexing is applied as an opportunistic optimization. | The Pebble Stream 2.x runtime will smartly index values whenever it makes sense. |
| Feature | The group directive will treat the whole worksheet as a group if no criteria are provided. | This obviates the need to create a grouping column when the whole worksheet is considered the group. |
| Feature | The group directive now supports MIN, MAX, and AVERAGE operations. | Each operation produces the same result as the EXCEL functions MIN, MAX, and AVERAGE. |
| Feature | Excel formula parser improvements | |
Support for Pebble Stream Runtime version 1.x.x will be discontinued on July 1, 2025. All 1.x.x users are advised to migrate to version 2.x.x as soon as possible.
| Note | Description | Comments |
|---|
| Feature | Performance improvements: memory | Massive reduction of memory consumption during spreadsheet generation with many scenarios resulting in near flat memory growth. |
| Feature | Performance improvements: speed | Up to 100 times faster worksheet generation compared to 1.x.x. |
| Feature | Additional Directives | More worksheet directives including self-compare, graph traversal, allowed sets, generate-rows, data merges, lot relief, tax rounding, and more advanced grouping. |
| Feature | Execute formulas on worksheets with transformative directives | Pebblers can intermingle transformative directive columns with formula columns on the same worksheet |
| Feature | Automatic test scenario generation | Developers can automatically generate and run test scenarios from spreadsheets. |
| Feature | More efficient compiler | Compiler can now compile large Excel spreadsheets. |
| Feature | More Excel functions | Pebble Stream now supports more Excel functions including a wide array of statistical functions. |
| Feature | Native C# support | Pebble Stream Runtime is now available as a native C# executable. |
| Feature | Native JavaScript support | Pebble Stream Runtime is now available as a native JavaScript library for Node.js or browser deployment. |
| Note | Description | Comments |
|---|
| Feature | Removed API to save pebble output as an Excel spreadsheet. | This feature was ill-placed in the runtime. We will release runtime-utils shortly to contain this and other functionality. |
| Bug Fix | Pebble Stream runtime did not compute if statements without an else condition | Compiler and analyzer both accept if statements without else conditions. |
| Note | Description | Comments |
|---|
| Bug Fix | Fix >= and <= detection in filter directive compilation | The analyzer sometimes fails to pick up the filter directive's greater and less than equal signs. This release fixes this issue. |
| Bug Fix | Convert new smart quote character to canonical quote during compilation. | Some spreadsheet implementations use different characters for quoting. This release recognizes more of those characters as quotes. |
| Bug Fix | Return nil always when looking past the length of a previously computed sheet. | In certain circumstances, the runtime will revert to template values if it detects that the input sheet is not provided. This behavior has been corrected. |
| Note | Description | Comments |
|---|
| Feature | Transformative Directives | Several transformative directives including joins, filters, drag downs, and group sums |
| Feature | Annotative Directives | Directives to detect errors, produce warnings, and validate data. |
| Feature | Over 100 Excel Formulas and Operators | Initial set of Excel formula implementations. |
