8.9.0 (2024-10-19)

You can now provide a Custom Pagination Component (Aurelia) instead of the default built-in Pagination

• see the new Example 42

Features

• allow providing a Custom Pagination Component (#1275) (247aa56) - by @ghiscoding

Bug Fixes

• deps: update Aurelia 2.Beta 22 (#1270) (7d8ae06) - by @ghiscoding
• improve project exports & types (3786f34) - by @ghiscoding
• Row Detail redraw all Views when GridMenu/ColPicker columns changes (#1277) (8f549b0) - by @ghiscoding

Reverts

• Revert "fix: redraw all open row details whenever the grid is re-rendered (#1…" (#1276) (8527bb2), closes #1 #1276 - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.9.0) and Aurelia-Slickgrid (v8.9.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.8.0 (2024-09-29)

Release Info

This new release brings a new preParseDateColumns grid option that allows to pre-parse date columns to improve Date column Sorting by a factor of 10x (and also make subsequent sorting extremely fast). The problem at hand is simple, parsing dates can be an expensive process especially for large dataset, but it is required in order to do Date Sorting. When we say parsing we mean reading the formatted date string and convert it to a JS Date object. For small dataset (less than 10K), it's not much of a problem but it becomes quite noticeable with large dataset, because calling a Sort will revisit the same items over and over until every items are fully sorted and without the new option enabled, we are reparsing these items multiple times which as I said earlier can become an expensive task... so with this release, we now have a new opt-in preParseDateColumns grid option (to be used only with large dataset 10K or more, the option IS NOT enabled by default). For more info, please take the time to read the Sorting - Pre-Parse Date Columns documentation. You can test this out via Slickgrid-Universal Example 2 by clicking on "50K rows" button and then try sorting Start/Finish dates.

Features

• option to improve Date Sorting by pre-parsing date items only once (#1268) (3161d98) - by @ghiscoding

Bug Fixes

• deps: update all non-major dependencies (#1267) (64f3cb2) - by @renovate-bot
• redraw all open row details whenever the grid is re-rendered (#1269) (4ecb439) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.8.0) and Aurelia-Slickgrid (v8.8.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.7.0 (2024-09-14)

This release brings a couple of perf contributions brought by an external user, you should be able to see the benefit. Take a look at the Slickgrid-Universal release for more info. Enjoy... 🎉

Bug Fixes

• deps: update dependency @faker-js/faker to v9 (#1262) (ec26df3) - by @renovate-bot

Performance Improvements

• don't invalidate grid rows more than once (#1265) (740995c) - by @ghiscoding
• upgrade Slickgrid-Universal with perf improvements (#1266) (f56b0c8) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.7.0) and Aurelia-Slickgrid (v8.7.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.6.2 (2024-09-14)

This release brings a couple of perf contributions brought by an external user, you should be able to see the benefit. Take a look at the Slickgrid-Universal release for more info. Enjoy... 🎉

Bug Fixes

• deps: update dependency @faker-js/faker to v9 (#1262) (ec26df3) - by @renovate-bot

Performance Improvements

• don't invalidate grid rows more than once (#1265) (740995c) - by @ghiscoding
• upgrade Slickgrid-Universal with perf improvements (#1266) (f56b0c8) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.7.0) and Aurelia-Slickgrid (v8.6.2) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.6.1 (2024-08-31)

Bug Fixes

• unflattening tree->flat array multiple times (#1260) (a636297) - by @ghiscoding

8.6.0 (2024-08-24)

Release Info

With this release, we are migrating to the original Vanilla-Calendar-Pro project and dropping the vanilla-calendar-picker temporary fork and that is because all features & bug fixes I had in my fork were all merged recently to the original project (the fork was always meant to be a temporary thing).

There's also a new rowTopOffsetRenderType grid option that might be of interest, the default is top but if you set it to transform then all rows of the grid will use transform: translateY({offset}px) to position each row in the grid and the transform might actually improve perf as per this article: Why Moving Elements With Translate() Is Better Than Pos:abs Top/left

Features

• migrate back to Vanilla-Calendar-Pro (#1256) (40f2c34) - by @ghiscoding
• new Drag to Recycle Bin demo (#1257) (640a93c) - by @ghiscoding

Bug Fixes

• register RowDetail and dispose of it only once (#1253) (d598c6d) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.6.0) and Aurelia-Slickgrid (v8.6.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.5.2 (2024-08-17)

Bug Fixes

• use setTimeout/setInterval from window object with correct TS type (#1252) (f272174) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.5.2) and Aurelia-Slickgrid (v8.5.2) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.5.1 (2024-08-17)

Bug Fixes

• deps: update all non-major dependencies (#1249) (e439c05) - by @renovate-bot
• Tree Data should work without initial sort (#1251) (98546d0) - by @ghiscoding

8.5.0 (2024-08-07)

Release Info

This new release adds the Infinite Scroll feature and with it adds not just 1 but 3 new examples to cover all use cases (read the new Infinite Scroll docs for more info)

1. Example 38 - with OData Backend
2. Example 39 - with GraphQL Backend
3. Example 40 - with JSON data (local)

Infinite scrolling allows the grid to lazy-load rows from the server when reaching the scroll bottom (end) position. In its simplest form, the more the user scrolls down, the more rows get loaded. If we reached the end of the dataset and there is no more data to load, then we'll assume to have the entire dataset loaded in memory. This contrast with the regular Pagination approach which will only hold a single page data at a time.

Features

• Infinite Scroll for Backend Services (OData/GraphQL) (#1244) (c19ddbb) - by @ghiscoding
• Infinite Scroll for JSON data (#1245) (a982443) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.5.0) and Aurelia-Slickgrid (v8.5.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.4.0 (2024-07-20)

Features

• add columnPickerLabel for custom label (#1239) (a83e958) - by @ghiscoding

Bug Fixes

• filterQueryOverride provide all search values (#1238) (0c2aea3) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.4.0) and Aurelia-Slickgrid (v8.4.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.3.2 (2024-07-13)

Bug Fixes

• SASS warnings & other unit test fixes (#1235) (7b9965a) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.3.4) and Aurelia-Slickgrid (v8.3.2) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.3.1 (2024-07-06)

Bug Fixes

• Composite Editor should work with Cell Menu (#1230) (f799cf9) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.3.3) and Aurelia-Slickgrid (v8.3.1) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.3.0 (2024-06-29)

Features

• add onPreHeaderContextMenu for Column Picker usage (#1228) (fc43fa8) - by @ghiscoding

Bug Fixes

• deps: update all non-major dependencies (#1226) (c98dd52) - by @renovate-bot
• setting date picker should always work (#1229) (b1b763a) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.3.2) and Aurelia-Slickgrid (v8.3.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.2.0 (2024-06-18)

New Release Info

This new release brings Filter Shortcuts that once defined will be added as sub-menus the Column Header Menu. These shortcuts are nothing new in terms of what you can already do with Column Filters, however the main reason to use them is to define some filters with simple logic, for example give me all the Blanks or Non-Blanks Values or even better filter the last 6 months data. For more info and demo, take a look at:

• Example 6 - Filter "Next 20 days" with Date Range
• Example 15 - Filter "Description" Blanks/Non-Blanks and "Start" Until Now/Future
• Read the Filter Shortcuts docs on how to use it

Lastly there's also a new Example 37 which is showing Column Totals in the grid Footer (the code was taken from an old SlickGrid example).

Features

• add Footer Totals Row and fix footer styling (#1224) (f1ae45c) - by @ghiscoding
• add new optional filterShortcuts to Column Filter (#1223) (d4b1e28) - by @ghiscoding
• paste multiline content as single cell (3e74491) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.2.0) and Aurelia-Slickgrid (v8.2.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.1.0 (2024-06-08)

New Release Info

This new release brings a ton of new features and most of the new feature ideas came from this great Stack Overflow question Angular Slickgrid - Custom Filter which the user asked if it was possible to create a custom filter as SQL LIKE. So, from this idea in mind and considering that we already had a sortComparer for custom Sorting but no ways to customize Filtering, now let's work around this idea shall we?

• filterPredicate for local JSON dataset (see Example 32 for SQL LIKE demo)
• new filterQueryOverride which is the filter override for Backend Services (OData / GraphQL)
• new OperatorType.custom that can be used with above custom filter predicate/override
• new Operator a*z (StartsWith & EndsWith combo) available for local JSON dataset and Backend Services
• new Top-Header panel which now allows the user to use both Draggable Grouping and Header Grouping together, this just wasn't possible before (see Example 18)

This new release also brings a lot of improvements to the Excel Export with a new Example 36 which demos how to dynamically use Excel Formulas (e.g. Sums), you can even use Excel Formulas with Grouping to do Sums, isn't it awesome!? Let's just say that pretty much everything you can do in excel-builder-vanilla, you can probably do in Slickgrid-Universal.

A huge thanks to @zewa666 and @jr01 for their contributions & feedback to add some of these new features and fixes. 🚀

Features

• add filterQueryOverride to GraphQL Service (#1214) (507a79a) - by @ghiscoding
• add filterQueryOverride to OData Service (#1215) (988118f) - by @ghiscoding
• add a filterPredicate option for user customization (#1213) (9caf80e) - by @ghiscoding
• add local data StartsWith/EndsWith (a*z) filter combo (#1216) (677fd4c) - by @ghiscoding
• add optional Top-Header for Draggable Grouping & Header Grouping (#1219) (3e555f5) - by @ghiscoding
• add StartsWith/EndsWith (a*z) to OData/GraphQL (#1217) (c8122e7) - by @ghiscoding
• enhance Excel valueParserCallback with dataContext & new demo (#1211) (fdcc1cf) - by @ghiscoding

Bug Fixes

• demo: out of boundaries page Grid Preset should be unset (#1209) (e1a4d46) - by @ghiscoding
• deps: update all non-major dependencies (#1207) (c3bb68e) - by @renovate-bot
• TreeData: addItem should keep current sorted column (#1221) (87c39fb) - by @ghiscoding
• using caret ^ to get latest Aurelia 2 Beta 17 version (#1206) (e1d412d) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.1.0) and Aurelia-Slickgrid (v8.1.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

8.0.1 (2024-05-12)

Bug Fixes

• small styling issues & better primary color support w/Dark Mode (#1204) (9636a5b) - by @ghiscoding

8.0.0 (2024-05-10)

New Major 8.0 Release

This new release brings a lot of changes oriented toward better UI/UX, our SVG icons are now pure CSS and can be colorized like any other text via the native CSS color property (which helped a lot improving the Dark Mode Theme).

Another noticeable UI change is the migration of the date picker from Flatpickr to Vanilla-Calendar-Pro, this new library has ESM support, it has modern styling and an awesome UI/UX. Another change that is mostly internal but is also indirectly connected to the date picker is the migration from MomentJS to Tempo which is a new modern lib and is also packaged as ESM which is great for Tree Shaking. Lastly DOMPurify is now optional, giving you the choice to install it or to use something else like isomorphic-dompurify for SSR support... Please note that even if it is now optional, we strongly suggest that you install it nonetheless that is if you want to stay secure and CSP compliant (see migration below for more info).

I believe that with all of these recent changes, the project is pretty much feature complete and you should not expect any new major releases for a long time (hopefully) which is also why I decided to require Angular 18 as soon as it came out.

[!NOTE]

Follow the Migration to 8.0 for all the changes

⚠ BREAKING CHANGES

• pure SVG icons, Moment to Tempo, Flatpickr to Vanilla-Calendar (#1203)
• make DOMPurify as optional (#1195)
• migrate from Moment to Tempo (#1194)
• remove Font-Awesome and use new SVG icons (#1191)
• common: migrate from Flatpickr to Vanilla-Calendar (#1193)

Features

• common: migrate from Flatpickr to Vanilla-Calendar (#1193) (27ee287) - by @ghiscoding
• make DOMPurify as optional (#1195) (5a84ff8) - by @ghiscoding
• migrate from Moment to Tempo (#1194) (58831dd) - by @ghiscoding
• pure SVG icons, Moment to Tempo, Flatpickr to Vanilla-Calendar (#1203) (8a11310) - by @ghiscoding
• remove Font-Awesome and use new SVG icons (#1191) (6f7b6fe) - by @ghiscoding

Bug Fixes

• we shouldn't always commit on focusout/blur (#1192) (5b9b543) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v5.0.0) and Aurelia-Slickgrid (v8.0.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

also remember that Slickgrid-Universal monorepo is where the biggest portion of the code exists (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

7.7.0 (2024-04-20)

Quick Info

This new release adds 2x new grid options defaultEditorOptions and defaultFilterOptions so that user can define global Editor/Filter options instead of having to duplicate same options on each column editorOptions/filterOptions. An example is shown below.

• Note: for defaultFilterOptions, we use the same keys as the Editor (date, select, slider, ...) but please note that these 3 filters options have combined options into 1 prop for compound & range filters (e.g. date is for both compoundDate and dateRange filter options).

this.gridOptions = {
  defaultEditorOptions: { 
    autocompleter: { debounceWaitMs: 150 }, // auto-typed as AutocompleterOption
    date: { minDate: 'today' },
    longText: { cols: 50, rows: 5 } 
  }
}

⚠️ Breaking Change (Aurelia 2 - Beta.15)

Please note that I upgraded Aurelia 2 to Beta 15 which has breaking changes with @decorator, so if you want to update Aurelia-Slickgrid, you will to also upgrade Aurelia 2 Beta 15. The changes are as following (also remove decorators from tsconfig.json)

- constructor(@I18N private readonly i18n: I18N) {
+ constructor(private readonly i18n: I18N = resolve(I18N)) {

Features

• add global defaultEditorOptions & defaultFilterOptions (#1183) (eefca81) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v4.7.0) and Aurelia-Slickgrid (v7.7.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

please remember that Slickgrid-Universal monorepo now contains the biggest portion of the code (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

7.6.1 (2024-04-01)

Quick Info

This release will now work with multiple tooltips on the same cell (e.g. multiple buttons with icons like the "Action" column in Example 35).

Bug Fixes

• allow multiple tooltips per grid cell (#1176) (8fbf543) - by @ghiscoding

Installation

Please remember that all packages of @slickgrid-universal (v4.6.1) and Aurelia-Slickgrid (v7.6.1) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues. You can also consult the Versions Compatibility Table - Wiki

please remember that Slickgrid-Universal monorepo now contains the biggest portion of the code (~90%), so most of the commits are now happening on that side.

1. review the Slickgrid-Universal changelog
2. and the Aurelia-Slickgrid changelog (above)

7.6.0 (2024-03-23)

Quick Info

This release upgrades multiple-select-vanilla package, that I also maintained, with a much more modern UI with the use of SVG icons. The SVG icons in that external lib are now also written in pure CSS which helps for Dark Mode (in that mode, the primary color for checked icon is a lighter version of the primary color). Note however that the SVG icons in Slickgrid-Universal are not yet pure CSS since that would introduce breaking changes in Slickgrid-Universal (a new major version will be pushed later on to address that).

⚠️ Custom Editor/Filter should not be newed

Please note that Custom Editor/Filter should never be newed even though the documentation previously said otherwise, this has been corrected in this release via an update on the Column interface, so if you have any of them instantiating that way then please fix them to avoid build errors.

// same goes for Custom Filter
editor: {
  // reference your custom editor class without instantiating it
-  model: new CustomInputEditor()
+  model: CustomInputEditor 
},

⚠️ internalColumnEditor is deprecated and no longer needed

Note that in the past, SlickGrid and Slickgrid-Universal/Aurelia-Slickgrid were using 2 different references for editor. The original SlickGrid was using editor as a Class to be later instantiated (e.g. Editors.longText) but that wasn't very convenient for the end users (you). For that reason I decided a long time ago to take this editor and reassign to another ref named internalEditor and then SlickGrid kept using editor (read from editor.model) and whenever the user wanted to read the SlickGrid editor after the grid was initialized, the user would have to get it from column.internalEditor (because after the initialization editor is SlickGrid's internal editor class not the one provided by the user), but that was so damn confusing... but now that Slickgrid-Universal is a standalone (no longer relying on 6pac/slickgrid) I decided to get rid of this confusion, so with this new release the editor remains the same to the user but the one used by SlickGrid just got renamed to editorClass. So in summary, editor is the same for the end user and editorClass is what is defined by model: Editors.longText and the internal ref swap that Slickgrid-Universal/Aurelia-Slickgrid was previously doing is no longer needed internally. Below is an example of when that would be in use

// previously, to add an item to the editor/filter collection 
this.columnDefinitions = [{ id: 'complexity', editor: { model: Editors.singleSelect, collection: [{ value: 1, label: 'Simple' }, /*...*/ ]; }];
// then adding an item would require to read `internalColumnEditor` 
// after grid init, our `editor` became `internalColumnEditor
- const complexityEditor = this.columnDefinitions[0].internalColumnEditor; 
// BUT with this new release, adding a new item to the collection is as simple as 
+ const complexityEditor = this.columnDefinitions[0].editor; 
complexityEditor.collection.push({ value: 9, label: 'Hard' });

// and if you want to read the SlickGrid editor, you would now use
this.columnDefinitions[0].editorClass; // which is the same as `editor.model`

Bug Fixes

• Filter model is now FilterConstructor and shouldn't be newed (#1169) (de97e6c) - by @ghiscoding
• hide Toggle Dark Mode from Grid Menu by default (#1167) (f9be216) - by @ghiscoding

Features

• rename SG editorClass & deprecate internalColumnEditor (#1168) (bb958ff) - by @ghiscoding