NEW Now it's possible to associate JSON field with another column (set member property). Check the example on JSFiddle.
NEW kk pattern was added to set time format in dateTimePattern and datePattern. It is used for the hour of the day in a 24-hour format [1 – 24] which will be interpreted as numeric in two digits. For example, 01 or 24.
NEW Now the new line symbol("\n") is replaced with <br> for the header filter cells.
NEW Custom request headers are now available for OCSV requests.
NEW Now the auto-calculation bar has its own property in the .less file for the background color.
FIX The issue with obfuscated values in Chart Data Object was fixed.
FIX The positioning of custom headers for PDF chart export was fixed.
FIX The issue with positioning for the auto-calculation bar on the last row was fixed.
FIX The issue with multi-cell selection on Mac was fixed.
FIX The issue when setFormat() was called with maxDecimalPlaces: -1 or decimalPlaces: -1 and it did not work as expected was fixed.
FIX The issue when after canceling the connection to a local data file the pivot table is cleaned was fixed.
FIX The issue with the report when a format specified for a measure is applied not to all selections of this measure was fixed.
DEPRECATED CellDataObject.rows[].hierarchyUniqueName was renamed to hierarchyName.
DEPRECATED CellDataObject.columns[].hierarchyUniqueName was renamed to hierarchyName.
NEW New property timePattern was added. It allows formatting of fields with "type": "time" . The default value is null and it implies our default behavior.
NEW Changing measure aggregation from the context menu of chart legend was added (only for charts with multipleMeasures: true).
NEW Field type is now returned via API (i.e. getAllHierarchies(), getAllMeasures(), etc.) for JSON/CSV data sources.
NEW Now the custom headers and footers are also available for PDF and HTML charts export.
NEW Custom request headers are now available for CSV/JSON requests. Example:
flexmonster.setReport({
dataSource: {
filename:"https://cdn.flexmonster.com/data/data.json",
dataSourceType:"json",
requestHeader: {
'Authorization':"znati 21521512454"
}
}
});
FIX The issue with infinite preloader when OCSV loading error occurred was fixed.
FIX Member properties (SSAS, Mondrian) were moved to the separate sub-menu in the context menu.
FIX The issue when the selected headers are not copied was fixed.
FIX The issue with exporting large legend to Image and PDF was fixed.
FIX The issue with applying empty slice from flat Field List was fixed.
FIX The issue with resetting grandTotalCaption was fixed.
FIX The issue with not saving custom grandTotalCaption to the report was fixed.
FIX The issue when a calculated value created via UI was not added to the slice was fixed.
FIX The issue when member properties for Mondrian and SSAS data sources are displayed incorrectly on the grid was fixed.
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.
NEW The auto-calculation bar feature was added. Provides quick calculations for the selected cell 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 MM/dd/yyyy.
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 ("date", "date string", "year/month/day", "year/quarter/month/day" or "datetime") for CSV and JSON data sources. Check out the example on JSFiddle.
NEW Now "column" chart type is used instead of "bar".
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 <, >, ", ' or /, 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 <, >, ", ' or /, 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.
FIX 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.