NEW Ability to pick a measure several times for the report applying different aggregations. For example, Revenue measure can be selected 3 times for a pivot table showing different aggregated values Revenue (Sum), Revenue (Average) and Revenue (Max). (see a live demo on JSFiddle)
NEW Changing measure aggregation via context menu directly on the grid is now possible.
NEW Now it is possible to customize the right-click menu using
customizeContextMenu hook. Learn more.
NEW Custom members sorting is now possible by using JS compare function. Learn more.
NEW Compressor for Node.js is now available. Optimize loading of your JSON, CSV files and datasets from MongoDB (check out the tutorial).
NEW Now it is possible to select multiple cells on the grid.
autoCalculationBar feature was added. Provides quick calculations for the selected cells area.
NEW Sample standard deviation was added to the list of aggregations. The default labels for standard deviation now have the following names: population standard deviation — Population StDev, sample standard deviation — Sample StDev.
NEW The preloaders when filtering or switching to charts were added.
FIX The data time format on License panel was changed to
FIX Now, when you add a calculated value from UI the component checks whether its name is unique. In case it is not unique, the component adds
- 2 ending to make the name unique.
FIX The issue with editing in drill-through was fixed.
FIX The issue with ‘One million rows’ demo was fixed.
FIX The issue with showing
<b> tag when filtering data was fixed.
FIX The icon for editing a calculated value was updated.
FIX Drill through with filters was fixed for Mondrian.
NEW New option property
defaultDateType was added to specify which data type should be applied to date fields by default (
"datetime") for CSV and JSON data sources. Check out the example on JSFiddle.
"column" chart type is used instead of
FIX The issue when incorrect Field List is shown for charts if Flat form layout option is selected was fixed.
FIX The issues with saving/restoring sorting of the flat table were fixed.
FIX The issue with exporting time data to Excel was fixed.
FIX The issue with line endings in CSV export was fixed.
FIX The issue with loading CSV files in IE was fixed.
FIX The issue with the slow loading of data from SQL Server was fixed.
NEW New charts option property
showDataLabels was added to enable data labels displaying for column and bar chart types (see live demo on JSFiddle).
NEW Cell Data Object was extended with
escapedLabel property where certain characters, such as
/, are replaced by a hexadecimal escape sequence. Please note, now the example illustrating how to add links to some cells is updated (open on JSFiddle).
FIX The issue with custom sorting on the flat table was fixed.
FIX If field captions contain certain characters, such as
/, they will be displayed correctly in the component.
FIX The issue with column header resizing in the flat view was fixed.
FIX The issue with hidden scrollbars on macOS (Safari & Chrome) was fixed.
clear() method was improved to cancel loading of a report.
FIX The issue with row gridlines in macOS browsers (Safari & Chrome) was fixed.
FIX The issue with the wrong number of drilled members of the 3rd level was fixed.
FIX The issue with the array of arrays data source when it has only one member was fixed.
FIX The issue in the array of arrays data source when elements have
, sign was fixed.
FIX The issue with saving to OCSV was fixed.
FIX COMPRESSOR The issue with multi-level hierarchies was fixed.
NEW Now export to Excel works correctly when using such currency symbols: USD (usd), EUR (eur), HUF (huf), UAH (uah) etc.
NEW Now when exporting
datetime data to Excel, Excel also shows the time part and treats it like a date.
time data is treated like Time in Excel now. The recommended approach to use it: apply
ds+ type (
"date string" for JSON) to have simple date, apply
dt+ type (
"datetime" for JSON) to have datetime, apply
t+ type (
"time" for JSON) to have time data.
FIX The issue with fullscreen mode when zoom differs from 100% was fixed.
FIX The issue with deselecting fields in Flat view was fixed.
FIX The issue with an exception when switching from flat view to charts was fixed.
NEW Angular 6 support was added. Please update ng-flexmonster to the latest version.
NEW Now it is possible to calculate Standard Deviation for the specific measure (just choose the appropriate aggregation from the list).
NEW celldoubleclick event was extended to return the whole data row in a drill-through view. When the cell is double-clicked in the drill-through view,
celldoubleclick returns Cell Data Object with the new property
rowData is an array of cells from the underlying data row. Each cell is a Cell Data Object.
NEW Slice object was extended with a new
drillThrough property. It allows pre-defining slice for the drill-through view.
NEW datachanged event was extended to return the old value. It can be accessed the following way:
FIX The issue of adding fm-ui-element CSS class to DOM elements outside of the Flexmonster component was fixed.
FIX The expand/collapse icon disappearing when you drill down hierarchy was fixed.