Features

• Official release of FlexMap control which supports rendering choropleths and point maps, such as scatter and bubble.
• [wijmo.xlsx] Added support for Microsoft Excel notes. Notes can be retrieved and set using the WorkbookCell.note property. The following changes were made to wijmo.xlsx:
  • Added note property to the WorkbookCell class and IWorkbookCell interface.
  • Added WorkbookNote class and IWorkbookNote interface. The "Excel/Workbook Viewer" sample is updated with a simple notes support implementation.
• [FlexGrid] columnGroups can now be defined using a typed object model, comprising ColumnGroupCollection and ColumnGroup objects. Changes in ColumnGroup properties, adding/removing/reordering ColumnGroup objects causes FlexGrid to automatically update its layout. By default, columnGroups property returns an empty ColumnGroupCollection collection now, where you can add first-level ColumnGroup objects. Each ColumnGroup object has its own 'columns' collection, where you can add child ColumnGroup objects, this way creating a column groups tree. The old way to define columnGroups using a POJO array is also supported.
• [FlexGrid] Added second optional includeAllColumnTypes parameter to the getColumn method, which allows you to find column group in the columnGroups tree by its name or binding.
• [FlexGrid] Added getColumnGroups() method, which returns effective ColumnGroupCollection collection used by grid, even if columnGroups were defined using a POJO array.
• [FlexGrid] Added support for repositioning column groups (reordering, moving to another group) by dragging them with the mouse.
• [FlexGrid] getColumn(true) method call performed on CellRangeEventArgs objects used in some events like formatItem or columnGroupCollapsedChanged, as well as on HitTestInfo objects, now returns a ColumnGroup object representing a group (containing child columns), when the affected area is such a group cell. Before now, this method returned only leaf (bound column) objects of the columnGroups tree.
• [FlexGrid] The columnLayout property now supports saving and restoring the columnGroups.
• [UndoStack] Added support for reordering and collapse/expand actions in column groups.
• [Angular] Added wj-flex-grid-column-group component to define column groups hierarchy in Angular templates, with a possibility to define cell templates for groups.
• [React] Added FlexGridColumnGroup component to define column groups hierarchy in React 'render' functions, with a possibility to define cell templates for groups.
• [Vue] Added wj-flex-grid-column-group component to define column groups hierarchy in Vue templates, with a possibility to define cell templates for groups.
• [PivotPanel] PivotPanel.deferUpdate property is added. The property defines whether the underlying engine is in a deferred update state or not. (WJM-20028)
• [FlexGrid] DataMap can now correctly work with keys which are complex objects or arrays of complex objects, by setting the newly added 'serializeKeys' boolean property to false. In this case, the DataMap stops converting keys to strings and uses the browser's Map class to store key-value pairs.
• Breaking Changes:
  • [FlexSheet] When updating a cell do not coerce strings to dates if the column's data type is DataType.String.
  • [FlexGrid] columnGroups property default value is changed from undefined to an empty ColumnGroupCollection object. Assignment of a POJO array to this property is still supported.
  • [FlexGrid] Column groups can now be repositioned using drag&drop by default. To disable this functionality, set the FlexGrid.allowDragging property to false.
  • [FlexGrid] getColumn(true) method call performed on CellRangeEventArgs objects used in some events like formatItem or columnGroupCollapsedChanged, as well as on HitTestInfo objects, now returns a ColumnGroup object representing a group (containing child columns), when the affected area is such a group cell. Before now, this method returned only leaf (bound column) objects of the columnGroups tree.
  • [OLAP] Default value for the PivotGrid's rowHeaders.columns.defaultSize property is the same as of the cells.columns.defaultSize property now.
  • [InputDate] If the control's input element contains an invalid value, and a drop-down calendar is opened, the text in the input element doesn't change. The text will be changed only after the control lost focus. In the previous builds, text had changed in this case to the current control's value, if invalidInput events were not used or set e.cancel to false.