NEW The Nlog dependence was removed from the Accelerator DLL. Now it is possible to set your own logger which should implement ILogger interface.
Accelerator.Utils.LoggerLocator.SetLogger(new Logger());
NEW Now Accelerator DLL is available as a NuGet package.
NEW The fieldSeparator
property is now available for the CSV export.
FIX The issue with exporting customized cells to Excel was fixed.
FIX The issue when sorting is different in the flat table and in the filter pop-up if a hierarchy has more than 1000 members was fixed.
FIX The node expansion and drill-down issues when a measure was selected several times for the report based on OLAP data source were fixed.
FIX The display of redundant sorting arrows in columns or in rows of the pivot table was fixed.
FIX The display of several sorting arrows in columns of the pivot table, when one measure is selected with different aggregations, was fixed.
FIX The incorrect positioning of data labels (chart option showDataLabels: true
) for bars with negative values on the bar chart was fixed.
FIX The issue with using difference
, %difference
, runningtotals
aggregations in the calculated values was fixed.
FIX The getFilterProperties()
does not return the members property if the filter type is "none"
or if it is "top"
or "bottom"
, but there is no filter on members.
FIX PHP Compressor The issue with the Data Compressor for PHP was fixed.
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.