Release notes

Version 2.6.4 / September 24, 2018

NEW New export option property pageFormat was added. It allows setting page format for PDF export. Default value: "a4"

NEW The ability to hide entire row/column by setting its size in tableSizes to 0 was added.

NEW Now a new parameter calculateNaN is available for the calculated values. It allows configuring whether the calculation should be performed over the null or NaN parameters. Default value: true

FIX The issue with cropped labels in the report filters was fixed.

FIX Integrations with Angular, React, TypeScript were updated.

FIX The issue with JSON partial updates was fixed.

FIX The issue with a calculated value that uses difference or %difference aggregation and is in the first position among measures was fixed.

FIX The issue with editing and saving the calculated values was fixed.

FIX The issue with sorting in levels was fixed.

Version 2.6.3 / September 10, 2018

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.

Version 2.6.2 / August 27, 2018

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 autoCalculationBar has its own property in .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 AutoCalculationBar 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.

Version 2.6.1 / August 13, 2018

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:

    dataSource: {
       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.

Version 2.6.0 / July 30, 2018

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 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 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.