v2.2.0 - Excel Export Custom Styling & Format
2.2.0 (2022-12-21)
This new release brings a lot of improvement on the Excel exports, 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 ⭐🎁🎄
Bug Fixes
- editors: Autocomplete list should be using same width as cell width (#846) (0055f8a) - by @ghiscoding
- export: create custom Excel cell format with Formatters.decimal (#844) (a7a626c) - by @ghiscoding
- exports: Date should always export w/Formatter unless false (#856) (1b249e8) - by @ghiscoding
- formatters: add all missing Date Formatters (#855) (9d29e59) - by @ghiscoding
- formatters: Date Formatter should work with Date object (#854) (30b80e2) - by @ghiscoding
- styling: Grid Menu & Col Picker overflow in Firefox (#845) (9b0aef7) - by @ghiscoding
Features
- exports: Excel exporter will now observe if numeric type has dollar formatter. If it does, it will use the dollarFormatter stylesheet. (#843) (ebabbaf) - by @austinsimpson
- exports: add Excel auto-detect format by field types & formatters (#848) (27a18c4) - by @ghiscoding
- exports: add Excel custom cell (column) styling (#851) (dd92d44) - by @ghiscoding
- exports: add optional Excel export parser callback functions (#852) (975da5b) - by @ghiscoding
- exports: add optional file MIME type to Excel export service (#849) (05402e5) - by @ghiscoding
- formatters: add Currency Formatter and GroupTotalFormatter (#850) (ad373ab) - by @ghiscoding