Skip to content

v5.2.2 - Excel Export Custom Styling & Format

Compare
Choose a tag to compare
@ghiscoding ghiscoding released this 22 Dec 01:29
· 1077 commits to master since this release

5.2.2 (2022-12-23)

This new release brings a lot of improvement on the Excel export feature, it will now auto-detect the correct cell format to use for a lot of column type. It is mostly helpful with column of type number, however please note that column Date type will be exported as string (not as Date type) even if exportWithFormatter (unless it is specifically set to false) the reason is because of complexity to implement in code, however that should be easy enough for the user to convert it himself. The next big thing, which is also for Excel export, is that we can now customize each column Excel cell styling & custom format (note that doing this would override any auto-detected Excel format).

Excel Custom Styling & Format Live Demo and Excel Custom Styling Wiki

Thanks to @austinsimpson for getting this feature started

Happy Holidays ⭐🎁🎄

Features

  • exports: add auto-detect and Excel custom cell (column) styling (5413e94)

Bug Fixes

  • styling: make Grid Menu item full width instead of max-content (b79a6ae)
  • common: cell selection in Firefox not working (45c5791)

Installation

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

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)