What's New in Wijmo 2018 v3
Check out the newest features and updates from Wijmo's third major release of 2018.
Build 568 is identical to build 567; however, it includes a fix to a critical bug in FlexSheet. The issue was prominent in our Angular interop and in some other cases, when a Sheet itemsSource was being bound without the Sheet being owned by a FlexSheet instance.
Check out the Wijmo Build 568 Release
Build 5.20183.567 is now available. It includes some new features and a plenty of bug fixes.
- Added two new LearnWijmo fiddles that highlight the FlexGrid’s basic and advanced features.
- Added a cssClassAll property to the FlexGrid's Row and Column classes so you can add CSS classes to header cells as well as to data cells.
- Added two new settings to the wijmo.olap.ShowAs enumeration: PctPrevRow and PctPrevCol cause the engine to show values for each item as a percentage of the value in the previous row or column.
- Added two extra parameters to the FlexGrid.getClipString method so it can be used to export to CSV (instead of tab-delimited text) and to optionally include column headers.
- Added a Tooltip.cssClass property to allow different types of tooltips to use different styles (e.g. information, validation, etc)
- Improved the ComboBox.selectedValue property to get or set the control's text when it has no itemsSource. This makes it easier to use the ComboBox as a replacement for regular input elements (and leverage wijmo's infrastructure including styling).
- Added a new "exclusiveValueSearch" property to the PivotEngine and FlexGridFilter classes. This new property is set to true by default, which enables an Excel-like behavior (searching excludes items from the filter). Set it to false to disable this, so searching only affects which items are displayed on the list, and not which items are included in the filter.
- [AngularJS] Added auto-size-rows boolean property to the wj-flex-grid-cell-template directive, which is being set to false disables the default behavior where the cell template increases grid's default row height to accommodate cells content.
- Improved the FlexGrid IME handling to start editing on Unicode spaces as well as regular spaces.
- [WebComponents] Added Beta version of the WebComponents interop (wijmo.webcomponents.567.js modules). The Samples\TS\WebComponents\WebComponentsIntro sample explains the status and usage of the interop.
Wijmo’s third major release of 2018 has landed, and it includes Web Workers, new OLAP features, a Ribbon sample, accessibility improvements and more.
PDF export can often slow down web apps: since the export is happening in the browser’s UI thread, it can cause the rest of the application to be unusable. This is where Web Workers comes to the rescue. We used Web Workers to process the exporting of PDF files on a separate thread from the application UI. This allows the applications to stay usable and the PDF export to churn along in the “background”.
We've added a showGroups property that you can use to add group headers to ListBox and ComboBox controls. Group header items are added if the showGroups property is set to true and the itemsSource collection has grouping enabled.
We’ve added a ribbon sample that shows how you can create ribbons easily using the TabPanel control and the controls in Wijmo's input module.
The ribbon element is a TabPanel. The tab pages contain groups of controls arranged in rows and columns. Controls in the groups use Material Icons, and have tooltips created automatically based on the aria-label attribute assigned to each control.
We have added a Slicer control to our OLAP module. The Slicer control provides a quick way to edit filters applied to PivotField objects.
The Wijmo PivotGrid allows you to drill down into cells to see the data items that were used to calculate each summary.
Now, the grid exposes the detail dialog through its detailDialog property, which can be used to customize the dialog:
We also added a PivotField.getValue property to OLAP that allows you to specify a custom function to be used for retrieving the field value for a given item. You can use this to implement calculated fields such as 'binning' (e.g. Value => large/medium/small) or calculated expressions (e.g Conversion => downloads/sales).
You can now click on the year header to open a year picker that allows you to much more easily jump to different years. This little enhancement should save your end users some time when selecting dates.
Our Menu control now supports adding multiple submenus to it so that you can create more complex menus and context menus. We also added an option to open menus on hover.
We're very excited about Angular 7, and as you know, Wijmo has first-class Angular support. We're happy to announce that Wijmo supports Angular 7, so you can use the current version of Wijmo to build Angular 7 applications today.
- Added support for FlexGrid pdf export using Web Workers. See the PdfWebWorkersClient and PdfWeb Workers for the details. The AngularJS PdfExport sample has added Web Workers example to demonstrate the feature.
- Wijmo fully supports Angular 7.
- [WebComponents] Added Beta version of the WebComponents interop (wijmo.webcomponents.xxx.js modules). The Samples\TS\WebComponents\WebComponentsIntro sample explains the status and usage of the interop.
- [npm] Wijmo is published to the global npm registry as the 'wijmo' package.
- Added a GroupPanel.filter property that allows you to specify the FlexGridFilter being used on the grid. Once you do that, the group panel will show filter glyphs on the group headers. Clicking the filter glyphs opens the filter editor for the corresponding column.
- Added a PivotGrid.detailDialog property that returns a reference to the grid's DetailDialog control used to display detail records when the user double-clicks a cell.
- Added a repeatButtons property to the Calendar and InputDate controls that causes the calendar buttons to fire repeatedly while the button is pressed. (This is similar to the InputNumber.repeatButtons property).
- Added a showYearPicker property to the Calendar and InputDate controls that causes the calendar to show a list of years when the user clicks the year calendar header.
- Added a PivotField.getValue property that allows you to specify a custom function to be used for retrieving the field value for a given item. This can be used to implement calculated fields which can be used for 'binning' (e.g. Value=> large/medium/small, Country=> A/B/C/Other) or any calculated expression (e.g Conversion=> sales/downloads).
- Added a showGroups property to the ListBox and ComboBox controls. This adds group header elements to lists with grouped item sources.
- Optimized ListBox loading performance (especially in IE/Edge).
- [FlexSheet] Added option to let user disable dragging cell ranges. Added 'enableDragDrop' property to FlexSheet. (TFS 342191)
- [FlexSheet] Disable formulas in FlexSheet. Add 'enableFormulas' property in FlexSheet. (TFS 341806)
- Added a new wijmo.olap.Slicer control that provides easy value-based filtering. This is similar to the Slicer control in Excel's PivotTables.
- Added a new wijmo.olap.PivotField.visible property that allows developers to hide certain fields so they do not appear in PivotPanel controls (and therefore cannot be removed from or moved within the view definition).
- [Enhancement][FlexSheet] Click and Drag Cell Corner to Fill Data. (TFS 229151)
- Expanded the documentation to include missing default values for several properties on several controls.
- [Enhancement] [FlexSheet] Support for INDIRECT and ADDRESS formulas. (TFS 337828)
Check out the Wijmo 2018 V3 Release
Release Builds & Dates