Angular-Slickgrid

Quick Summary

Here is our new major (breaking change) version v5.0.0 release, it uses the new SlickGrid 3.0.0 and Slickgrid-Universal 2.0.0 which dropped jQueryUI requirement. Since we removed jQueryUI, we had to find replacement for the jQueryUI Autocomplete and settled on the Kraaden Autocomplete 3rd party lib and that is the biggest change to the developer in this new major version (it is a small code refactoring that can be done with search and replace). If you're not using the Autocomplete, then that will be an easy upgrade for you, you still have to read the migration guide below since there are other changes (ie angular.json file changes), it also requires Angular >=14

⚠️ Breaking Change - Follow the Migration 5.x Guide

Features

• core: BREAKING CHANGE replace jQueryUI by SortableJS (09f4d7d8)

Installation

Please remember that all packages of @slickgrid-universal (v2.0.0) and Angular-Slickgrid (v5.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

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 Angular-Slickgrid changelog (above)

⚠️ Small Breaking Change

Updating to latest jQueryUI to fix an XSS security issue identified in jQueryUI, see https://blog.jqueryui.com/

• in order for us to upgrade to latest jQueryUI version we had to remove the dependency of jquery-ui-dist, that package was used because it's an all-in-one dist minified build but was created by an external user and is not the official, neither maintained, by the jQueryUI team and is now falling behind in terms of their version and is missing out these important patched security fixes, so it is preferable to switch to the official package. There is however a small breaking change that you need to do which is a 1 line code change and is shown below (we no longer use jquery-ui-dist)

"scripts": [
  "node_modules/jquery/dist/jquery.min.js",
- "node_modules/jquery-ui-dist/jquery-ui.min.js",
+ "node_modules/jquery-ui/dist/jquery-ui.min.js",  // replace "-dist" by "/dist"
  // ...
],

Bug Fixes

• collectionAsync: hidden column does not load edit field selection (0b2db3d)
• deps: switch from jquery-ui-dist to the official jquery-ui (29f3ba6)
• deps: downgrade to Angular 13 to avoid breaking changes, fixes #994 (c0a3816)

Installation

Please remember that all packages of @slickgrid-universal (v1.4.0) and Angular-Slickgrid (v4.3.0) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues.

Changelog 📜

For a complete picture, you should take a look at both lib change logs

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 Angular-Slickgrid changelog (below)

Small fixes applied into Slickgrid-Universal regarding item update & also add demo on how to update Tree Data items in Example 28

Bug Fixes

• version: update to latest Slickgrid-Universal versions (c37f4b6)

Installation

Please remember that all packages of @slickgrid-universal (v1.3.7) and Angular-Slickgrid (v4.2.7) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues.

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding 👨‍💻

Changelog 📜

For a complete picture, you should take a look at both lib change logs

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 Angular-Slickgrid changelog (below)

Bug Fixes

• deps: loosen up RxJS min version to avoid interface out of sync (a29b4e5)
• build: use patch version when releasing from slickgrid-universal (4c58560)

Installation

Please remember that all packages of @slickgrid-universal (v1.3.x) and Angular-Slickgrid (v4.2.x) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues.

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding 👨‍💻

Changelog 📜

For a complete picture, you should take a look at both lib change logs

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 Angular-Slickgrid changelog (below)

Bug Fixes

• build: version of Slickgrid-Universal are out of sync, fixes #956 (b4e0a76)
• deps: update all non-major dependencies to v1.3.3 (3e81ef2)

Bug Fixes

• composite: selected row count always 0 on mass-selected, fix #951 (757155f)

Bug Fixes

• plugin: Row Detail column sorting was offset, fixes #949 (09cc298)

Features

• core: upgrade to jQuery 3.6 and jQuery-UI 1.13 (7e7f24c)

Bug Fixes

• core: throw error when [gridOptions] is missing, fixes #910 (974be12)

This new version brings a few new features and contributions, the main ones are:

• Cell/Row Selection Auto-Scroll, a new live Slickgrid-Universal - Example 17 to demo the feature (not an Angular demo but the code logic is the same)
• Row Dragging Auto-Scroll, check Example 17 for a demo
• All-in-one Filters Modal, see a live demo on Slickgrid-Universal - Example 7
• OData new $select and $expand options & other OData fixes, see live demo Example 5 and consult updated OData Wiki
• new Example 33, which is now the default route to demo a Real-Time Trading Platform, it also shows how fast SlickGrid really is.

Big Thanks to Contributors

Huge thanks for the following contributions

• OData contributions by @jr01

Thanks a lot 🚀

Installation

Please remember that all packages of @slickgrid-universal (v1.2.x) and Angular-Slickgrid (v4.1.x) must be updated at the same time and they will always get bumped on the same day to avoid any upgrade issues.

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding 👨‍💻

Changelog 📜

For a complete picture, you should take a look at both lib change logs

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 Angular-Slickgrid changelog (below)

Features

• demo: add new Example 33 to demo Realtime Trading (75987b4)
• OData: add $select and $expand query options (b445a79)

Bug Fixes

• build: should use EventSubscription to be unsubscribed (ee81db3)
• • demo: small leak fix when leaving the page (b488757)
• graphql: fix range filtering with ".." (cfcd16e)
• odata: fix range filtering with ".." (817ca59)
• core: pagination set in global config should work, fixes #879 (7237a23)
• rxjs: use same RxJS version as Slickgrid-Universal (9f68103)

⚠ BREAKING CHANGES (Ivy only & Slickgrid-Universal 1.x)

Follow the Migration Guide 4.x

Breaking Changes

• Ivy only build with Angular 13+ (no more UMD bundle, IE is officially out of the picture)
• Slickgrid-Universal 1.x major (and stable) release, it has some Breaking Changes but should be transparent for must developers that is if you are using the default CSS theme.

If however, you use a lot of SlickGrid SASS variables (all of them were renamed to add a $slick- prefix). If you also use a lot of the SlickGrid CSS classes directly for any of the menu plugins then you will also be impacted. in any case please review the Migration Guide 4.x

Biggest Internal Change (full SlickGrid controls/plugins rewrite)

The biggest internal change made in the lib for this version was to rewrite all of the SlickGrid controls/plugins into Slickgrid-Universal and that took a few months. Prior to this release, all of these controls/plugins were using what we can call bridges or wrappers (e.g. we had gridMenuExtension.ts for the Grid Menu that was pointing to the 6pac/SlickGrid/controls/slick.gridmenu.js with a bridge so that the lib could add our custom list of commands like "Clear Filters, "Clear Sorting", etc... that didn't exist in the core repo) now with the rewrite we can say goodbye to the bridges and we now only have 1 file which got renamed to common/extensions/slickGridMenu.ts. So what I did was to move them all into the lib but also rewrite all the jQuery code as plain JavaScript (or I should say TypeScript) and add proper unit tests for all of that.

You might ask... Does that mean we can get rid of jQuery? The answer is unfortunately still No, but we are closer than before (I would say about 60% of SlickGrid is now in plain JS code, prior to this release it was probably around 30%). What is coded in plain JS at this point are: all Editors, Filters, Controls & Plugins (there are some exceptions like AutoComplete Editor & DraggableGrouping which require jQueryUI). SlickGrid itself (and its DataView) are also still written in jQuery and that will take a lot of effort to convert.

Also with the rewrite comes a full set of new unit test suites (over 500+ new tests) and a bunch of new E2E tests (Cypress). This will now be a lot easier to maintain and we won't need to wait for a new release in both SlickGrid repo and this repo to take advantage of plugin changes & extra features. Another great thing about the rewrite is that there were a lot of duplicate code in SlickGrid plugins because every plugins had to be written as standalone (e.g. CellMenu and ContextMenu are to a very high proportion the same 1000 lines of code with the only small difference of what event is triggered to open the menu, the rest is the same), but with the rewrite in here, I removed all the duplicate code and merged a lot of independent CSS classes (that is the change that might impact you if you're using the default theme, so keep reading).

Some of the main changes

• full controls/plugins rewrite in plain JS/TS with full unit test suites
  • reconciled a lot of duplicate code for all menu plugins
  • reconciled all the menu plugins CSS classes, (headerMenu, cellMenu, contextMenu, ...)
    • if you use SASS variables or CSS directly this might impact you
• I imagine that we probably also have a smaller bundle size (but untested, see for yourself)
• there are also styling & features improvements with all the rewrite
  • you can now use both HeaderMenu and HeaderButtons on the same grid, see Example 7

Minimum Requirement Changes

• Angular-Slickgrid >= 13.0.0
• ngx-translate >= 14.0.0
• TypeScript >= 4.4.5
• RxJS >=7.4.0

Installation

Please remember that all packages of @slickgrid-universal (v1.1.x) must be updated at the same time as Angular-Slickgrid (v4.0.0), they will always get bumped on the same day to avoid any upgrade issues.

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding 👨‍💻

Changelog 📜

For a complete picture, you should take a look at both lib change logs

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 Angular-Slickgrid changelog (below)

⚠ BREAKING CHANGES

• upgrade to Slickgrid-Universal official 1.x major version
• upgrade Angular 13 using Ivy build without UMD bundles

Features

• plugins: use new internal slickgrid-universal plugins (9ef4651)

Bug Fixes

• styling: better support of auto width on drop menu (44a979d)

• Merge pull request #864 from ghiscoding/feat/slickgrid-universal-plugins (ee3bf0e), closes #864

• Merge pull request #857 from ghiscoding/feat/angular13 (9774b80), closes #857

new Custom Tooltip plugin

This new release brings a new Custom Tooltip plugin (opt-in), it can parse [title] attributes to create regular tooltip or create your own Custom Tooltip via a Custom Formatter. You can also create Custom Tooltip for Column Headers and Column Header-Row (filters).

• new Custom Tooltip - Wiki
• animated gif
• new live Example 32

new Row Move shadow clone item

When using the Row Move feature, we often forget which row we started the drag/move, so by adding a shadow item (it's simply a clone of the row you're dragging with absolute position that follows the mouse position) and this makes it easier to remind the user which row exactly is being moved. This is a new flag option hideRowMoveShadow that is enabled by default (if you want to use it, then change it to false).

• demo Example 17

A reminder to everyone, this is an Open Source project and everyone is welcome to contribute (even as small as fixing a typo in a Wiki is welcome). We all gain from contributions.

Installation

Please remember that all packages of @slickgrid-universal (v0.19.2) must be updated at the same time as Angular-Slickgrid (v3.3.2), they will always get bumped on the same day to avoid any upgrade issues.

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding 👨‍💻

Changelog 📜

For a complete picture, you should take a look at both lib change logs

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 Angular-Slickgrid changelog (below)

Features

• plugin: add example for new Custom Tooltip plugin (44dd1cd)
• plugin: add row move shadow item while moving/dragging row (9cf714f)

Fixes

v3.3.1

• extensions: add missing DI in Grid Menu (#856) (8f2fc550)

v3.3.2

• build: add DOM purify optional default import to fix rollup builds (25091d0)

Tree Data improvements

Tree Data filtering will now include children when the parent item passes its filter criteria, please note that this is different compare to previous version where it would not include children and if you still want the same behavior as before then you can use the new flag excludeChildrenWhenFilteringTree.

2x new options (flags) were created

• excludeChildrenWhenFilteringTree
• autoApproveParentItemWhenTreeColumnIsValid (which only work with excludeChildrenWhenFilteringTree: false which is default)
• animated gif demo

See the update Tree Data - Wiki for these new options and Example 29 for a live demo of all options.

New Grid Option

new grid option ignoreAccentOnStringFilterAndSort to ignore text with accent (like any Latin language) while Filtering/Sorting, see Wiki

Big Thanks for Contributions

A big thanks to @jr01 for his contribution to the auto-resize feature which can optionally use the Resizer Observer instead of (or in addition to) the window resize. The auto-resize - Wiki will soon be updated (in the meantime you can use it with gridOptions.autoResize.resizeDetection = 'container'

A reminder to everyone, this is an Open Source project and everyone is welcome to contribute (even as small as fixing a typo in a Wiki is welcome). We all gain from contributions.

Installation

Please remember that all packages of @slickgrid-universal (v0.18.0) must be updated at the same time as Angular-Slickgrid (v3.2.0), they will always get bumped on the same day to avoid any upgrade issues.

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding 👨‍💻

Changelog 📜

For a complete picture, you should take a look at both lib change logs

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 Angular-Slickgrid changelog (below)

Features

• core: use Slickgrid-Universal Pagination reusable component (9c47112)
• tree: demo new excludeChildrenWhenFilteringTree flag (7aa3d84)
• resizer: remove redundant bindAutoResizeDataGrid call (#839) (cee71c8)

Better Backend Error Handling for Filtering, Sorting & Pagination 🚀

As the title says, this new version brings better error handling of error thrown by backend, the biggest change is that if the backend server throws an error the grid will now rollback any changes in the grid (whether it's a Sort, Filter or Pagination change). So the lib now keep a reference of the last successful change and rollback that last status and the backend query string is also rolled back if any error is thrown, so you won't be left out with an unfinished activity.

• see Example 5 for a demo of that, the last column will always throw while Sorting/Filtering & there's also an extra button to test pagination error.

Cancellable Events for Filtering, Sorting & Pagination

Also in tandem with the previous paragraph, we now also have access to cancellable events (whether it's a Sort, Filter or Pagination change).
See the list below of all 3 possible events with their associated onBeforeX event:

• Filtering (onBeforeSearchChange)
• Sorting (onBeforeSort)
• Pagination (2 events are available depending on the grid type)
  • onBeforePaginationChange (with Backend Service API)
  • onBeforePagingInfoChanged (with Local In-Memory grid)

For example

<angular-slickgrid (onBeforeSort)="handleOnBeforeSort($event)" ...></angular-slickgrid>

handleOnBeforeSort(e: Event) {
    e.preventDefault();
    return false;
}

Installation

Please remember that all packages of @slickgrid-universal (v0.17.0) must be updated at the same time as Angular-Slickgrid (v3.1.0), they will always get bumped on the same day to avoid any upgrade issues. You might also need to upgrade to latest RxJS 7.3.0 version as well

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding

Changelog 📜

For a complete picture, you should take a look at both lib change logs

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 Angular-Slickgrid changelog (below)

Features

• backend: rollback on error & add cancellable events (d3f31d7)
• tree: add dynamicallyToggledItemState method to toggle parent(s) (afb61cf)

Bug Fixes

• composite: calling Edit change shouldn't affect Mass-Update (b25d56d)
• footer: use getFilteredItemCount to show correct item count (fbee1a1), closes #469
• grid: invalidate grid after setItems to re-render grid (4feebc8), closes #820
• grouping: Draggable Grouping should clear preheader when called (8621c67)

New major 3.x version 🚀

This is the next major and breaking version 3.x, it shouldn't be too complicate to upgrade just follow the Migration Guide to 3.x

biggest changes are the following

• it now uses a central monorepo library Slickgrid-Universal
  • a big portion of the code (90%) got moved into the monorepo and you will soon have to learn and love to use it
• it should also have a smaller bundle size (because it uses a monorepo, you can now choose what to install and what not to install)
  • a few Services are now opt-in to make smaller builds (Excel Export, Text Export, OData, GraphQL and much more)

there are new features included in this new Slickgrid-Universal monorepo

We included new Features as well, the biggest and most useful Feature is the new

• Composite Editor which allows you to Create, Clone, Update, Mass Update & Apply Mass Changes on Selected Rows via a modal window
  • Check out the new Example 30
• SlickGrid and DataView objects now have full Typing specs (in other words they all have .d.ts interface files)
  • Make sure to use the new SlickGrid and SlickDataView interfaces whenever you deal with these objects (there's also SlickNamespace for the entire SlickGrid namespace that includes controls, plugins, dataview, ...)
• You can now also use CSS Variables, if you prefer that over SASS, to customize styling (see Styling - CSS Variables Wiki)

To get started, make sure to follow the Migration Guide. Also note that all necessary Wikis have been all updated in one big push (you will see a mention on top of a Wiki saying "updated doc to 3.x version", for example Excel Export. Again make sure to follow the migration and/or clone the Angular-Slickgrid-Demos since they were already all updated

Follow the Migration Guide to 3.x

If you problems upgrading, you can open a Discussion

Minimum Requirement Changes

IMPORTANT below are the minimum requirements to upgrade (pay attention to RxJS which now requires 7.x), if for any reason you can't follow this minimum requirement then stick with the last version 2.30.4, it still works and should be for a wile. The only thing is that you'll be missing out of some of the new features introduced with version 3.x and also note that I stop providing fixes on older versions

• Angular-Slickgrid >= 12.1.0
• ngx-translate >= 13.0.0
• TypeScript >= 4.3.5
• RxJS >=7.2.0 (also a major bump)
• Bootstrap >= 4.5.0 (or any other UI framework like Bulma)
• IE11 support is dropped, min build target is now ES2018

Version 2.x is now out of support

Since I'm a team of 1 person (myself @ghiscoding), I won't be supporting the older version 2.x much longer unless there are small bug fixes to do. I still have a 2.x branch which I can update but I would prefer to only work on version 3.x.

Installation

Please remember that all packages of @slickgrid-universal (v0.16.1) must be updated at the same time as Angular-Slickgrid (v3.0.4), they will always get bumped on the same day to avoid any upgrade issues.

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding

Changelog

For a complete picture, you should take a look at both repo change logs

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

1. review the Slickgrid-Universal changelog
2. and the Angular-Slickgrid changelog (below)

⚠ BREAKING CHANGES

• use Slickgrid-Universal monorepo next major 3.0

Features

• add Composite Editor Modal example (3e2a4a2)
• core: use Slickgrid-Universal Aggregators (86a4e32)
• core: use Slickgrid-Universal Editors (a57edf8)
• core: use Slickgrid-Universal Formatters and Grouping Formatters (8648a88)
• footer: reuse Footer Component from Slickgrid-Universal (3932032)

Bug Fixes

• build: revert to previous ng-packgr build config (34890ca)

Tree Data

this new version adds the Tree Data into the Grid State & Presets (when enabled), so you could reload the grid by saving & reapplying the same Grid State and Presets (toggled items) that it existed before refreshing the page. There's also some more enhancements and fixes that you can see from the list below.

Others

in this version, we converted a few of the Filters/Editors from jQuery to native. That does not mean we can drop jQuery, but it's a start, SlickGrid uses jQuery heavily so I'm not even sure if it will ever be possible to drop jQuery completely (there's also a few external libs that are jQuery libs: multiple-select.js, jQueryUI autocomplete & slider range). On the other end, this conversion might bring better performance in some areas, at least I would imagine, on single/multiple Filter & Editors with large collection.

Some of the other internal changes made in this version also include a migration from TSLint to ESLint and upgrading Jest to version 27 and Angular 12.

• a big thanks to @jr01 for providing guidance on fixing some new warnings with Angular 12 and WebPack 5 🏆
  • read his comment and roughly the same as a readme instruction here

Major Announcement

the next major version is under active development and is expected to ship in couple weeks, it is a major rewrite and will require a few steps to upgrade but don't worry a very detailed Migration Guide is also in the process.

Why is it a big deal? Mostly because all the common code that Angular-Slickgrid & Aurelia-Slickgrid (2 libs that I support) are now moved into a monorepo lib called Slickgrid-Universal, this mean that Angular-Slickgrid code itself will get much smaller (10k lines of code are moved into the monorepo lib, and I won't have to duplicate features/fixes across 3 libs anymore, this is a big deal for me). The biggest structural change is that it's a monorepo structure, a lot of the Services were decoupled and are now becoming optional (OData, GraphQL, Text Export, Excel Export, ... and more are now opt-in) and this should help you ship smaller builds by downloading & installing only what you really use. For even more info, you can read a full explanation that was posted under an older release here under the section labeled "What's coming in the Future". Also note that Aurelia-Slickgrid has been using Slickgrid-Universal for the past 6 months, so I don't expect any problems going ahead with this change. There's also new features only available via the new major version, the biggest one is called Composite Editor modal, you can see a live demo on Aurelia-Slickgrid - Example 30

Also note that since I'm a team of one, well version 2 support will end as soon as version 3 is out. I however will keep a version2 branch in case of last minute fixes. Always remember that this is an Open Source project, please ask your questions on Stack Overflow and feel free to contribute, I'm always glad to get help 👷👷‍♀️

Minimum Requirement Changes

• Angular-Slickgrid >= 12.0.0
• ngx-translate >= 13.0.0
• TypeScript >= 4.2.4
• RxJS >=7.0.0 (also major bump)
• Bootstrap >= 4.5.0 (or any other UI framework like Bulma)
• IE11 support will be dropped, min target will be ES2018

3.x ETA 🤞 - Sometime in July or early August 🌞⛱️
You can follow the progress of the open PR #803

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding

Features

• deps: migrate from TSLint to ESLint (a60432b)
• editors: convert jQuery to native element for few Editors (f1a8c60)
• editors: convert jQuery to native element on longText Editor (cd3bf5e)
• editors: convert jQuery to native element on slider editor (871f86b)
• editors: replace jQuery with native element on date editor (149c05f)
• editors: use class inheritance to extend main input editor (9478692)
• filters: build multiple-select options from native dom elements (92813b3)
• filters: convert jQuery to native element on compound filter (fa8c174)
• filters: convert jQuery to native element on date filters (67840e3)
• filters: convert jQuery to native element on more filters (fd064cf)
• services: convert jQuery to native elements (fc2132f)
• tests: upgrade jest-preset-angular with Jest 27 (c68a5e6)
• tests: upgrade jest-preset-angular with Jest 27 (e2447ba)
• tree: add Tree Collapse Grid State/Preset (87d5c2a)
• editors: add new Input Password Editor which uses common inputEditor (66535fd)
• filters: convert jQuery to native element on few more filters (331accf)

Bug Fixes

• addon: providing columnIndexPosition should always work (4ff9935)
• demo: we should be able to move row(s) and keep selections (50e235c)
• editors: longText Editor (textarea) was scrolling to page bottom (e6d3a31)
• editors: select dropdown value is undefined it shouldn't call save (17555f2)
• export: expanded Row Detail shouldn't be exported (b6299e4)
• filters: filtering with IN_CONTAINS should also work with spaces (579e13f)
• formatters: shouldn't auto-add editor formatter multiple times (6c0cf5f)
• frozen: in some occasion column pinning changes column positions (0764013)
• menu: toggle filter bar could be out of sync w/horizontal scroll (5ed2ea9)
• pagination: should be able to toggle Pagination (4272b18)
• plugin: row move shouldn't go further when onBefore returns false (97c5f59)
• state: changeColumnsArrangement should work w/columnIndexPosition (831773b)
• state: Grid View/Columns dynamically should work w/row selection (65bf5dc)
• state: Grid View/Columns dynamically work w/row move/detail (d0bf315)
• styling: header title should show ellipsis if too long (50c7078)
• tree: using initiallyCollapsed change internal toggled state (91c48a2)
• tree: initial grid state should also include toggled presets (2c0cec8)
• tree: calling updateItems should not lose the Tree collapsing icon (399f770)
• editors: don't use nodejs type to avoid build issue (177b68f)
• core: make sure new dataset is an array before getting length (1d7fd03)
• pagination: toggle enablePagination flag only after setPagingOptions called (67c4f9e)
• editors: date editor clear button not showing (61bc6ca)
• filter: refreshTreeDataFilters only when Tree is enabled fixes #806 (4f826e2)
• formatters: Complex Object Formatter shouldn't throw with null data (295f29d)

This new version brings a lot of Tree Data Optimizations and Fixes. We now also have single column resize by content (enabled by default in all grids)

Tree Data

• refactor flat to tree structure and vice versa to optimize speed, it seems to be ~40-50x faster 😮🚀
  • yes it is incredibly faster, especially on first page load (previous implementation of converting from flat to tree structure was quite slow, there are specific npm libs that do a much better job at doing that than my own implementation), it wasn't working with 100k rows before but now it does 💯
• there's a lot of fixes and new features, you can see all features in the new Tree Data - Wiki and demos Example 28 / Example 29
• for a complete list of all features/enhancements (30+ changes), you can take a look at these 2 PRs #753 / #759 which have checklist of all the changes

Single Column Resize (double-click / header menu)

This new feature is enabled in all grids by default (and as any other feature of the lib, there's flag to disable it too). This new action is very similar to Excel column resize, it will read through the entire dataset (max at 5k rows) and calculate what width it requires to display all the text (it's not an autofit, it's really a resize by content calculation). The feature comes from a reuse of the code that was put in place to handle an entire Grid Resize by Content that was shipped in previous version except that now we also have a single column resize (the default grid resize will always be autofit in viewport).

• available via a double-click on the resize icon handle (between 2 columns), this is quite similar to how you can resize a column in Excel
• available via a new column header menu action ("Resize by Content")
• the single column resize uses the same options as the full grid resize by content, see all the available option below (just a hint, column resizeMaxWidthThreshold is an option I often use)
• a new Resize by Content - Wiki

Resize by Content Option - Small Breaking Change

Because there were many resize options ending up in the Grid Option, I moved all of them into a new ResizeByContentOption, you can see all info in the new Resize by Content - Wiki

Switch GitHub demo to Bootstrap 5

Now that Bootstrap 5 is official, I think it's a good time to switch Angular-Slickgrid to Bootstrap 5 and just remove the Bootstrap 3 demo (it still work but there's no need to keep the BS3 demo any longer). You can also visit the Bootstrap 4 demo. Also remember that Angular-Slickgrid also has different Styling Themes (see Wiki) and you can also make your own theme via all the SASS variables (feel free to contribute your theme to the lib).

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕ ... and if you already have, well thank you 😺

Cheers and Happy Coding

Features

• addon: provide grid menu labels for all built-in commands (b8b5aa2)
• editors: add ways to preload date without closing date picker (a544a76)
• resizer: add resizeByContentOnlyOnFirstLoad grid option (135771e)
• resizer: add single Column Resize by Content dblClick & headerMenu (183f33f)
• styling: switch from node-sass to dart-sass (sass) (3dcf7c9)
• tree: improve Tree Data speed considerably & fix more issues (900cd59)

Bug Fixes

• editors: select editor inline blur save before destroy, fixes #752 (aa27c56)
• resizer: remove delay to call resize by content to avoid flickering (ea4a196), closes #341
• services: fix resizer issue found in changeColumnsArrangement (288e364)
• addItem from grid service should work with tree data (94f83ca)
• export to file/excel should also have tree indentation (4450bc4)
• styling: add a better search filter magnify glass icon as placeholder (dc87beb)
• tree: couple of issues found in Tree Data (0b120f4)
• backend: able to preset filters on hidden columns & all queried (e10f723)
• resizer: fix a regression bug caused by previous commit (1e47ed2)
• sorting: multi-column sort shouldn't work when option is disabled (9841155)

The biggest feature is this release is probably the Resize Columns by their Content (that is an opt-in feature since it requires cpu cycle to parse through the dataset to calculate width of each column).

• Example 30 - Resize by Content (toggle between the 2 buttons to see the resize differences)
• Resize by Content - Wiki

There's also Row Selection Count that is now showing in the Custom Footer (unless you already have left footer text, if so it won't override it). The grids with colspan were also not exporting correctly and now they do (that is related to reading the item metadata)... there's a few other things, just see the full list below. You can also now filter empty values on the single/multipleSelect Filter (see Wiki)

Direct Link to Example Components

Also note, every Example now have a direct link to each Component TypeScript file, the link will be on the far right BS4+ (or beside the title in BS3). This will be much quicker to find the associated code of the Example Component you're looking at.

Enjoying the lib?

Make sure to upvote ⭐ and/or Buy Me a Coffee ☕
... and if you already have, well thank you 😺

Cheers

Features

• filters: add option to filter empty values for select filter (7c9ce5a)
• filters: option to add custom compound operator list, fix #733 (a86d3c5)
• footer: add row selection count to the footer component (5604669)
• resize: add column resize by cell content (c198686)
• typing: add missing item metadata interface (c3eefd0)

Bug Fixes

• exports: grid with colspan should be export accordingly (00989ab)
• footer: add correct implementation of locale usage in custom footer (5dcac2f)
• observables: http cancellable Subject should be unsubscribed (c439324)
• selection: full row selection should be selected w/show hidden row (131ada5), closes #739

This new release brings a few nice new Features the most notable are the following

• add optional filterTypingDebounce for filters with keyup (mainly default Text Search Input and its Compound version), this will help users dealing with huge dataset, add a debounce/throttle should speed up the search since it will query only after user pauses typing
• add Pinning (frozen cols/rows) to the Grid State & Grid Presets
  • you can give it a try in the Example 16, you can freeze a column from the Header Menu and then refresh the Page and expect to see the Pinning remain after page reload
• ... and a few other changes, check the list below

Enjoy it

Enjoying the lib? Make sure to upvote ⭐ and/or Buy Me a Coffee ☕
... and if you already have, well thank you 😺

Cheers

Features

• editors: add onSelect callback to Autocomplete Editor (#718) (392304c)
• filters: add IN_COLLECTION operator to search cell value as Array (#722) (cd494ce)
• filters: add optional filterTypingDebounce for filters w/keyup (#720) (b4deea9)
• filters: add possibility to filter by text range like "a..e" (#711) (aa4fa03)
• filters: display operator into input text filter from Grid Presets (#719) (cf6593a)
• state: add Pinning (frozen) to Grid State & Presets (b47f2a0)

Bug Fixes

• filters: add more variable checking in multiple-select external lib (#710) (ced4a1e)
• filters: SearchTerms shouldn't come back after calling clearFilters (b986cb9)
• filters: string <> should be used as Not Contains instead of Not Equal (#709) (e50a060)
• metrics: use onRowCountChanged event to refresh metrics fix #715 (#716) (f123854)
• pinning: reordering cols position freezing cols shouldn't affect others (#708) (e24c6de)
• plugin: Grid Menu Clear Frozen Cols shouldn't change cols positions (#721) (ee07d79)
• presets: Multiple Select Filter Grid Presets values should be shown (6f06d1d)

As the title suggest, this new release brings a few improvements in terms of performance. especially in the following 3 areas

1. there was a contribution, in this PR, done on the SlickGrid (core) lib to improve batch (insert/edit/delete) and so I also made the changes in the Grid Service to take advantage of them in the following methods (addItems, updateItems and deleteItems)
   • the test done in SlickGrid (core) is by inserting 100k rows in a grid (before: 1100ms vs after: 200ms)
2. date sorting is now 2x times faster (check full test logs in the PR)
   • on 50k rows with sorting 1 date column, before 1981.27ms and after 903.99ms => 2.1x faster
3. date filtering is now between 4x to 6x times faster (check full test logs in the PR)
   • all type of filters might benefit but the date is the biggest perf boost
   • on 50k rows with filtering 1 single date column, before 1471.19ms and after 246.01ms => 6.1x faster
   • on 50k rows with filtering 1 date range column, before 2695.77ms and after 591.40ms => 4.4x faster

You first reaction might be... how did you gain so much perf boost?
It all started when I was looking at where MomentJS is used in the lib, then I noticed that the Date sorting is actually parsing to a MomentJS object twice (1x for validating the date and 1x for the actual date) but that could be improved to do it in 1 parsing execution (use the same moment object to call momentDate.isValid() and then just use it for the sorting diff)... so with that done, I decided to take a look at date filtering to also avoid double parsing, but what I ended up finding, was that were being double parsed and worst than that, it was re-parsing the search values on every single cell value comparison (in other words if we have 50k rows, it was double-parsing the date in the search value 50k times and double-parsing the cell value 50k as well... so when it was supposed to compare and parse 50k rows + 1 time parsing for search value, it was in fact parsing over 4 times that which was about 200k parsing instead of 50k + 1 row... hence the perf boost between 4-6x faster). You can try it yourself, go over the GitHub demo page on Example14 and/or Example 19 then click on "50k rows" and test it out for yourself. If you are dealing with couple thousand rows, you might not notice the difference but make that 25,000 or 50,000 rows and you will surely notice the boost 🚀

Enjoy it

Enjoying the lib? Make sure to upvote ⭐ and/or Buy Me a Coffee ☕
... and if you already have, well then thank you 😺
Cheers

Features

• filters: add updateSingleFilter for a single external filter (#699) (677beb4)
• perf: huge filtering execution speed improvements (#694) (f93a24d)
• perf: improve date sorting speed (#691) (1040352)
• services: add bulk transactions in Grid Service CRUD methods (#687) (277e627)
• tests: add Cypress E2E tests to Bootstrap Tabs Example (#698) (b8d1d14)

Bug Fixes

• backend: incorrect item with GraphQL and useLocalFiltering (#697) (aa78e76)
• exports: Excel Export custom width applies the width to next column (#683) (fffa711)
• filters: don't use indexOf with NOT_IN_CONTAINS (#693) (844e167)
• frozen: hiding multiple columns when using pinning gets out of sync (#684) (a453d76)
• plugin: recreate header menu w/adding column dynamically, fix #689 (#690) (1b89e2f)
• build: enable tsconfig strict mode tsconfig, fixes #675 (#702) (7219249)
• filters: make sure Select Editor/Filter collection is filled (#700) (61e6599)
• filters: use defaultFilterOperator in range when none provided (#705) (a176037)
• helpers: should be able to highlight first row (0) (#701) (269f1e9)
• plugins: do not recreate header button plugin after re-render (#706) (da62a48)

First big release of the year, this version brings a lot of great features, enhancements and a small (but noteworthy) breaking change, see below. Happy New Year 🚀

Main Changes

• a new collectionOverride for the Select Editor (single/multiple) and the AutoComplete Editor which allows to change the collection per cell clicked (see Collection Override - Wiki
• add Bootstrap 5 support (big thanks to @gcko for the contribution and a new BS5 Demo now part of the Angular-Slickgrid-Demos)
• OData Service fixes to better handle filter ranges & decimals (big thanks to @jr01 for these fixes)
• following the OData changes, these were also applied to the GraphQL Service
• a few Tree Shakable enhancements were made
  • external SlickGrid plugins are no longer imported via require(plugin), which was not Tree Shakable, they are now imported the more natural way via import(plugin) which is Tree Shakable
  • I also found out that all the Flatpickr Locales were being imported (also because of require(flatpickr/locale), you need to see the breaking change below.

Breaking Change (Flatpickr Localization)

As mentioned in previous paragraph, I found out that all the Flatpickr (date picker) Locales were all being imported (over 60 locales) and ended up in the bundle/build, so in order to fix that we now ask the developer (you) to import whichever Flatpickr Locale you need via your App Module (right after AngularSlickgridModule import), if you omit/forget to do this, it will display a console warning and revert to English. I didn't want to do a major release for this small change and there's also a console warning to tell you when you forget to import the locale properly, worst case is that you'll see English being used instead of the expected locale.

• more info in this Wiki Flatpickr Localization

Final Note & Thanks

Again big thanks to @gcko and @jr01 for their contributions.
If you like the lib, please upvote ⭐ and/or Buy Me a Coffee ☕

Features

• core: export Editors, Filters & Formatters as Public (e244218)
• core: methods to change column positions/visibilities dynamically (49ab5e5)
• editors: add Column Editor collectionOverride option (96cbd78)
• styling: add support for Bootstrap 5 (afb79e7)
• editors: change all private keyword to protected for extensability (#680) (029a90c)
• filters: change all private keyword to protected for extensability (#679) (e5b5e8d)

Bug Fixes

• backend: GraphQL queries with input filter (8465610), closes #656
• backend: OData queries with input filter (5822de1)
• build: import Flatpickr Locale on demand via regular imports (ef06543)
• core: add console error if any of column def id includes dot (b1aa321)
• core: range default should be inclusive instead of exclusive (4990162), closes #650
• core: use regular imports instead of require to load plugins (b5204e5)
• editors: slider value not shown with undefined & fix small styling (b85c6c5)
• exports: should be able to change export file name, fixes #655 (7b2a9ef)
• plugin: Row Detail loses html content when used with Row Selection (93b59c7)
• sorting: add cellValueCouldBeUndefined in grid option for sorting (24584b1)
• comp: empty data warning should work with autoheight grid, fix #671 (58c593b)
• filters: Grid State filters should always include an operator (#676) (9ded204)
• metrics: refresh metrics also when providing new data to DataView (#677) (7b95401)
• metrics: use onRowsOrCountChanged to refresh metrics (#681) (ceb0d77)
• pinning: recalculate frozen idx properly when column shown changes (#682) (996125d)
• plugins: throw when Tree Data used with Pagination, closes #658 (672db5f)
• typings: add specific file type to export service options (b99c6e4)