Softpedia >Windows >Programming >Components & Libraries >Flexmonster Pivot Table & Charts component >  Changelog

Flexmonster Pivot Table & Charts component Changelog

What's new in Flexmonster Pivot Table & Charts component 2.9.76

Apr 29, 2024
  • NEW:
  • Descriptions in license pop-up alerts were improved.
  • FIX:
  • The issue with the default conditional formatting styles was fixed.
  • The issue with incorrect calculated value formulas when field captions are used instead of unique names was fixed.
  • The issue when dragging fields into an empty row area in the classic pivot table led to console errors was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.75 (Apr 15, 2024)

  • It is now possible to override default formatting styles in the conditional formatting view. To modify the styles, use the toolbar.defaults.defaultConditionalFormat object.

New in Flexmonster Pivot Table & Charts component 2.9.74 (Apr 1, 2024)

  • NEW: The level property of the CellDataObject is now available for column cells.
  • FIX: The issue with the reportchange event not being triggered on filtering while using the custom data source API was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.73 (Mar 19, 2024)

  • NEW Flexmonster CLI Flexmonster CLI dependencies were updated.
  • NEW theme builder The less dependency for the theme builder was updated.
  • FIX The issue with the wrong running totals calculation for multilevel hierarchies when the expandAll property is enabled was fixed.
  • FIX The issue with filtering when the expandAll property is enabled and a multilevel hierarchy is selected in the slice was fixed.
  • FIX pivot charts The issue with the measures dropdown menu closing when the scrollbar is clicked was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.72 (Mar 4, 2024)

  • FIX: The issue with keyboard navigation on frozen cells in the classic form was fixed.
  • FIX: The styling of focused context menu items when using keyboard navigation was improved.
  • FIX: The issue with generating Flexmonster CSS files using the latest lessc command was fixed.
  • FIX: The issue with horizontal scroll jumping when using updateData() with custom data source API was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.70 (Feb 5, 2024)

  • FIX: The issue with expands not being restored when using the custom data source API was fixed.
  • FIX: flexmonster.d.ts The conditions property was added to the CellData interface.

New in Flexmonster Pivot Table & Charts component 2.9.69 (Jan 22, 2024)

  • It is now possible to select a group of cells using Shift + click. Click the necessary cells with the Shift key pressed, and Flexmonster will select the cell area between them

New in Flexmonster Pivot Table & Charts component 2.9.68 (Jan 8, 2024)

  • NEW: It's now possible to set multiple license keys in the licenseKey property through an array (see docs).
  • NEW Angular 14+ wrapper: Implementation of the ngOnDestroy method was added to the ngx-flexmonster wrapper.
  • NEW Angular 5-15 wrapper: Implementation of the ngOnDestroy method was added to the ng-flexmonster wrapper.
  • NEW Vue wrapper: Implementation of the unmounted hook was added to the vue-flexmonster wrapper.
  • NEW flexmonster.d.ts: The divider property was added to the ToolbarTab interface.
  • NEW flexmonster.d.ts: The chartType property was added to the ChartData and ChartLegendItemData interfaces.
  • FIX: The issue with date filters such as "current", "last", and "next" when Daylight Saving Time starts or ends was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.67 (Dec 25, 2023)

  • NEW:
  • Blazor wrapper The LiveFiltering property was added to the Options class and the Aggregation property was added to the ConditionalFormat class.
  • Flexmonster CLI Flexmonster CLI dependencies were updated.
  • FIX:
  • The issue with drill downs and drill ups when some members are hidden using table sizes was fixed.
  • The issue with the opposite scroll direction on row header cells in Firefox was fixed
  • Blazor wrapper The issue with the Format object configurations not being applied to a report was fixed.
  • Flexmonster CLI The issue with Flexmonster CLI when using Node.js 21 was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.65 (Nov 27, 2023)

  • NEW: The sample Flexmonster and Angular project was updated to Angular 17.
  • FIX: The issue with setting more than 128 measures in the slice was fixed.
  • FIX: Accelerator The .NET Framework runtime was included in the setup project.

New in Flexmonster Pivot Table & Charts component 2.9.64 (Nov 13, 2023)

  • New formatting options "$1" and "1$" were added to the negativeCurrencyFormat property.
  • A new formatting option "1" was added to the negativeNumberFormat property.

New in Flexmonster Pivot Table & Charts component 2.9.62 (Oct 16, 2023)

  • NEW:
  • New serverContentType parameter was added for the save() API call. When saving a report to a server, use the serverContentType to set the Content-Type header for the POST request: "application/x-www-form-urlencoded" or "application/json" (preferable).
  • Compatibility with Content-Security-Policies (CSP) was improved.
  • FIX:
  • Error handling for saving a report to a server when data exceeds the limit of the encodeURIComponent() method was improved.
  • Accelerator The issue with recognizing the type of date hierarchies on SSAS tabular models was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.61 (Oct 2, 2023)

  • FIX:
  • The issue with field headers disappearing in the classic form when a filter returns an empty result was fixed.
  • The issue with detecting a target cell for the context menu in the fullscreen mode was fixed.
  • The issue with drilling up and down multilevel hierarchies when options.grid.showHierarchies is false was fixed.
  • The issue with omitting some parts of JSON data when the data is loaded by chunks and contains some special characters was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.60 (Sep 18, 2023)

  • FIX:
  • The issue when the reportchange event was not triggered after changing a chart type was fixed.
  • The issue with parsing certain whitespaces in JSON data was fixed.
  • The issue with the showEmptyValues mapping property not working properly for hierarchy levels with empty values was fixed.
  • custom data source API The issue where options.showEmptyValues stopped working for the custom data source API was fixed.
  • Data Server The issue with JSON and CSV parsers in the Data Server as a DLL was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.59 (Sep 4, 2023)

  • NEW: The .fm-grid-header and .fm-grid-header-mobile CSS selectors were added to customize the width and height of grid sheet headers. See an example on JSFiddle.
  • NEW: mapping The visible property is now available for SSAS. The property can be defined for dimensions, hierarchies, and measures.
  • FIX: The issue with converting 1 to true and 0 to false when exporting the flat table to Excel was fixed.
  • FIX: The issue with unicode symbols corrupting the file exported to Excel was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.58 (Aug 21, 2023)

  • NEW Data Server:
  • New installations of the Data Server as a Windows/Unix service now store their configuration file and logs next to the Data Server executable. If you have been using the Data Server as a service, the location of the configuration file and the logs is not changed.
  • FIX:
  • The issue with the console error when using licenseFilePath was fixed.
  • The "Failed to parse source map..." console warning was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.57 (Aug 7, 2023)

  • FIX: The issue with hidden x-axis labels on a bar chart's edge when values are negative was fixed.
  • FIX: The issue with missing cells when printing a report with long text values was fixed.
  • FIX: The "Can't resolve 'worker_threads' ..." console warning was fixed.
  • FIX: The issue when large JSON files loaded via URL were considered invalid was fixed.
  • FIX Data Server: The issue when quotes in a CSV header row were not ignored was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.56 (Jul 24, 2023)

  • NEW: The percentofparentrowtotal, percentofparentcolumntotal, percentofcolumn, and percentofrow aggregations now always return a positive percent value.
  • NEW: Admin Panel Flexmonster Admin Panel dependencies were updated.
  • FIX: The issue with regular cells in columns being formatted bold as subtotal cells was fixed.
  • FIX: The issue with the Minimize Toolbar tab not switching back to Fullscreen sometimes was fixed.
  • FIX: The issue with hidden x-axis labels on a bar chart's edge when values are negative was fixed.
  • FIX: The issue with disappearing members when removing measures from the grid using the context menu was fixed.
  • FIX: Flexmonster CLI The issue with corrupted files when using Node.js v18.17.0 was fixed.
  • FIX: Data Server The issue with the KeepDataOnRefresh property was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.55 (Jul 10, 2023)

  • NEW:
  • A sample Next.js + TypeScript project is now available on our GitHub.
  • Flexmonster CLI A sample Next.js + TypeScript project was added to the create command.
  • Flexmonster CLI The add command now saves an exact Flexmonster version to package.json.
  • FIX:
  • The exception when changing the Fullscreen tab's ID in the Toolbar was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.54 (Jun 26, 2023)

  • NEW SSAS The options.showEmptyData property now works for SSAS.
  • FIX The issue with throwing The JSON data is invalid error was fixed.
  • FIX The issue with an empty page and the missing last column when using print was fixed.
  • FIX Data Server The issue with hierarchy levels that have different data types set in the mapping was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.53 (Jun 12, 2023)

  • NEW:
  • The showEmptyValues property is now available in the mapping. Use this property to show members with empty values for specific fields.
  • Admin Panel The Help tab now displays the Data Server's version.
  • FIX:
  • The issue with the Maximum call stack size exceeded error when switching to charts was fixed.
  • The issue with loading JSON data as an array of arrays via the stream loader was fixed.
  • The issue with missing spaces in member names when loading large remote JSON files was fixed.
  • Theme builder The CSS version mismatch warning in themes generated by the custom theme builder app was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.52 (May 29, 2023)

  • NEW:
  • Angular wrapper A new Ivy-compatible ngx-flexmonster wrapper was released to provide support for Angular 16. ngx-flexmonster works with Angular versions 14 and later.
  • Flexmonster CLI The new ngx-flexmonster wrapper is now available in the add and update commands.
  • Data Server MariaDB was added to the list of supported databases. See how to connect to MariaDB.
  • Admin Panel MariaDB is now available in the list of database types.
  • FIX:
  • The issue with the currency symbol appearing for "Count" and "Distinct count" aggregations in Excel export was fixed.
  • The issue with opening exported Excel files in LibreOffice was fixed.
  • The issue with duplicating values of calculated measures after updateData() was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.51 (May 15, 2023)

  • FIX The issue with escaping data between <> symbols during Excel export was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.50 (May 1, 2023)

  • FIX:
  • The issue with formatting datetime fields when exporting to Excel in the drill-through view was fixed.
  • The issue with expand/collapse icon disappearing when the levelName is defined was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.49 (Apr 17, 2023)

  • FIX:
  • The issue with the sortingMethod() not being applied after updateData() was fixed.
  • Blazor wrapper The issue with types in the Report class was fixed.
  • Data Server/custom data source API The issue with values not being shown in a drilled hierarchy was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.48 (Apr 3, 2023)

  • NEW:
  • Using the new grid.autoSwitchToCompact option, it is now possible to disable the automatic switch from the classic to the compact form. By default, the automatic switch is enabled.
  • FIX:
  • TypeScript TypeScript definitions were updated for getMembers() and getMembersAsync() methods.
  • Admin Panel The issue with the Settings page not reflecting changes was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.47 (Mar 20, 2023)

  • Fixed:
  • The issue with horizontal scroll shifting when using updateData() with the custom data source API was fixed.
  • The issue when editing in the flat view cleared extra cells was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.46 (Mar 6, 2023)

  • FIX:
  • The issue when slice changes made on the grid were not synchronizing with the Field List was fixed.
  • The issue with the jumping scroll when using updateData() with the options.partial parameter was fixed.
  • Admin Panel The max value limit for number inputs was improved.

New in Flexmonster Pivot Table & Charts component 2.9.45 (Feb 20, 2023)

  • A new Mapping configuration is now available when editing JSON and CSV indexes. Use this configuration to adjust the autodetected field data types.

New in Flexmonster Pivot Table & Charts component 2.9.44 (Feb 6, 2023)

  • NEW:
  • Exported Excel files are now compressed if the client's browser supports the "deflate-raw" compression.
  • The sample Flexmonster & Ionic React project was updated to Ionic 6.
  • Data Server A new Mapping configuration property was added to the config. This property allows specifying data types for fields in JSON and CSV.
  • FIX:
  • The issue with "Maximum call stack size exceeded" when the number of items in the filter exceeds 1000 members was fixed.
  • Data Server The issue with number columns being treated as strings when the first record is null was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.43 (Jan 23, 2023)

  • NEW: The Exclude option was added to the members' context menu. Use it to hide specific members from the report.
  • NEW: The sample Flexmonster & Ionic project was updated to Ionic 6.
  • FIX: The issue with searching in the filter pop-up window when dataSource.useStreamLoader is set to true was fixed.
  • FIX: Data Server The issue with value filters on the flat view was fixed.
  • FIX: SSAS The issue with showing empty charts if there are no total values was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.42 (Jan 10, 2023)

  • NEW:
  • The sample Flexmonster & React Native project was upgraded to React 18.
  • React Native wrapper Our React Native wrapper now supports React 18.
  • Accelerator The minimum required version of .NET was updated from 4.5.2 to 4.7.2.
  • FIX:
  • Performance of the distinct count aggregation for numeric measures was improved.

New in Flexmonster Pivot Table & Charts component 2.9.41 (Dec 27, 2022)

  • FIX:
  • The issue with the reportchange event being triggered twice for the flat view was fixed.
  • The issue with export to image when using Angular was fixed.
  • Custom data source API The issue with the order of aggs[].keys affecting the hierarchy structure was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.40 (Dec 12, 2022)

  • New:
  • New formatting options $(1) and (1)$ were added to the negativeCurrencyFormat property.
  • Data Server PEM certificates are now supported and can be set in the HTTPS settings.
  • Fix:
  • The issue with restoring expandAllColumns/expandAllRows from the slice was fixed.
  • The issue with losing expanded rows/columns after partial expandAllData() was fixed.
  • The issue with removing measures using the context menu was fixed.
  • The issue with the reportchange event being triggered twice in the flat view was fixed.
  • Data Server The issue with setting an empty password for PFX certificates was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.39 (Nov 28, 2022)

  • NEW:
  • The ES5 build was removed from all deliverable packages.
  • expandAllData() now allows expanding rows and columns separately.
  • FIX:
  • The issue with the drill-down for members with ids was fixed.
  • The structure of the drill-down queries when using the custom data source API was improved.
  • Blazor wrapper The issue with the Mapping property of the DataSourceobject was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.38 (Nov 14, 2022)

  • FIX The issue with hidden values on classic view with "showGrandTotals": "off" option was fixed.
  • FIX The issue with long values overflowing other columns when printing was fixed.
  • FIX The issue with removing a column that is positioned after a multilevel hierarchy in flat view using drag and drop was fixed.
  • FIX The issue with "count" aggregation and export to Excel was fixed.
  • FIX The exception when adding a field to a report with a specific flat sort configuration (CSV/OCSV data source) was fixed.
  • FIX MongoDB Connector The issue with the BSON size limit was fixed.
  • FIX MongoDB Connector The issue with the undefined data page after the server restart was fixed.
  • FIX Data Server The issue with restoring users was fixed.
  • FIX Admin Panel Now the file picker opens at the chosen file’s location.

New in Flexmonster Pivot Table & Charts component 2.9.37 (Nov 1, 2022)

  • Fixed:
  • The exception when using aggregation over non-existent measure in calculated values was fixed.
  • The issue with exporting the centered text to PDF was fixed.
  • The issue with exporting large data to Excel was fixed.
  • MongoDB Connector The issue with undefined schema after server restart was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.36 (Oct 18, 2022)

  • NEW:
  • Integration with Flutter framework for iOS/Android was introduced. Read docs.
  • FIX:
  • The issue with exporting calculated values containing percent formula to Excel was fixed.
  • The issue with exporting thousandsSeparator format to Excel was fixed.
  • The issue with the expand query structure was fixed.
  • The issue with infinitely loading pop-up in the flat view was fixed.
  • The issue with page scroll jumping after closing the drill-through view was fixed.
  • The issue with long captions overlapping aggregations in the Field List for the flat view was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.35 (Oct 3, 2022)

  • NEW:
  • For calculated values, the round function now accepts a second argument to specify how many decimals to round. Default value is 0.
  • A new concurrentRequests property was added to the DataSourceObject. When its value is true, the expand/drill requests are sent simultaneously. Default values is false.
  • FIX:
  • The issue with changing slice from the Field List was fixed.
  • The autocomplete option for input fields was disabled.
  • The issue with applying round and abs functions over other calculated values was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.34 (Sep 20, 2022)

  • New:
  • A new Database query settings section was added to the Settings page. Now, it is possible to set how many seconds to wait for SQL commands to execute.
  • Data Server The new property CommandTimeout was added. It allows setting the wait time (in seconds) before terminating the attempt to execute a command and generating an error. The default value is the value of the SQL driver.
  • Gix:
  • The issue with extending Array.prototype was fixed.
  • The issue with the "recordId" property in row headers was fixed.
  • The exception when switching from flat view to compact with all nodes expanded was fixed.
  • The issue with rendering multiple white spaces in chart labels was fixed.
  • Blazor wrapper The issue with GetFiler() API call was fixed.
  • Blazor wrapper The type of FlatSort property in the Slice object was changed.
  • Blazor wrapper The issue with ShowTotals property in the GridOptions object was fixed.
  • Blazor wrapper The PageFormat property was added to the ExportOptions object.
  • Flexmonster.d.ts The pageFormat property was added to the ExportOptions interface.

New in Flexmonster Pivot Table & Charts component 2.9.33 (Sep 5, 2022)

  • NEW FLEXMONSTER CLI:
  • Now flexmonster-cli provides instructions for running Flexmonster Data Server on ARM-based Macs.
  • FIX:
  • The issue with the drillThroughMaxRows inconsistency was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.32 (Aug 22, 2022)

  • FIX:
  • When in fullscreen, the Toolbar “Fullscreen” label changes to “Minimize”.

New in Flexmonster Pivot Table & Charts component 2.9.31 (Aug 8, 2022)

  • FIX:
  • Vue wrapper The shareReportConnection property was added to vue-flexmonster.
  • FIX:
  • Vue wrapper The CSS error notification in new Vue 3 projects was fixed.
  • FIX:
  • Error handling was improved when the fullscreen feature is disabled on the page.

New in Flexmonster Pivot Table & Charts component 2.9.30 (Jul 26, 2022)

  • The issue with setting useOlapFormatting: true was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.29 (Jul 11, 2022)

  • NEW Blazor wrapper:
  • A new JavaScriptHandler property was added to the constructor.
  • FIX:
  • The issue with internal aggregations when setting useOlapFormatting: true was fixed.
  • The issue with scrollToRow and scrollToColumn methods when scrolling to max values in Firefox was fixed.
  • The sizes of scrollbars were adjusted for the latest versions of Firefox.

New in Flexmonster Pivot Table & Charts component 2.9.28 (Jun 28, 2022)

  • NEW SSAS:
  • It is now possible to set the DATABASE connection string property through the report.dataSource.catalog when connecting to the tabular model via the Accelerator.
  • NEW:
  • Blazor wrapper All Flexmonster events are now asynchronous.
  • FIX:
  • The issue with the Toolbar redraw was fixed.
  • The issue with exporting to PDF and image in RequireJS was fixed.
  • Flexmonster CLI The issue with the global npm warning was fixed.
  • MongoDB Connector The issue with filtering when the /handshake request is not implemented was fixed.
  • Blazor wrapper The issue with Caption in the Hierarchy class was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.27 (Jun 14, 2022)

  • NEW:
  • The new "dataRootPath" property was added to the DataSourceObject. It allows defining the path to the JSON data in the JSON object.
  • FIX:
  • The exception when there’re only columns in slice and showEmptyValues: true was fixed.
  • The issue with value filters for nested hierarchies was fixed.
  • Flexmonster Blazor The issue with type converting in CellDataObject was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.26 (May 31, 2022)

  • NEW:
  • Elasticsearch The new mapping properties calendar_interval and fixed_interval were added for compatibility with Elasticsearch 8.x. Note: for Elasticsearch before version 7.2 it is now required to explicitly set the deprecated interval property for dates.
  • Data Server The new property RetryAttempts was added. With this property, if any indexes are unavailable during the restart, the Data Server will try loading them later.
  • Admin Panel The new Retry attempts data storage setting was added to the Settings page.
  • FIX:
  • The issue with blocking the Apply button in the Field List if exception occurs in getData() callback was fixed.
  • The issue with the data overriding while loading expands and drills using custom data source API was fixed.
  • The issue with the "filters" property from mapping not working for charts was fixed.
  • The issue with the Toolbar’s dropdown menu was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.25 (May 16, 2022)

  • NEW Data Server:
  • The version of .NET was updated to 6.0.
  • NEW Blazor wrapper:
  • The Flexmonster package is now taken from Flexmonster.Blazor NuGet package instead of CDN.
  • FIX:
  • The issue with multiple pivot instances was fixed.
  • The issue with a report filter initialization for the Flexmonster Accelerator was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.24 (May 3, 2022)

  • FIX The issue with intervals on dates after daylight saving time was fixed.
  • FIX The exception when loading specific reports was fixed.
  • FIX The issue with a false double-click detection was fixed.
  • FIX custom data source API The issue with overriding the real data type in mapping on the client side was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.23 (Apr 18, 2022)

  • Fix:
  • The issues with report filters while using the XMLA protocol was fixed.
  • FLEXMONSTER DATA SERVER The issue with expanding when the levelName is in the slice was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.22 (Apr 4, 2022)

  • The issue with the filter by values when using measures with multiple aggregations was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.21 (Mar 22, 2022)

  • NEW:
  • Custom data source API New parameter querytype was added to the /select request.
  • Added new property dataSource.useGranularityNamesForDateFilters for proper dates filtering depending on cube structure.
  • FIX:
  • Custom data source API The issue with duplicate requests was fixed.
  • The issue with the "tab" symbol in Excel export was fixed.
  • The issue with sortOrder when caseSensitiveMembers is true was fixed.
  • The issue with getData API call when there are only columns in the slice was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.20 (Mar 7, 2022)

  • NEW:
  • Now js-flexmonster can be used in the add and update commands to add/update the flexmonster npm module.
  • FIX:
  • The issue with hierarchy levels not being ordered according to the result of /members request was fixed.
  • The issue with filter by values when there are measures with different aggregations was fixed.
  • The issue with dateTimezoneOffset property not applicable for drill-through when using Elasticsearch was fixed.
  • The issue with drill-down of the filtered data was fixed for Analysis Services.

New in Flexmonster Pivot Table & Charts component 2.9.19 (Feb 21, 2022)

  • New:
  • Field search was added to the calculated value pop-up.
  • Events olapstructureerror / queryerror / dataerror now receive additional argument with error details.
  • Fix:
  • The issue with expandAllData() when the levelName is in the slice was fixed.
  • The issue with triggering "reportchange" event when expanding cell for custom data source API was fixed.
  • The issue with expanding when using custom data source API was fixed.
  • Accelerator DLL The issue with data loading from Azure getting stuck after service restart was fixed.
  • HIGHCHARTS CONNECTOR The issue with additional underlines in the legend and tooltip was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.18 (Feb 7, 2022)

  • FIX:
  • The issue with the percent aggregation formula when data contains only zeroes was fixed.
  • The issue with incorrect CellDataObject returned to cellclick callback was fixed.
  • Error handling when connecting to Elasticsearch was improved.
  • Flexmonster ACCELERATOR Required .NET Framework was updated to version 4.5.2 or higher.
  • Flexmonster Data Server The issue with loading data from the database when columns have identical names was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.17 (Jan 24, 2022)

  • NEW Now it is possible to set different number formatting for measures with different aggregations.
  • NEW Now it is possible to set conditional formatting based on different aggregations.
  • NEW New API call sortFieldsList() for sorting Field List items was added.
  • FIX The issue with displaying HTML entities on the chart labels was fixed.
  • FIX Flexmonster Data Server The issue with reloading indexes after failing was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.16 (Jan 10, 2022)

  • NEW FLEXMONSTER ADMIN PANEL: Flexmonster Admin Panel packages were updated.
  • FIX:
  • The issue with unexpected calculations when working with time measures was fixed.
  • The issue with duplicate tuples when using the editing feature was fixed.
  • The issue with the unnecessary "datachanged" event triggering was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.14 (Dec 13, 2021)

  • NEW Now only numeric fields are available in conditional formatting pop-up.
  • FIX The issue with the warning when setting predefined filters for OLAP data source was fixed.
  • FIX The issue with expand all when using Flexmonster Data Server was fixed.
  • FIX The issue with export to Excel when using "dateTimezoneOffset" was fixed.
  • FIX The issue with "dateTimezoneOffset" option was fixed.
  • FIX Formula validation for the calculated values was improved.
  • FIX The issue with hiding grand totals in classic mode was fixed.
  • FIX Highcharts connector The issue with the measure order when a numeric caption is used was fixed.
  • FIX FLEXMONSTER.D.TS The options parameter was added to the prepareDataFunction property definition for amCharts, Highcharts, Google Charts, and FusionCharts connectors.
  • FIX FLEXMONSTER ADMIN PANEL The error pop-up that appears when inspecting a failed index was improved.

New in Flexmonster Pivot Table & Charts component 2.9.13 (Nov 29, 2021)

  • NEW: The sample Angular integration project was updated to Angular 13.
  • FIX: flexmonster.d.ts The type definition for the grid.showTotals option was fixed.
  • FIX: Flexmonster Data Server The issue with cache expiring during data reload was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.12 (Nov 15, 2021)

  • NEW: VUE-FLEXMONSTER Support for Vue 3 was added to vue-flexmonster.
  • NEW: FLEXMONSTER-CLI Support for Vue 3 was added to flexmonster-cli.
  • FIX: The issue with members filtering on multilevel hierarchies when showEmptyValues: true was fixed.
  • FIX: The issue with saving column table sizes on the flat view was fixed.
  • FIX: User experience for controls in React Native apps was improved.
  • FIX: The issue with deleting calculated values was fixed.
  • NEW: New sample Flexmonster & Vue integration projects were added:
  • Flexmonster & Vue 2 Typescript
  • Flexmonster & Vue 3 JavaScript
  • Flexmonster & Vue 3 TypeScript

New in Flexmonster Pivot Table & Charts component 2.9.9 (Oct 4, 2021)

  • NEW:
  • Now Flexmonster sends console warning if CSS version mismatches with the version of the component.
  • FIX:
  • The issue with storing members when using Turkish language setting in browser was fixed.
  • The issue with converting 1 and 0 to true and false when exporting to Excel was fixed.
  • The issue with highlighting search results in multilevel hierarchies was fixed.
  • The issue with removing measures using context menu was fixed.
  • The issue with range date filters was fixed.
  • Flexmonster Data Server The issue with connection to Oracle databases was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.8 (Sep 20, 2021)

  • FIX:
  • The issue with cached data during export to Excel was fixed.
  • The compatibility issue in the drillDownCell API call was fixed.
  • The issue with the wrong isTotal value of the drilled-up cells was fixed (if options.grid.showHierarchies is set to false).
  • The issue with a date format not applied to the grand total row in the flat view was fixed.
  • The issue with conditional formatting not working with options.useOlapFormatting was fixed.
  • Flexmonster Data Server The issue with expanding 4+ fields in rows was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.7 (Sep 6, 2021)

  • FIX:
  • The issue with exporting data with / symbols to Excel was fixed.
  • The performance of drill-down operation was improved.
  • The issue with the filtering of the second level of hierarchy in the context menu was fixed.
  • FIX FLEXMONSTER.D.TS The type definition for customizeAPIRequest() was added to the property types.

New in Flexmonster Pivot Table & Charts component 2.9.6 (Aug 24, 2021)

  • NEW New methods expandCell, collapseCell, drillDownCell, drillUpCell were added to the Flexmonster API.
  • NEW TypeScript type definitions were added to the downloadable ZIP package.
  • NEW Now "type" property is also returned for getAllHierarchies() and getAllMeasures() API calls when using Elasticsearch.
  • FIX The issue with opening local report when Flexmonster is placed in an iFrame was fixed.
  • FIX The issue with formatting % values in the drill-through view was fixed.
  • FIX The issue with the wrong isTotal value of the drilled-up cells was fixed.
  • FIX The issue with the filtering in the context menu was fixed.
  • FIX The issue with applying CSS classes to submenu items in customizeContextMenu() was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.5 (Aug 9, 2021)

  • FIX FusionCharts connector The issue with the currency symbol not getting applied was fixed.
  • FIX Google Charts and Highcharts connectors The currency symbol alignment was improved.
  • FIX The issue with data labels out of bounds on the bar chart was fixed.
  • FIX Value sorting is kept when changing slice using the Field List.
  • FIX Several improvements were added for the “Black-Orange” and “Midnight” predefined CSS themes.
  • FIX The issue with corrupted symbols in the date search input was fixed.
  • FIX The issue with loading the reports without measure sorting was fixed.
  • FIX The issue with the object’s keys naming in the save callback function was fixed.
  • FIX FDS/CUSTOM data source API The issue with dependent calculated values was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.4 (Jul 26, 2021)

  • NEW Integration with the Blazor framework was added (read docs).
  • FIX The issue with calculated values naming was fixed.
  • FIX The issue with sortOrder not affecting "date string" fields was fixed.
  • FIX Flexmonster Data Server The ThousandSeparator property was renamed to ThousandsSeparator in the configuration.
  • FIX Flexmonster Data Server The issue with loading an HTTPS certificate with a password was fixed.
  • FIX Flexmonster Data Server/Custom data source API The issue with not applying conditional formatting if a formula contains a reference to a measure was fixed.
  • FIX Flexmonster Admin Panel The Windows issue with infinite loading screen if incorrect settings are applied was fixed.
  • FIX Flexmonster Accelerator The issue with CACHE_MEMORY_LIMIT max value was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.3 (Jul 12, 2021)

  • NEW A new round function was added to the calculated values view.
  • FIX The issue with sortingMethod when working with custom data source API was fixed.
  • FIX The issue with clearing flatSort when changing the slice was fixed.
  • FIX The issue with drag and drop in the Field List was fixed.
  • FIX Dragging to the top position in the Field List was improved.
  • FIX The issue with appearing in Excel export was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.1 (Jun 14, 2021)

  • NEW:
  • It is now possible to clear value sorting using the sortValues() method.
  • The ES5 option was added to the react-flexmonster npm package.
  • Accessibility The filter view was optimized for on-screen readers.
  • FIX:
  • The issue with the none aggregation appearing in the measure caption was fixed.
  • The issue with clearing the sorting on grand totals was fixed.
  • The issue with showing two and more spaces in the member names on the grid was fixed.
  • The issue with formatting date/time values in Excel for number aggregations like count was fixed.
  • The issue with losing filters after partial data update was fixed.
  • The issue with losing slice changes when removing a calculated measure in the Field List was fixed.
  • The issue with calculated values naming was fixed.
  • Now the text fill property is considered during chart export.
  • Flexmonster Data Server:
  • The issue with re-entering the user password after restarting the Data Server was fixed.
  • The issue with default folder creation for report sharing was fixed.
  • The issue with sharing a report containing calculated values was fixed.

New in Flexmonster Pivot Table & Charts component 2.9.0 (May 31, 2021)

  • NEW Flexmonster Data Server:
  • Flexmonster Admin Panel – a graphical user interface for Flexmonster Data Server – was introduced (read docs).
  • Accessibility Major accessibility improvements were introduced (read docs).
  • MongoDB Connector Performance of the MongoDB Connector was significantly improved.
  • Now it is possible to share a report using Flexmonster Data Server (read docs).
  • Flexmonster Data Server Flexmonster Data Server is now available as a Windows/Unix service (read docs).
  • New framework integrations were added:
  • Mapping An ability to create several fields from one field when using a JSON or CSV data source was added (read docs).
  • The following async API calls were introduced (read docs):
  • GetRowsAsync()
  • GetColumnsAsync()
  • GetReportFiltersAsync()
  • GetAllHierarchiesAsync()
  • GetMeasuresAsync()
  • GetAllMeasuresAsync()
  • GetMembersAsync()
  • GetXMLAProviderNameAsync()
  • GetXMLADataSourcesAsync()
  • GetXMLACatalogsAsync()
  • GetXMLACubesAsync()
  • MongoDB Connector It is now possible to configure caching and logging for the MongoDB Connector (read docs).
  • MongoDB Connector Multilevel hierarchies are now supported for MongoDB.
  • Mapping The following intervals were added to the mapping.interval property:
  • Y for one year.
  • Q for one quarter.
  • M for one month.
  • W for one week.
  • Mapping The mapping.visible property is now supported for JSON.

New in Flexmonster Pivot Table & Charts component 2.8.33 (May 17, 2021)

  • NEW:
  • Now getMeasures and getAllMeasures methods return the groupName property for SSAS.
  • It is now possible to define aggregations for fields of a certain type in the mapping when using CSV and JSON data sources.
  • FIX:
  • The issue with the collision when including an alternative version of the html2canvas library was fixed.
  • The issue with positioning the buttons in the conditional formatting pop-up window was fixed.
  • The issue with filtering invalid dates having a custom localization label was fixed.
  • The exception when dragging a field to the side (and out) of the window in a specific layout was fixed.
  • The issue with getting stuck in a loading state when there’s a gap between the last JSON response and the streaming end was fixed.
  • The issue with not applying folder property for the datetime type in the mapping was fixed.
  • The issue with cell selection after a partial update was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.32 (May 4, 2021)

  • NEW:
  • flexmonster.full.js was added to the WebJar package.
  • ACCESSIBILITY Alerts and preloaders were optimized for on-screen readers.
  • ACCESSIBILITY The calculated values editor was optimized for on-screen readers.
  • Accessibility Now it is possible to enable high contrast theme by using the Ctrl+Alt+H shortcut.
  • JSON Now mapping can be adjusted only for some fields while the rest have default settings.
  • FIX:
  • Accessibility For report filters, hitting the Enter/Space key now opens a context menu with available actions.
  • The issue with adding unwanted decimal parts for specific numbers while formatting was fixed.
  • The issue with the broken grid after selecting not visible filter cells on the classic and compact form was fixed.
  • The issue with similar names in complex multilevel hierarchies was fixed.
  • The issue with unnecessary automatic validation of buttons in Chrome was fixed.
  • The issue was the ‘none’ aggregation for OLAP data sources was fixed.
  • The exception in the chart view with Infinity values was removed.

New in Flexmonster Pivot Table & Charts component 2.8.31 (Apr 20, 2021)

  • NEW Flexmonster is now available on WebJars.
  • NEW Now Flexmonster API is also available from container’s uielement.
  • NEW esc key handling was improved.
  • NEW Accessibility The Field List was optimized for on-screen readers and keyboard navigation.
  • NEW Flexmonster CLI Now the version command notifies if a newer version of Flexmonster CLI is available.
  • NEW Custom data source API Now it’s possible to add a custom aggregation for a specific field.
  • FIX Setting isMeasure: true for non-numeric fields by mistake now doesn’t cause console exceptions.
  • FIX Members filtering for multilevel hierarchies was improved.
  • FIX The issue with scrolling the flat form using the tab key was fixed.
  • FIX The issue with expands array being set to undefined after collapsing members was fixed.
  • FIX Specifying the height property for ng-flexmonster was improved.
  • FIX The issue with a dropdown position being shifted inside the conditional formatting pop-up was fixed.
  • FIX The issue with irresponsive Toolbar buttons in Angular after canceling the “Open file” dialog was fixed.
  • FIX The issue with the blank measure’s name in the conditional formatting pop-up was fixed.
  • FIX The issue with multiple Toolbar instances was fixed.
  • FIX Flexmonster Accelerator The issue with continuous query repeating to SSAS server with specific slice was fixed.
  • FIX Flexmonster Accelerator NuGet package layout of the Flexmonster.Accelerator was changed to include the DLL inside lib folder.

New in Flexmonster Pivot Table & Charts component 2.8.30 (Apr 6, 2021)

  • NEW: For a custom API data source, the unauthorizederror event was added. It can be used to refresh the authorization headers. Read more in the documentation.
  • FIX: The exception when dragging a field to the bottom of the window was fixed.
  • FIX: Flexmonster Accelerator The issue with the Accelerator’s cache when using Windows Authorization was fixed.
  • FIX: The issue with the period filters when working with Elasticsearch was fixed.
  • FIX: The issue with the size of the Toolbar labels was fixed.
  • FIX: The issue with number formatting affecting the data was fixed.
  • FIX: The save() API call now properly returns both success and error information.
  • FIX: The issue with a misspelled measure name in the tableSizes object leading to the exception was fixed.
  • FIX: Custom data source API The issue with the drill-downs in the nested hierarchies was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.29 (Mar 23, 2021)

  • NEW Now dragging is also available when there is a multilevel hierarchy in the flat view.
  • FIX The issue with the Field List position settings not getting restored was fixed.
  • FIX The issue with withCredentials not applied using updateData() was fixed.
  • FIX The Field List search was fixed to find calculated values properly.
  • FIX The issue with folder mapping property for strictDataTypes: true was fixed.
  • FIX The issue with allowing to drop measures to filters/rows/columns for strictDataTypes: true was fixed.
  • FIX The exception when a multilevel hierarchy is specified with empty levels was fixed.
  • FIX SSAS Accelerator The issue with showing data when specific cell data permissions are set for the role was fixed.
  • FIX Flexmonster Data Server The issue with applying label filters on empty string values was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.28 (Mar 9, 2021)

  • NEW Now filters mapping property disables live filtering for specific fields.
  • FIX The issue with the "sep=" prefix in files with UNIX newline symbol encoding was fixed.
  • FIX The issue with several report filters when using SSAS with the Accelerator was fixed.
  • FIX The issue with sorting columns with levels when the filter is applied was fixed.
  • FIX The issue with sorting values when measures are placed on the first position in the slice rows/columns was fixed.
  • FIX The exception when setting conditional formatting with specific filters was fixed.
  • FIX The issue with missing columns in PDF export for the drill-through view was fixed.
  • FIX IE11 The issue with CSS styles in the Toolbar was fixed.
  • FIX Angular The exception in the Format Cells window was fixed.
  • FIX The issue with dispatching celldoubleclick instead of cellclick after a single click on flat table headers was fixed.
  • FIX The issue with responsive styles for the filter view was fixed.
  • FIX The issue with grid layout on the flat view when moving focus over headers and scroll was fixed.
  • FIX Custom data source API The issue with redundant data loading when filtering hierarchical data was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.27 (Feb 23, 2021)

  • NEW New methods scrollToRow() and scrollToColumn() to scroll the grid to a specified row or column were introduced.
  • NEW Now it is possible to resize the filter view vertically and horizontally.
  • NEW Now "Values" remain at the last position in rows/columns after dragging (if it was last before dragging).
  • NEW Now loadingreportfile event is triggered when loading the report from the disk.
  • FIX The issue with triggering reportfilecancelled multiple times was fixed.
  • FIX The sep= prefix format was changed according to Excel standard. Now it supports the following: sep=; and "sep=;".
  • FIX The issue with zero time values was fixed.
  • FIX Custom data source API Improved compatibility with older versions of the custom data source API protocol.

New in Flexmonster Pivot Table & Charts component 2.8.26 (Feb 9, 2021)

  • NEW Accessibility: the Toolbar was optimized for keyboard navigation and screen readers.
  • NEW Now it is possible to define the sep= prefix on the first row of the CSV file. It will be considered as fieldSeparator while parsing CSV files.
  • NEW Flexmonster Data Server New property LoggerMinLevel was added to the configuration file.
  • NEW Flexmonster Data Server Multiple server filters can be specified now in Flexmonster.DataServer.Core.dll.
  • FIX The issue with specifying the timezone using datePatern/dateTimePattern was fixed.
  • FIX The issue with getData() output when working with dates was fixed.
  • FIX The issue with adding several calculated values was fixed.
  • FIX The issue with editing formulas through the context menu was fixed.
  • FIX The issue with the column resize was fixed.
  • FIX The scroll in the Toolbar when using Safari was fixed.
  • FIX The exception when loading JSON data with null values on hierarchy levels was fixed.
  • FIX The issue with closing pop-ups after resizing the component was fixed.
  • FIX Custom API data source The issue with merging filter configurations in the /fields request was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.25 (Jan 26, 2021)

  • NEW JS/EXE/DLL deliverables are now signed using the code signing certificate
  • FIX Now react-flexmonster is compatible with React 17
  • FIX The issue with unexpected scrolling after opening pop-ups was fixed
  • FIX The issue with parsing date fields was fixed
  • FIX The issue with the tooltip not shown on trimmed chart legend text was fixed
  • FIX The “Maximum call stack size exceeded” error in the drill-through view when using custom data source API was fixed

New in Flexmonster Pivot Table & Charts component 2.8.24 (Jan 11, 2021)

  • NEW Removing fields in the Field List by dragging them out of the current panel (columns, rows, measures, etc.) was added.
  • NEW CUSTOM API DATA SOURCE A new singleEndpoint property was added to the Data Source Object. If set to true, all custom data source API requests will be sent to a single endpoint specified in dataSource.url.
  • FIX The issue with the number formatting view when using custom measure captions was fixed.
  • FIX The issue with saving number formatting for only active measures was fixed.
  • FIX If the data expanding process is terminated, all unexpanded members remain available.
  • FIX The issue with numeric labels being passed to FusionCharts was fixed.
  • FIX Flexmonster Data Server The issue with the size of logs was fixed.
  • FIX FLEXMONSTER.D.TS The type definition for getReport() API call was fixed.
  • FIX CUSTOM API DATA SOURCE The issue with the presorted members in the hierarchical fields was fixed.
  • FIX CUSTOM API DATA SOURCE The issue with expand/collapse in the hierarchical fields with the specified active level was fixed.
  • FIX CUSTOM API DATA SOURCE The issue with blank cells when several hierarchies are drilled down was fixed.
  • FIX CUSTOM API DATA SOURCE Handling of the wrong path to the data source was improved.
  • FIX CUSTOM API DATA SOURCE More convenient way to define filters for the specific field was added.

New in Flexmonster Pivot Table & Charts component 2.8.23 (Dec 29, 2020)

  • NEW A new folder property was added to the mapping for "json", "csv", and "api" data source types.
  • NEW A new "expandExecutionTimeout" property was added to the Options Object. It allows defining timeout value for the expandAll operation.
  • NEW A new readOnly property was added to the Options Object. It allows enabling the read-only mode.
  • FIX The issue with the calculated measures not working properly when several report filters are set was fixed.
  • FIX The issue with the "Add calculated value" button was fixed.
  • FIX The issue with the formulas validation was fixed.
  • FIX The issue with specific dates in AEDT timezone was fixed.
  • FIX When dragging fields in the Field List, the items are now scrolled to the first/last position if needed.
  • FIX The issue with scrolling nested members in the filter view was fixed.
  • FIX For Angular, the issue with setting [height]="''100%'" was fixed.
  • FIX Several style improvements were made for mobile devices (CSS).
  • FIX Highcharts connector The issue with the axis label not changing on drill-down was fixed.
  • FIX Flexmonster CLI Now the update command always updates to the latest version.
  • DEPRECATED dimensionUniqueName and dimensionCaption properties were deprecated. Now the folder property from the mapping should be used.

New in Flexmonster Pivot Table & Charts component 2.8.22 (Dec 15, 2020)

  • NEW In the number formatting view now it’s possible to choose several measures for formatting.
  • FIX Calculation of average, standard deviation, percent, and percent of difference aggregations for an empty set were adjusted to return appropriate values (0 or empty).
  • FIX The issue with setting properties for SSAS through the global object was fixed.
  • FIX The issue with saving calculated values to mapping was fixed.
  • FIX The issue with setFormat() for all values was fixed.
  • FIX The issue with incorrect cell redraw after expands was fixed.
  • FIX In the filter view, the performance of excluding members via search was optimized.
  • FIX The issue with deselecting hierarchy with levels from the flat view for a specific slice was fixed.
  • FIX Flexmonster Data Server The issue with requests when setting the CacheSizeLimit property to 0 was fixed.
  • FIX Custom API data source The issue with incorrect value filters in drill-through requests was fixed.
  • FIX Flexmonster Data Server/Custom API data source The exception when loading multiple pages of expanded data was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.21 (Dec 1, 2020)

  • NEW New useCaptionsInCalculatedValueEditor option property was added. By default, Flexmonster uses the field unique names in the calculated value editor. If useCaptionsInCalculatedValueEditor is set to true, the component will use the field’s caption instead of the unique name. The default value is false.
  • NEW Now the recordId property is available for frozen cells.
  • NEW Now it is possible to resize the Field List vertically to fill the entire height of the grid container.
  • NEW The sample Flexmonster & Angular integration project was updated to Angular 11.
  • FIX The issue with page scrolling when closing the context menu was fixed.
  • FIX The issue with unnecessary measures saved with showAggregationLabels: false was fixed.
  • FIX The issue with the updateData() API call and multiple update and delete calls was fixed.
  • FIX For Angular integration, exportstart, exportcomplete, printstart, and printcomplete events were added.
  • FIX Icon alignment for chart legend toggle button was fixed.
  • FIX Flexmonster Data Server Now an error message will be displayed if the config is not valid.
  • FIX CUSTOM API DATA SOURCE The issue with the incorrect filter parameter in the request with hierarchical fields was fixed.
  • FIX CUSTOM API DATA SOURCE The issue with the drill-through view when using reportFilters was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.20 (Nov 17, 2020)

  • NEW Now withCredentials property is also supported for CSV, JSON, and Elasticsearch data sources.
  • FIX The issue with exporting undefined cells to Excel was fixed.
  • FIX The issue with expanding hierarchies when showEmptyValuesoption is enabled was fixed.
  • FIX For IE11, the issue with export to image and PDF was fixed.
  • FIX The issue with detecting numeric fields in JSON when the first value entry equals 0 was fixed.
  • FIX In the classic form, the issue with row header sizing was fixed.
  • FIX The Measure interface in the type definitions file was updated to provide the correct measure structure.
  • FIX custom API data source distinguishNullUndefinedEmpty option now affects the date type. If set to true, null date members will be shown instead of "Invalid date" label.
  • FIX custom API data source The issue with using reportFilters in the flat form was fixed.
  • FIX Mongo Connector The issue with parsing null fields was fixed.
  • FIX Flexmonster Data Server Performance of executing include/exclude filters was optimized.

New in Flexmonster Pivot Table & Charts component 2.8.19 (Nov 2, 2020)

  • New methods getTableSizes() and setTableSizes() were added to dynamically apply specific grid sizes if needed.
  • SSAS Accelerator If a measure or hierarchy contains a description in the cube, it will appear in the Field List on the field’s tooltip.
  • SSAS Accelerator The issue with displaying nested folders in the Field List was fixed.
  • The issue with the Field List disappearing (fieldListPosition: "right") after moving a field was fixed.
  • The issue with openCalculatedValueEditor() API call was fixed.
  • The issue with pop-up windows positioning was fixed.
  • The issue with drawing auto calculation bar was fixed.
  • The issue with expanding data using API calls was fixed.
  • The issue with the reportchange event not being triggered when changing sorting in the flat form was fixed.
  • MAX and MIN formulas’ UI representation was improved.
  • The issue with the fields named “length” was fixed.
  • CUSTOM API DATA SOURCE The issue with ignoring sorted: true in the members request was fixed.
  • CUSTOM API DATA SOURCE The issue with predefined drills in the report with a date hierarchy was fixed.
  • CUSTOM API DATA SOURCE The issue with the incorrect requests for the numeric filter was fixed.
  • Flexmonster CLI The issue with version caching was fixed. This is available in the 2.8.3 version of Flexmonster CLI.

New in Flexmonster Pivot Table & Charts component 2.8.18 (Oct 20, 2020)

  • NEW Accessibility: keyboard navigation and actions on the grid were improved.
  • NEW For the classic form, an option to hide subtotals for specific hierarchies via context menu was added.
  • NEW The sorting functionality was enabled for calculated measures in the flat form.
  • NEW A new connector for amCharts was added (check out the integration guide).
  • NEW flexmonster.d.ts The type definitions file was extended with API for integration with amCharts.
  • FIX The issue with switching to the flat form was fixed.
  • FIX The issue with sorting when using the slice parameter for getData() API call was fixed.
  • FIX The issue with formula checker was fixed.
  • FIX The issue with expandData() method was fixed.
  • FIX The issue with scrollbars missing when rendered in a hidden tab was fixed.
  • FIX Now a multi-level hierarchy cannot be dragged to the Measures area in the Field List.
  • FIX Now the drill-through view is closed when a new report is loaded.
  • FIX SSAS The issue with measure columns mismatch was fixed.
  • FIX SSAS The issue with loading the reports was fixed.
  • FIX SSAS The issue with hidden measures was fixed.
  • FIX custom API data source The issue with the drill through for hierarchies having more than 4 levels was fixed.
  • FIX custom API data source The issue with the distinguishNullUndefinedEmpty option in filters was fixed.
  • FIX custom API data source The issue with wrong values in the /members request for numeric hierarchies was fixed.
  • FIX custom API data source Visual filters are now set accordingly to the level’s type.
  • FIX custom API data source The issue with multi-level hierarchies and folders in the Field List was fixed.
  • FIX custom API data source The issue with include/exclude filter in the multi-level hierarchies was fixed.
  • FIX custom API data source The issue with incomplete responses when the drillAll option is turned on was fixed.
  • FIX custom API data source The drill-through view for grand totals is updated automatically when the updateData is

New in Flexmonster Pivot Table & Charts component 2.8.17 (Oct 19, 2020)

  • New Now requestHeaders are supported for load() and save() API calls.
  • NEW Now label filters are also supported for Elasticsearch data source. The feature is supported for string, numeric, and date field types.
  • NEW For SSAS Accelerator, an event unauthorizederror was added. It can be used to refresh the authorization headers. Read more in the documentation.
  • FIX The issue with a corrupted Excel file when using special characters in the worksheet’s name was fixed.
  • FIX The issue with report filters ignored when using the custom API data source was fixed.
  • FIX The issue with CSV header parsing when using specific date values in Firefox was fixed.
  • FIX The issue with resizing the window after the component disposal was fixed.
  • FIX Several issues for predefined themes (CSS) were fixed.
  • FIX The bug with an empty cell when expanding in the classic form was fixed.
  • FIX The issue with the order of the keys entries’ fields in the custom API data source was fixed.
  • FIX The issue with the empty grid for fast CPUs was fixed.
  • FIX The issue with the unnecessary data request when clicking on the measure in the drill-through view was fixed.
  • FIX Flexmonster Data Server The issue with /members request for number hierarchies was fixed.
  • FIX Flexmonster Data Server The issue with some value filters for string members was fixed.
  • FIX The issue with unselecting the member when expanding in the filter view was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.16 (Sep 21, 2020)

  • NEW Accessibility: moving of focus via keyboard was improved inside the filter view. Note: use a special Accessible theme (CSS) for a better experience.
  • NEW Accessibility: duplicate ID attributes were replaced with corresponding class names to improve user experience with assistive technologies (screen readers, etc.).
  • NEW Flexmonster Data Server Ability to set parameters in config was added.
  • FIX The issue with filters property for a specific field in the /fields request was fixed.
  • FIX The issue with expands when showEmptyValues: true option and id type are used was fixed.
  • FIX The issue with opening number formatting window with preselected measure via context menu was fixed.
  • FIX The exception when clicking on the fields in the Field List was fixed.
  • FIX The issue with scroll jumping in the lists (e.g., for the Field List and Calculated Value pop-up windows) was fixed.
  • FIX The issue with showing “Infinity%” in the preloader when loading JSON files was fixed.
  • FIX The visual issue on the column line chart was fixed.
  • FIX The issue with page freezing when the addCalculatedMeasure() API call is called several times in a row was fixed.
  • FIX The issue with key combination Shift + arrow keys when the cell is selected was fixed.
  • FIX The issue with the measure’s caption from getAllMeasures() API call in the flat form was fixed.
  • FIX The issue with the newline character and CSV export was fixed.
  • FIX The issue with calculated values grand total not updated after the caption change was fixed.
  • FIX CSV The issue with parsing a multi-level hierarchy and empty values in the hierarchical structure was fixed.
  • FIX Elasticsearch The issue with composing request URL with headers was fixed.
  • FIX flexmonster.d.ts The Slice interface in flexmonster.d.ts type definitions was updated to provide the correct fields & measures structure.
  • FIX flexmonster.d.ts The ContextMenuItem.id property was added to the interface in flexmonster.d.ts type definitions.

New in Flexmonster Pivot Table & Charts component 2.8.15 (Sep 8, 2020)

  • NEW:
  • Accessibility: drag and drop actions were made accessible for the Field List and Calculated Values pop-up.
  • id was added for each item in the menu for better identification in customizeContextMenu.
  • FIX:
  • The issue with an empty error message when creating a calculated value with empty formula was fixed.
  • The bug when loading a single record from the remote JSON file was fixed.
  • Support for the licenseFilePath property was added to the Vue and Angular wrappers.
  • The licenseFilePath property was added to the TypeScript definitions.
  • The issue with buttons’ icon alignment (CSS) for fieldListPosition: 'right' was fixed.
  • Several CSS improvements were added for UI buttons.
  • The issue with the HTML string template in the react-native-flexmonster module was fixed.
  • The issue with unsupported date types in custom API data source was fixed.
  • The issue with the “Multiple values” checkbox in the charts dropdown was fixed.
  • MongoDB Connector The issue when loading slice with empty measures was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.14 (Aug 26, 2020)

  • NEW:
  • Accessibility: moving focus inside pop-ups via keyboard was improved. Note: use a special Accessible theme (CSS) for a better experience.
  • Now the Ctrl + C command also copies the cell’s data changed by customizedCell.
  • For JSON, an experimental stream loader was added for the optimized loading of large files. Available only for loading files via URL. To enable the stream loader, use dataSource.useStreamLoader: true in the report options.
  • NEW Flexmonster Data Server:
  • A new configuration property ThousandSeparator for CSV files was added.
  • FIX Flexmonster Data Server:
  • Garbage collection after data reloading was optimized.
  • FIX:
  • For the custom data source API, data loading speed when using expandAll() was optimized.
  • The issue with showing the scrollbar on mobile devices was fixed.
  • The issue with pre-loader pop-up was fixed.
  • The issue when getReport() returns null after the reportchange event was fixed.
  • For the custom data source API and Flexmonster Data Server, the issue with calculated values when a row is expanded was fixed.
  • For the custom data source API and Flexmonster Data Server, the issue with calculated values that use other calculated values inside was fixed.
  • The issue with opening the Field List when the empty data is received was fixed.
  • The issue when the row of data is not removed from the drill-through view after updateData() was fixed.
  • Several improvements for the Accessible theme (CSS) were added.

New in Flexmonster Pivot Table & Charts component 2.8.13 (Aug 11, 2020)

  • A new accessible theme was added. This theme is compliant with High Contrast modes.
  • NEW:
  • Flexmonster Data Server Security headers such as strict-transport-security,x-content-type-options,x-frame-options,x-xss-protection,x-content-security-policy now can be configured to add them to the responses.
  • FIX:
  • The overwriting issue with empty filters in a slice for third-party charts integration was fixed.
  • In ES5 version (for IE11), the issue with overriding theUint16Array.slice function was fixed.
  • The issue with sorting values by column when differenceofrow aggregation is used was fixed.
  • The issue with calculating runningtotalsofrow and runningtotalsofcolumn aggregation with nonexistent values was fixed.
  • The issue with unselecting fields in the Field List when using drag and drop was fixed.
  • The issue with "filters" mapping property not applied to date, year/month/day, year/quarter/month/day data types was fixed.
  • The issue with inconsistent behavior of drag and drop feature for calculated measures was fixed.
  • The issue with running setReport() before the 'reportcomplete' event was fixed.
  • The issue with empty "dateInvalidCaption" was fixed.
  • The issue with selection styling in the filter pop-up window was fixed.
  • The issue with flexmonster.d.ts was fixed.
  • Flexmonster Data Server Logging process was optimized.

New in Flexmonster Pivot Table & Charts component 2.8.12 (Jul 27, 2020)

  • NEW Accessibility: navigation via keyboard and focus indication on the grid were improved. Please use experimental accessibility: true option in the Flexmonster constructor to be able to see the focused items.
  • NEW Accessibility: Now when there is not enough space for the Toolbar tabs, the Toolbar becomes scrollable.
  • NEW Accessibility: The accessibility for the Field List was improved. Please use experimental accessibility: true option in the Flexmonster constructor to be able to see the focused items.
  • NEW New text align "center" option was added to the number formatting pop-up window.
  • FIX Flexmonster Data Server The issue with processing numeric data from CSV data source in the /members request was fixed.
  • FIX The issue with licenseFilePath property not applied when using Flexmonster with framework wrappers was fixed.
  • FIX The issue with autoCalculationBar not properly resizing was fixed.
  • FIX The issue with error when entering the drill-through pop-up window was fixed.
  • FIX The issue with deselecting multiple measures was fixed.
  • FIX The issue with Uint16Array.slice not defined was fixed.
  • FIX The "ctrl + A" combination execution was improved. Now it allows selecting all the data from the grid.
  • FIX The issue when selecting cells in the drill-through pop-up window was fixed.
  • FIX The issue with drilling down hierarchy levels when the showEmptyValues option is set as true was fixed.
  • FIX The issue with a missing calculated value in the report object when referenced from another calculated value was fixed.
  • FIX The issue with sorting year/quarter/month/day and year/month/day dates on the flat table was fixed.
  • FIX The issue with calculating differenceofrow and differenceofcolumn aggregation between existent and nonexistent values was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.11 (Jul 13, 2020)

  • NEW Accessibility: navigating through the Toolbar tabs using the keyboard was introduced. Please use experimental accessibility: true option in the Flexmonster constructor to be able to see the focused items.
  • NEW Accessibility: now when there is not enough space for the Toolbar tabs, the Toolbar becomes scrollable.
  • NEW Now the "id" property is also supported for hierarchical structure data in the custom API data source.
  • FIX The issue with the exception when adding conditional formatting in the flat form for the custom API data source was fixed.
  • FIX The issue with applying conditional formatting on non-numeric data in the flat form was fixed.
  • FIX The issue with copying from the grid was fixed.
  • FIX The issue with dispatching the reportchange event before actual changes in the Field List was fixed.
  • FIX For Elasticsearch, the issue with adding odd slash into the node URL was fixed.
  • FIX For Elasticsearch, the issue with adding custom request headers was fixed.
  • FIX The issue with displaying and selecting measures in the flat form was fixed.
  • FIX The issue with removing a measure from the slice using the context menu was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.10 (Jun 30, 2020)

  • NEW The following CSS themes for Flexmonster Pivot were introduced: “Striped-Blue”, “Striped-Teal”, “Purple”, “Black-Orange”, “Bright-Orange”, “Yellow”, “Green”, “Midnight”, “Mac-OS”, and “Soft-Default”. Check out the new color schemes in the Themes demo.
  • NEW The following localization files are now available for use: German, Turkish, and Dutch. Also, the Chinese localization was updated.
  • FIX When grand totals are disabled, and no fields are selected for rows or columns, grand totals are still shown.
  • FIX The issue with the header column being counted in the auto calculation bar in the drill-through view was fixed.
  • FIX The exceptions when using the Field List were fixed.
  • FIX The collapsed, expanded, drilledUp, drilledDown, and negativeNumberFormat properties were added to the TypeScript definitions.
  • FIX The issue with rendering the wrong scrollbar size on the grid with customized scrollbar styles was fixed.
  • FIX The issue when the Field List on the right does not expand in fullscreen mode was fixed.
  • FIX The issue with editing calculated values via UI was fixed.
  • FIX The issue with duplication of multilevel hierarchies in the drill-through view was fixed.
  • FIX The issue with applying localization to the Toolbar was fixed.
  • FIX The issue with the drop-down selection in chart mode was fixed.
  • FIX The issue with getReport() after partial updateData() was fixed.
  • FIX The issue with exporting dates to Excel was fixed.
  • FIX The issue when adding measures with different aggregations to a slice was fixed.
  • FIX The issue with running updateData() with the empty pivot table was fixed.
  • FIX The issue with de-selecting levels in the Field List was fixed.
  • FIX The issue with an empty interval property in the /select request was fixed.
  • FIX Elasticsearch The issue with freezing when dragging a field to another position was fixed.
  • FIX SSAS The issue with setting “No calculation” was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.9 (Jun 30, 2020)

  • NEW An ability to use showEmptyValues separately by rows and columns was added
  • NEW flexmonster.js was migrated to ES6 JavaScript standard to utilize modern browsers’ features. Note: IE11 users should stay on old ES5 build (flexmonster.es5.js)
  • NEW Flexmonster Data Server A new configuration property DecimalSeparator was added for csv files
  • NEW Flexmonster Data Server A new configuration property CacheSizeLimit for caching responses was added
  • FIX Flexmonster Data Server The issue with loading big datasets from databases was fixed
  • FIX The issue with filtering when showEmptyValues is enabled was fixed
  • FIX The exception when the calculated value formula calls itself recursively was fixed
  • FIX The “Promise is undefined” exception when using IE11 and RequireJS was fixed
  • FIX The issue with overwriting filters in a slice for third-party charts integration was fixed
  • FIX The issue with formatting (decimalPlaces/maxDecimalPlaces) not being applied to large numbers in exponential notation was fixed. Note: min decimal places for e-notation numbers is 1
  • FIX For the custom data source API, the issue with skipping the folder property from a response to a /fields request was fixed
  • FIX For the custom data source API, the exception when the "distinctcount" aggregation of a string data type field is used in a calculated value was fixed
  • FIX The exception with expanding rows in the Custom API was fixed
  • FIX The issue with the empty column in the drill-through view using the custom data source API was fixed
  • FIX Now "% of Parent Column Total" and "% of Parent Row Total" aggregations work correctly in calculated values
  • FIX The issue with switching between the flat form and charts was fixed
  • FIX The issue with the inactive Apply button in the flat form Field List was fixed
  • FIX The issue with parsing dimensional data with dates was fixed
  • FIX The issue with exporting to Excel was fixed
  • FIX The exception when removing a field from the flat form was fixed
  • FIX The issue with the flat form when using custom data source API and hierarchies with multiple levels was fixed
  • FIX For SSAS, the issue when the same measure is used in a report several times with different aggregations was fixed
  • FIX React Native The issue with the component not resizing when the orientation is changed was fixed
  • FIX TypeScript definitions The following properties were added: rightGroup, fieldListPosition, the measure property in type ConditionalFormat, the sort property in type Hierarchy

New in Flexmonster Pivot Table & Charts component 2.8.8 (Jun 1, 2020)

  • NEW The mapping property now allows loading mapping from the remote source.
  • NEW The new hook customizeChartElement to apply customizations for charts was added.
  • NEW For CSV export, the new option alwaysEnclose was added to enclose all fields in quotes.
  • FIX For Elasticsearch, the issue with incorrect aggregations for non-numeric fields was fixed.
  • FIX The issue with formatting (decimalSeparator) not being applied to large numbers in exponential notation was fixed.
  • FIX The issue with report filters not re-positioning by drag and drop to the last position was fixed.
  • FIX For custom data source API, the issue with extra values (if sent in the response) overwriting values on the grid was fixed.
  • FIX The issue with multiple columns having running totals aggregation was fixed.
  • FIX The issue when hidden fields in mapping broke reports for CSV data source was fixed.
  • FIX The issue with data loading ticker was fixed.
  • FIX The issue with loading empty data was fixed.
  • FIX The issue when non-empty availableAggregations array for SSAS data source KPIs was returned by getMeasures() was fixed.
  • FIX The issue when availableAggregations array for SSAS data source KPIs was saved in the report or returned by getReport() was fixed.
  • FIX The exception when a conditional formatting rule is applied on top of several measures one of which has a 'differenceofrow' aggregation applied was fixed.
  • FIX If a measure is not selected for a slice and if its aggregation property is the only that differs from the default one, this measure is not being saved to the report.
  • FIX The issue with the active levels in hierarchies for custom data source API was fixed.
  • FIX Flexmonster Data Server The issue with count aggregation on data with empty values was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.7 (May 18, 2020)

  • NEW The “Difference” aggregation "difference" is split into two different aggregations: “Difference of Column” "differenceofcolumn" and “Difference of Row” "differenceofrow"
  • NEW The “% Difference” aggregation "%difference" is split into two different aggregations: “% Difference of Column” "%differenceofcolumn" and “% Difference of Row” "%differenceofrow"
  • NEW The “Running Totals” aggregation "runningtotals" is split into two different aggregations: “Running Totals of Column” "runningtotalsofcolumn" and “Running Totals of Row” "runningtotalsofrow"
  • NEW The following aggregations were introduced for the string data type in JSON and CSV data sources
  • "percent"
  • "percentofcolumn"
  • "percentofrow"
  • "percentofparentcolumntotal"
  • "percentofparentrowtotal"
  • "index"
  • "differenceofcolumn"
  • "differenceofrow"
  • "%differenceofcolumn"
  • "%differenceofrow"
  • "runningtotalsofcolumn"
  • "runningtotalsofrow"
  • NEW A new "negativeNumberFormat" property was added to the Format Object
  • NEW A new option distinguishNullUndefinedEmpty was added to separate empty values from null and undefined
  • NEW Now the flat view shows all levels with year/month/day and year/quarter/month/day date types
  • NEW Flexmonster Data Server Now basic Flexmonster Data Server functionality is available as a DLL at NuGet
  • NEW Flexmonster Data Server New properties for HTTPS configuration were added
  • FIX The sorting issue with hierarchies that have numeric levels was fixed
  • FIX custom data source API The exception when only one level of a hierarchy is active was fixed
  • FIX custom data source API The issue with expanding hierarchies was fixed
  • FIX custom data source API The issue while reading year and month types of levels was fixed
  • FIX custom data source API The issue with missed measures in the calculated values was fixed
  • FIX custom data source API Support of id‘s instead of names for members was restored
  • FIX custom data source API The incorrect saving of the mapping object to the report after switching between compact, classic, and flat tables was fixed
  • FIX Flexmonster Data Server The issue with nulls in the first JSON object was fixed
  • FIX The issue with the blank column in the drill-through view was fixed
  • FIX The issue with saving inactive calculated values to the Report Object was fixed
  • FIX Mapping for CSV is now applied by column names instead of column indexes
  • FIX Mapping for CSV is now applied on top of the default structure (so it does not require to enumerate all fields)
  • FIX The option for hiding subtotals on rows was improved for the compact view (empty rows are hidden)

New in Flexmonster Pivot Table & Charts component 2.8.6 (May 5, 2020)

  • NEW The following front-end built-in aggregations were introduced for the custom data source API:
  • "percent"
  • "percentofcolumn"
  • "percentofrow"
  • "percentofparentcolumntotal"
  • "percentofparentrowtotal"
  • "index"
  • "difference"
  • "%difference"
  • "runningtotals"
  • They will appear automatically for numeric fields if at least one aggregation is supported on the back end, for example, "sum".
  • NEW The "runningtotals" aggregation was introduced for SSAS and Mondrian data sources.
  • NEW A new "filters" mapping property was added.
  • NEW Flexmonster Data Server Now Flexmonster Data Server can be run on HTTPS.
  • NEW Flexmonster Data Server Now Flexmonster Data Server supports last, current, and next date filters.
  • FIX The unused properties were removed from /select requests in the custom data source API.
  • FIX The error handling for the index data source property was improved for the custom data source API.
  • FIX The issue with inappropriate saving of availableAggregations to the report.slice was fixed.
  • FIX The options.grid.showEmptyValues option was moved to options.showEmptyValues.
  • FIX The issue with the numeric value filter not getting applied in the flat form was fixed.
  • FIX ‘Content-Type’ header was removed from the GET requests for loading data.
  • FIX The issue with expanding rows on the classic form was fixed.
  • FIX For custom data source API, the issue with hierarchies containing capital letters in level names was fixed.
  • FIX For custom data source API, the issue with converting the last, current, and next date filter queries to the between query was fixed.
  • FIX The issue with "requestHeaders" in custom data source API was fixed.
  • FIX The issue with the hierarchy’s caption was fixed.
  • FIX The issue with changing drill-through slice was fixed.
  • FIX The issue with "dimensionUniqueName" in the mapping object was fixed.
  • FIX Flexmonster Data Server The issue with null members was fixed.
  • FIX For custom data source API, the issue with unbalanced hierarchies was fixed.
  • FIX Now the nullValue property from the Format Object works for the string data types.

New in Flexmonster Pivot Table & Charts component 2.8.5 (Apr 21, 2020)

  • NEW Flexmonster Data Server is now available! It significantly reduces the time of data loading and enables analyzing large datasets (read docs).
  • NEW Multilevel hierarchies are now supported for the custom data source API.
  • NEW Advanced mapping features for the custom data source API and CSV were added.
  • NEW The dataSource.withCredentials property is now available for the custom API data source.
  • NEW Windows authorization is now supported for Accelerator.
  • FIX The issue with an odd decimal part for large integers was fixed.
  • FIX The issue with resetting captions after the updateData() API call was fixed.
  • FIX The issue with the date value filter was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.4 (Apr 6, 2020)

  • FIX The issue with incorrect analyzing data message was fixed.
  • FIX The default behavior of the rawData property was restored.
  • FIX The issue with resizing more than one Flexmonster instance was fixed.
  • FIX The issue with calling the dispose API call for more than one Flexmonster instance was fixed.
  • FIX ACCELERATOR SSAS The issue with blocking error when using an MDX measure was fixed.
  • FIX The issue with saving files (export, reports) when using Adobe Analytics was fixed.
  • FIX The exception when using invalid names in a formula for calculated values was fixed.
  • FIX Validating calculated values was improved to check all names.
  • FIX For SSAS XMLA connection the issue with duplicating requstHeaders for the first request was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.3 (Mar 24, 2020)

  • NEW The "withCredentials" property is now supported for the Flexmonster Accelerator.
  • FIX The issue with “instanceof Array” check in different frames was fixed.
  • FIX The issue with empty recordId in the drill-through pop-up window cell was fixed.
  • FIX The issue with exporting dates with timezones to Excel was fixed.
  • FIX For custom API data source, handling and sorting of empty numeric/date members were improved.
  • FIX Gear icon is now hidden in the flat form with grid.showFilter: false option.
  • FIX Loading empty CSV/JSON data was made consistent.
  • FIX The issue with the Ctrl+click for multi-column sorting on Linux/Ubuntu was fixed.
  • FIX The issue with the Ctrl+click for selecting multiple cells on Linux/Ubuntu was fixed.
  • FIX The issue with the overlapping of a filter icon in header cells on the flat table was fixed.
  • FIX The issue with missing sort icon for some measures in multi-column sorting mode was fixed.
  • FIX The issue with scrolling in the Field List on iOS 13 was fixed.
  • FIX The issue with the sigma icon visibility inside the calculated value editor was fixed. Now the sigma icons which are used to choose the aggregation are available for all items that have more than one aggregation available.
  • FIX The issue when a word (undefined) is displayed next to the formula name in the calculated values editor was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.2 (Mar 10, 2020)

  • NEW:
  • Multi-column sorting is now available for the flat table (use Ctrl + click to sort via UI).
  • New mapping property format is now available for JSON/CSV/Custom API data sources to apply date/time formatting for individual fields.
  • A new withCredentials property was added to the report.dataSource.
  • FIX:
  • SSAS The issue with the restoration of reports with multiple expanded and drilled down tuples was fixed.
  • MONGODB CONNECTOR The issue with the Decimal128 type was fixed.

New in Flexmonster Pivot Table & Charts component 2.8.1 (Feb 25, 2020)

  • NEW :
  • Localization files were added to the flexmonster NPM package.
  • FIX:
  • The issue with drawing the grid after resetting the column width was fixed.
  • The exception when loading JSON data with nulls was fixed.
  • The exception when clicking on the sigma icon inside the calculated value editor was fixed.
  • Elasticsearch The issue with showing dates in the drill-through view was fixed.
  • SSAS The exception with drill through after filtering was fixed.
  • The issue with incomplete removal of the calculated values in the updateData API call was fixed.
  • The issue with the drill-through header label for the date data cells was fixed.
  • The issue with export to the image was fixed.
  • The issue with customizeCell and export to Excel was fixed.
  • The issue with fieldSeparator not being saved to the report was fixed.
  • Export time for export to PDF with custom headers was improved.

New in Flexmonster Pivot Table & Charts component 2.8.0 (Feb 11, 2020)

  • NEW Now Flexmonster provides our own communication protocol called custom data source API. It is designed for summarized data retrieval from the server.
  • NEW New Flexmonster Connector for MongoDB provides an easy connection to the MongoDB database.
  • NEW A percentage of parent row/column total aggregation was added.
  • NEW Two new events were added: drillthroughopen and drillthroughclose.
  • NEW A new option property allowBrowsersCache was added.
  • NEW Now analyzing the JSON data process progress pop-up message is followed by the percent of analyzed data information.
  • FIX The issue when the default number formatting was not applied to measures that are not included in the slice was fixed.
  • FIX The Elasticsearch reports issue when measures were placed in columns instead of being placed in rows was fixed.
  • FIX The issue with duplicating some header cells in columns when subtotals are off was fixed.
  • FIX The exception when using conditional formatting with the showEmptyValues: true option was fixed.
  • FIX The issue with setting showEmptyValues option via the setOptions() method was fixed.
  • NEW New integrations:
  • Vue.js
  • R Shiny
  • Python (Django)
  • Python (Jupyter Notebook)

New in Flexmonster Pivot Table & Charts component 2.7.24 (Jan 28, 2020)

  • NEW Added headers and footers for CSV export.
  • NEW Added headers and footers for Excel export.
  • NEW Added headers and footers for Image export.
  • NEW ACCELERATOR SSAS An ability to define custom Impersonator when using Accelerator as DLL was added.
  • FIX The issue with the context menu when multiple cells are selected with showHeaders: false option was fixed.
  • FIX For Elasticsearch, the issue with showing non-numeric data in the drill-through view was fixed.
  • FIX The issue with the unexpected Date.parse() results was fixed.
  • FIX The issue with hidden columns on print was fixed.
  • FIX The issue with multiple value filters was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.23 (Jan 13, 2020)

  • NEW Now the right click selects a cell on the grid
  • NEW Now the area selection can be returned back to a single cell
  • NEW The option grid.showEmptyValues to show members with empty values on the grid was added (CSV/JSON/SQL only)
  • FIX The exception on the flat table when using the right-click menu on measures was fixed
  • FIX The issue when grid.showFilter option does not disable filtering options in the context menu was fixed
  • FIX The usage of quotes in CSV export was optimized

New in Flexmonster Pivot Table & Charts component 2.7.22 (Jan 13, 2020)

  • FIX The issue with aggregations in the context menu for KPIs from Microsoft Analysis Services was fixed.
  • FIX The issue with callbacks in the exportTo API call was fixed.
  • FIX customizeContextMenu is now available on empty cells as well.
  • FIX The exception when using the inactive measure in values filter was fixed.
  • FIX The issue with members filter behavior was fixed.
  • FIX The inconsistency between line charts and bar charts when displaying members with infinity values was fixed.
  • FIX The inconsistency in textAlign format when formatting "date string" in the flat form was fixed.
  • FIX The issue with "requestHeaders" not applied when using updateData() was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.21 (Dec 16, 2019)

  • NEW For the flat form, it is now possible to refer to other measures when defining the conditional formatting rules.
  • FIX Several UI issues when using Flexmonster inside Shadow DOM were fixed.
  • FIX Styles for the disabled checkbox “Multiple values” were fixed.
  • FIX The issue with expands not being applied when the field’s uniqueName starts with a number was fixed.
  • FIX The issue with exporting time data to Excel was fixed.
  • FIX The issue with loading CSV data when gzip is enabled in Firefox was fixed.
  • FIX The issue with representing numbers with wrong mantissa was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.20 (Dec 3, 2019)

  • NEW For SSAS and Mondrian, setting custom labels for hierarchies and measures is now supported via mapping.
  • FIX XSS (Cross-site scripting) prevention was improved.
  • FIX The issue with columns auto-size for specific data sets was fixed.
  • FIX Data Compressor The issue with a single quote in the latest Data Compressor was fixed.
  • FIX The issue with parsing CSV data with quotes was fixed.
  • FIX The issue when using uniqueNames with brackets was fixed.
  • FIX The issue with filtering and distinct formula calculation was fixed.
  • FIX The exception which was thrown on the wrong parent name in the mapping was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.19 (Nov 19, 2019)

  • FIX:
  • The issue with incorrect measure caption when using the updateData API call was fixed.
  • The issue with charts when there is division by zero was fixed.
  • SSAS Selecting fields for the drill-through view based on the current slice was improved.
  • SSAS If none of the drill-through fields match the slice, all available fields will be selected instead of an empty view.
  • SSAS The issue with [ char before the field names for the drill-through view was fixed.
  • SSAS Measures grouping in the Field List was improved to match the server configuration better.
  • Added a new option includeEmptySubtotalsOLAP to the Options object. It helps to ensure that all data is loaded in the case when all elements but subtotals are empty.
  • The issue with calculated values removal via API was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.18 (Nov 5, 2019)

  • Fixes:
  • The issue with the field name getting changed after editing the calculated value was fixed.
  • The issue with disappearing headers after configuring the filter that returns empty result was fixed.
  • The issue with active measures on the pie chart when “Multiple Values” was previously selected was fixed.
  • The issue with sorting a great number of members was fixed.
  • The issue with beautifying numbers with a floating-point was fixed.
  • The issue with unavailable difference aggregation on the fully expanded view was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.17 (Oct 22, 2019)

  • NEW A new chartclick event was added to handle clicks on the chart’s view.
  • FIX The issue with sorting a filtered dimension was fixed.
  • FIX The issue with formatting when the isPercent option is not applied on charts was fixed.
  • FIX COMPRESSORS The issue with commas in the columns was fixed.
  • FIX COMPRESSORS The issue with converting date/time was fixed.
  • FIX JAVA COMPRESSOR com.flexmonster.compressor.readers.ColumnType was made a public enum.
  • FIX The issue with exporting grand total row when it is located at the bottom was fixed.
  • FIX The issue with skipping the last column when printing the flat table was fixed.
  • FIX The issue with reusing the same format for multiple measures was fixed.
  • FIX The issue with exporting grand total style was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.16 (Oct 7, 2019)

  • NEW:
  • Now if the data cell was changed with the customizeCell approach and the new value also has type number, it will be exported to Excel as a number.
  • Now the selected cell does not get deselected after the right click.
  • FIX:
  • The issue with closing the Field List on resize for empty grid was fixed.
  • The issue with the filter closing on resize in the grid_charts mode was fixed.
  • The issue with displaying small numbers was fixed.
  • The issue with incorrect properties information of the exported Excel document was fixed.
  • The issue with filtering the drill-through view for a particular data cell for SSAS was fixed.
  • The issue with loading different reports and using flat view mode was fixed.
  • The issue with incorrect default text align in Excel export was fixed.
  • The issue with the IF statement with the division by zero in the formula was fixed.
  • The issue with available Aggregations parameter for non-numeric fields was fixed.
  • The issue with exception when exporting specific conditional formatting to HTML was fixed.
  • The issue with rendering long data columns on the grid was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.15 (Sep 25, 2019)

  • FIX Setting custom sortOrder via runQuery() method is now supported.
  • FIX The issue with wrong totals in Elasticsearch was fixed.
  • FIX The issue with refreshing when deselecting one of the multiple measures with fieldListPosition: "right" was fixed.
  • FIX The issue with copying to the clipboard in IE 11 was fixed.
  • FIX The issue with loading CSV with thousandSeparator: "," and fieldSeparator: "," at the same time was fixed.
  • FIX The issue with defining different sets of colors for charts of different Flexmonster instances was fixed.
  • FIX The issue with the wrong text-align for string data in the flat view was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.14 (Sep 10, 2019)

  • NEW If chartsmultipleMeasures option is used on charts with one measure selected, the legend will be rendered to display column members instead of the single value
  • NEW Advanced filters are available for Analysis Services
  • NEW Meta objects now can be defined in the report Now object mapping is available in the dataSource object More information about meta objects can be found here: https://wwwflexmonstercom/doc/data-types-in-json/
  • NEW React functional component approach with hooks is now available in react-flexmonster
  • FIX The issue with closing filter in charts view during resize was fixed
  • FIX The issue with editing sorted calculated measures was fixed
  • FIX The issue with optimizing pre-defined filter type was fixed
  • FIX The issue with slow export from a flat table was fixed Now export works a few times faster
  • FIX The issue with cropped data labels on charts was fixed
  • FIX The issue with filterclose event getting fired at each updateData/refresh was fixed
  • FIX The issue with exceptions on touch devices in Chrome when dragging fields was fixed
  • FIX The issue with canceling data loading for OLAP cube was fixed
  • FIX The issue with expanding nodes in a legend on charts if showTotals: "off" or showTotals: "rows" was fixed

New in Flexmonster Pivot Table & Charts component 2.7.13 (Aug 27, 2019)

  • NEW Now column sorting in the drill-through pop-up window is available for SQL/CSV/JSON data sources.
  • NEW Now each report includes version property with the current version of Flexmonster and also creationDate property with the string ISO date which represents when the report was created.
  • NEW The dataSource.dataSourceType report property was renamed into dataSource.type. dataSource.dataSourceType is supported for backward compatibility.
  • FIX The issue with scrolling the grid by row and column headers on mobile devices was fixed.
  • FIX The issue with grid rendering when drilling up rows was fixed.
  • FIX The issue with duplicating measures after reordering columns in the flat table was fixed.
  • FIX The issue with undefined React.PropTypes was fixed.
  • FIX The issue with empty drill-through pop-up window cells for level data with empty levels was fixed.
  • FIX The issue with not dispatching reportchange event when the filter is cleared was fixed.
  • FIX The issue with exception “Mondrian gave exception while parsing query” when trying to drill through data was fixed.
  • FIX The check for external CSS files in Firefox was fixed.
  • FIX The issue with wrong direction of sorting arrows was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.12 (Aug 27, 2019)

  • NEW Now getAllHierarchies() API call returns a list of levels if they are available.
  • FIX The issue with applying grid fonts in the Excel export file was fixed.
  • FIX The issue with using collapseAllData() API call when the view is scrolled was fixed.
  • FIX The issue with saving the filter query to the report in the flat form was fixed.
  • FIX The issue with the refresh() API call increasing column width for specific zoom values was fixed.
  • FIX The issue with hierarchy and member properties for conditional formatting was fixed.
  • FIX The issue when a legend on charts is not shown if a slice contains more than one measure was fixed.
  • FIX The issue with empty columns for reports with difference aggregation was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.11 (Jul 30, 2019)

  • A new filter.liveSearch property was added to Options Object to control the search input in the filter pop-up window. Indicates whether the search is performed while the user types (true) or requires the Enter button to start searching (false). Default value: true.
  • NEW:
  • A new validateReportFiles property was added
  • to Options Object Indicates whether validation of report files is turned on (true) or turned off (false). Setting this value to false allows loading report files in the old format without error message. Should be used in global options. Default value: true.
  • Now when the user has unsaved formatting configuration Flexmonster will confirm before switching to another value.
  • The getData() signature was changed. Now callbackHandler and updateHandler get two input parameters: rawData and error. error is returned only for cases getData() API call gets terminated when it can possibly crash the web page.
  • FIX:
  • The issue with losing expandAll option after partial updating with updateData() was fixed.
  • The issue with not resorting optimized sorted members after calling updateData() was fixed.
  • The issue with resetting sorting after changing the slice was fixed.
  • The issue with cell formatting in IE was fixed.
  • The issue with not respecting active: true, when adding calculated values via addCalculatedMeasure() API call was fixed.
  • The UI for adding conditional formatting was improved.
  • The issue with enabling virtual scroll for a grid with lots of empty cells was fixed.
  • The issue with a hidden “0” member for Elasticsearch was fixed.
  • Sorting of numeric members for Elasticsearch was fixed.The issue with TOP/BOTTOM filters for numbers was fixed.
  • The issue with editing data in flat mode was fixed.
  • The issue with SSAS drill-through and filtered data was fixed.
  • Grand Total labels were removed for hierarchies with no all member.
  • Error handling for MDX queries was improved.
  • Now the filter pop-up window is being closed on the Apply button click even if no filtering was done.
  • The issue with the localization of the tooltips.fieldList tooltip label was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.10 (Jul 16, 2019)

  • NEW Now the context menu contains the following items: Move to Rows, Move to Columns, Move to Report Filters, Remove Field, Remove Measure, Filter by, Edit Formula.
  • NEW Now you can simplify nested fields in the Field List for Elasticsearch and SSAS data sources. A new simplifyFieldListFolders property was added to Options Object. Indicates whether the folders containing one field should show this field in the root (true) or not (false). Default value: false.
  • NEW Now getData() API call gets terminated with the error message in the callback when it can possibly crash the web page.
  • NEW Now React module for Flexmonster includes Typescript definition. It can be used with React + Typescript projects without any additional update.
  • NEW Now positive currency format and negative currency format fields are hidden in the formatting pop-up window when the currency symbol is not defined.
  • NEW More tooltips were added to the component’s UI. All new tooltip labels can be localized using the updated localization JSON files.
  • FIX The issue with rounding numbers when using maxDecimalPlaces was fixed.
  • FIX The issue with getData() returning double amount of data was fixed.
  • FIX The issue with Excel export failing in flat form was fixed.
  • FIX The issue with not saving active: false measures was fixed.
  • FIX The issue with setting & as null formatter was fixed.
  • FIX The issue with editing calculated values was fixed.
  • FIX The requestHeader parameter in the data source object was renamed into requestHeaders. requestHeader is supported for backward compatibility.
  • FIX The requestHeader export option was renamed into requestHeaders. requestHeader is supported for backward compatibility.
  • FIX The issue with export to PDF in Internet Explorer 11 was fixed.
  • FIX The issue with the fieldslistclose event getting fired all the time was fixed.
  • FIX The issue with unworking items from the context menu if there is no Toolbar was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.9 (Jul 2, 2019)

  • NEW Now you can open calculated values editor directly from the values box in the Field List.
  • NEW Now the context menu contains items for Number and Conditional formatting.
  • NEW A new openCalculatedValueEditor() API call was added. It allows opening calculated values pop-up window editor.
  • NEW Accelerator Now the Accelerator DLL file is signed with a Strong Name.
  • FIX The issue with the filterclose event was fixed.
  • FIX The API call clear was fixed for the XMLA data sources.
  • FIX The exception in the charts with showTotals: false was fixed.
  • FIX The issue with the inconsistent width of the header cells was fixed.
  • FIX The issue with using specific field names (e.g. “length”, “reverse”, etc) in Elasticsearch was fixed.
  • FIX The issue with Elasticsearch and charts when zeros are in rows was fixed.
  • FIX The issue with expanding/collapsing rows in Elasticsearch when all rows are expanded was fixed.
  • FIX The issue jsSHA is not defined when using Webpack was fixed.
  • FIX The issue with loading very small data with Firefox when gzip is enabled was fixed.
  • FIX The issue with showing “undefined” instead of (blank) was fixed.
  • FIX The issue with getData() and cross-referencing calculated values was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.8 (Jun 18, 2019)

  • NEW Pivot table for Kibana is released. Please install it using the following command.
  • For more details, refer to our official tutorial.
  • NEW Added two new localization labels: positive_currency_format and negative_currency_format. Get the updated localization on our GitHub.
  • FIX The issue with blank columns was fixed for the grid with showTotals turned off.
  • FIX API call updateData() was fixed for the case when partial property is true.
  • FIX The minor issue with non-empty response from getCell() API call with showTotals turned off was fixed.
  • FIX Analysis Services Invalid handshaking request to the server was fixed.
  • FIX The issue with exceptions while loading large JSON files with dozens of columns was fixed.
  • FIX The issue with disappearing spaces in the large JSON files was fixed.
  • FIX Add calculated value button is now visible with fieldListPosition:"right".
  • FIX Cell max width and max height is now 500px and 100px accordingly. It’s possible to override the default values using CSS classes .fm-grid-column/.fm-grid-row:
  • FIX The error elasticsearch is not defined in Webpack projects was fixed.
  • FIX The random issue with incorrect loading of CSV/JSON/OCSV data with slow network connection was fixed.
  • FIX DATA COMPRESSORS The issue with setting custom delimiter for compressing CSV files was fixed.
  • FIX The issue with the datachanged event not returning column’s uniqueName was fixed.
  • FIX Data Compressor for PHP The issue with recognizing numeric types from PostgreSQL was fixed.
  • FIX The sorting of measures in flat form is now stored to report.
  • FIX The issue with using getData() and calculated measure in slice was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.7 (Jun 4, 2019)

  • NEW Exporting the Unicode characters to PDF is now supported. It means that from now on you can save PDF reports in Chinese, Arabic or any other language without any problems. To do this, you only need to provide an appropriate TTF font file while using exportTo() API call. Also, we have prepared a list of ready-to-use Google Noto Fonts that you can use to support almost any language in the world. Please note, that only fonts in standard TTF format are supported. Example of usage:
  • flexmonster.exportTo('pdf', {
  • fontUrl: 'https://cdn.flexmonster.com/fonts/NotoSansCJKtc-Regular.ttf'
  • });
  • Check out an updated localization demo on JSFiddle.
  • NEW Compatibility with Elasticsearch 7.1 was improved.
  • NEW Custom request headers are now supported for Elasticsearch via dataSource.requestHeader property.
  • NEW A new label progressKnown was added. It is used to display the process of loading CSV/OCSV when the size of the data file is defined.
  • NEW Now it is possible to define uniqueName property in JSON meta object for an array of arrays.
  • NEW A new property caseSensitiveMembers was added to distinguish members with different cases.
  • FIX Added warning alert if loaded JSON report doesn’t contain required properties.
  • FIX The issue with grouping measures in the Field List when using strictDataTypes option was fixed.
  • FIX The issue with grid export to the image was fixed.
  • FIX Data Compressor The issue with compressing similar member names on different levels was fixed.
  • FIX The issue with appending compressed data was fixed.
  • FIX The issue with entering fullscreen mode when the component has fixed size was resolved.
  • FIX The issue with loading gziped data from the Data Compressor using the Mozilla Firefox browser was fixed.
  • FIX The issue with icons and react-flexmonster module was fixed.
  • FIX Analysis Services The issue with empty grand totals for hierarchies with no all member was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.6 (May 21, 2019)

  • NEW Added ability to add custom CSS class to the context menu items. Use new property items[].class inside customizeContextMenu.
  • FIX Responsive layout for the Toolbar icons was improved.
  • FIX The issue with multiple expands for Elasticsearch was fixed.
  • FIX The issue with searching members in the filter pop-up window in the SSAS data source was fixed.
  • FIX The issue with loading large JSON array of arrays was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.5 (May 7, 2019)

  • NEW Now the request headers are available for the XMLA connection.
  • FIX The issue with the text-align of header cells in Excel export was fixed.
  • FIX The issue with formatting percent values in charts, drill-through pop-up window, and auto calculation bar was fixed.
  • FIX Data Compressor for Java The issue with compressing numbers with comma as decimal separator in Java was fixed.
  • FIX The issue with combining query and exclude filters for multilevel hierarchies was fixed.
  • FIX The issue with drill-down and drill-up after loading report for CSV/JSON data sources was fixed.
  • FIX The issue with distinct count aggregation for hierarchies with multiple levels (e.g., year/month/day) was fixed.
  • FIX The issue with rounding numbers when formatting decimal places was fixed.
  • FIX The issue with popping-up the “Pivot cannot be drawn” alert message when a license key is not set for the component was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.4 (Apr 23, 2019)

  • NEW:
  • A new chart.axisShortNumberFormat property was added to Options Object. Indicates whether axes labels on charts are displayed in short number format like 10K, 10M, 10B, 10T (true) or not (false). Default value: undefined (show short format if max value > 10M).
  • A new validateFormulas property was added to Options Object. Indicates whether the validation will be performed for calculated values (true) or not (false). In case the validation is turned on and the report contains invalid formula, the “Wrong formula format” alert message is shown. To turn off the “Wrong formula format” alert message, set the validateFormulas property to false. Default value: true.
  • FIX:
  • The license info pop-up window was updated.
  • The issue with values filter when changing measure aggregation was fixed.
  • The issue with the AMD module for Flexmonster was fixed.
  • The issue with loading dependencies in React was fixed.
  • The issue with calculated values reordering was fixed.
  • The issue with the error in the classic form and unexpected “Too many columns in classic view…” pop-up window was fixed.
  • The issue with loading JSON data from the Toolbar when the data has only the meta object was fixed.
  • Data Compressor for Node.js The issue with compressing level data in the Data Compressor for Node.js was fixed.
  • The issue with moving and deselecting fields in the Field List was fixed.
  • The error when running setOptions() with empty input was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.3 (Apr 10, 2019)

  • NEW:
  • For Elasticsearch, min_doc_count mapping property is now available for date fields. To show intervals with empty values use min_doc_count: 0. Default value: 1 (empty intervals are hidden).
  • The searching feature is now available in the flat Field List.
  • A property showFieldListSearch was added to Options Object. When set as true, it enables searching feature in the Field List. If it is set as false, the searching feature is disabled and will be enabled automatically when the number of hierarchies in the list exceeds 50 for compact/classic view. For the flat Field List, it should exceed 40 fields. Default value of showFieldListSearch: false.
  • FIX:
  • The issue with nested fields in the Field List for Elasticsearch was fixed.
  • Dark and teal CSS themes were improved.
  • Now dateTimezoneOffset, datePattern or dateTimePattern options are used to detect filter time zone automatically.
  • The issue with converting dates to local time (showing a “day before” dates) was fixed.
  • The issue with loading reports with embedded OCSV data was fixed.
  • COMPRESSOR The issue with compressing empty streams in Node.js was fixed.
  • The issue with localization of “Export in progress…” pop-up window was fixed.
  • The issue with loading JSON data which only consists of meta object was fixed.
  • The error pop-up window when opening OLAP data source in flat view was fixed.
  • The issue with calculated values in the drill-through view was fixed.
  • The issue with autoCalculationBar feature in the drill-through view for OLAP was fixed.
  • The issue with exporting the last column twice in CSV export was fixed.
  • The issue with the odd row in HTML and CSV exports was fixed.
  • The number formatting issue when values are summarized by index aggregation was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.2 (Mar 26, 2019)

  • Resizing columns and rows is now supported for touch devices.
  • NEW Localization files were updated to support new labels.
  • NEW Now the timePattern option supports the HHH pattern to display time data where the number of hours is greater than 24.
  • NEW Now timePattern is used to format time values on charts as well as on the grid
  • NEW A negativeCurrencyFormat parameter is added to the list of number format parameters. It allows setting the following negative number formats: "-$1", "-1$", "$-1", "$1-", "1-$", "1$-", "($1)", "(1$)".
  • NEW A positiveCurrencyFormat parameter is added to the list of number format parameters. It allows setting the following number formats: "$1", "1$".
  • NEW Now when the measure is placed in measure’s part of slice its aggregation can be changed in flat view.
  • NEW Now the reportFilters are not exported when the showReportFiltersArea property is false.
  • FIX The issue with printing charts with custom headers was fixed.
  • FIX The issue with an exception on specific slice was fixed.
  • FIX The issue with filtering members that start with [ symbol was fixed.
  • FIX The issue with filtering members that start with the same char, but different case, was fixed.
  • FIX The issue with filtering members after updateData() was fixed.
  • FIX The issue with filtering by negative of floating numbers via UI was fixed.
  • FIX The issue with resetting grid scroll position and selection after setReport() was fixed.
  • FIX The issue with dragging fields to the last position in the flat form and the drill-through view was fixed.
  • FIX The issue with dragging calculated fields in the flat form was fixed.
  • FIX The issue with formatting ‘All values’ via Toolbar was fixed.
  • FIX The issue with “Empty” conditional formatting (isNaN/!isNaN) for SSAS, Mondrian and Elasticsearch was fixed.
  • FIX The time values export to Excel was improved.
  • FIX The negative time values display on the grid was improved.
  • FIX timePattern is used to format time values in the component if they are not aggregated by count, distinct count, index or any type of percent aggregations.
  • FIX The number formatting of values aggregated by count, distinct count, or any type of percent aggregations in the drill-through view and in the auto calculation bar was fixed.
  • FIX The number formatting of values aggregated by % difference aggregation in charts was fixed.
  • DEPRECATED The currencySymbolAlign format property is deprecated. Now, you need to use a combination of negativeCurrencyFormat and positiveCurrencyFormat

New in Flexmonster Pivot Table & Charts component 2.7.1 (Mar 11, 2019)

  • NEW:
  • Median aggregation was added for SQL/CSV/JSON data sources.
  • FIX:
  • Added elasticsearch.js to the bundled flexmonster.full.js (for Webpack integration).
  • The issue with removeSelection() API call was fixed.

New in Flexmonster Pivot Table & Charts component 2.7.0 (Mar 4, 2019)

  • NEW Brand new filtering feature. Now supports powerful filtering for the following data types:
  • Dates (for example, filter by date ranges)
  • Time
  • Strings
  • NEW Filtering by values is extended with a number of new conditions.
  • NEW Now supports connection to Elasticsearch data source out of the box.
  • NEW Fresh UI look & feel.
  • NEW Now, when the export to the server has failed, Flexmonster returns the error response to the callback. The error object consists of response, status and message properties.
  • NEW Now, dates with types date, year/month/day, year/quarter/month/day are parsed in the local (client’s) time zone. That makes all our date types consistent regarding the time zone in which they are parsed.
  • FIX SSAS FOR THE ACCELERATOR The issue with exporting to PDF, CSV, HTML was fixed.
  • FIX The issue with showing aggregations in the context menu when showAggregations is false was fixed.
  • FIX The issue with Toolbar labels with 90% zoom was fixed.

New in Flexmonster Pivot Table & Charts component 2.6.15 (Feb 26, 2019)

  • NEW:
  • Added ability to import numbers with a comma as a thousand separator from CSV files.
  • Flexmonster Accelerator for SSAS Now, when SSAS is used with Flexmonster Accelerator, the drill-through view displays only the properties which are available in the slice. Now, the Field List is also available for the drill-through view when using SSAS with Flexmonster Accelerator.
  • Flexmonster Accelerator for SSAS A new property showAllFieldsDrillThrough was added to options object. By default, it has value false which enables prefiltering the drill-through view columns when using SSAS with Flexmonster Accelerator. If set as true, the drill-through view will display all the available columns when using SSAS with Flexmonster Accelerator.
  • Now, datachanged event is triggered when the editing was finished by clicking outside Flexmonster’s container.
  • Now, it is possible to set the drillThrough slice property in the global object. That allows pre-configuring the default list of columns that will be shown in the drill-through view.
  • Now, the Excel formulas are also escaped when exporting to CSV.
  • FIX:
  • The issue with adding an unnecessary single quote to Excel export file was fixed.
  • The issue with the year/quarter/month/day type in the flat view was fixed.
  • The issue with long labels in the filter was fixed.
  • Message “No measures to display.” was updated to “No measures to display. Add at least one measure in the Field List.”. Also, it was added to localization files.
  • The issue with editing date string columns in the flat table was fixed.
  • The issue with showing the Field List button in the drill-through view was fixed.

New in Flexmonster Pivot Table & Charts component 2.6.14 (Feb 13, 2019)

  • NEW:
  • Now updateHandler of the getData() API call is triggered also when a number format is changed.
  • Filtering added to the drill through view.
  • Now, when the showHeaders option parameter is set with false, the column resizer is placed on the second row.
  • FIX:
  • The issue with filtering and grand total percent in the formula was fixed.
  • The issue with the max aggregation and negative values was fixed.
  • The issue with showing empty cells instead of zeroes for count aggregation was fixed.
  • The issue with resetting measure’s format when formatting with toolbar was fixed.
  • The issue with exporting to Excel when the starting layout is the chart’s layout was fixed.
  • The issue with opening filters in the flat table was fixed.
  • exportTo() method with destinationType: "plain" was improved to return result.data in the following types:
  • for HTML export: string
  • for CSV export: string
  • for Excel export: Uint8Array
  • for Image export: HTMLCanvasElement
  • for PDF export: jsPDF object

New in Flexmonster Pivot Table & Charts component 2.6.13 (Jan 29, 2019)

  • NEW Now, a requestHeader property is available as a part of export options property. It can be used for saving the export files on the server.
  • NEW Now, grandTotalCaption is also supported for calculated measures.
  • NEW A new toolbar property was added to Flexmonster API as a reference to the Toolbar instance to be able to call its functions on the page from outside of Flexmonster Pivot.
  • NEW Accelerator Now requestHeader is also available for the cube data sources such as Mondrian and SSAS (with Accelerators only).
  • FIX Progress message about loaded KB of CSV/OCSV/JSON files was fixed.
  • FIX The issue with scrolling with the key buttons was fixed.
  • FIX The issue with exporting “$0” strings to Excel in IE browser was fixed.
  • FIX Compressor The issue with TIME type was fixed.
  • FIX Accelerator SSAS Additional improvements for large data loading.

New in Flexmonster Pivot Table & Charts component 2.6.12 (Jan 15, 2019)

  • NEW:
  • A new option property dateTimezoneOffset was added. It allows setting the timezone for the following data types: "date", "year/month/day" and "year/quarter/month/day".
  • A new property useCustomizeCellForData was added for Excel export.
  • FIX:
  • The issue with "year/quarter/month/day" data type was fixed.
  • The issue with deselecting fields on the flat table when there are fields in the filters area was fixed.
  • The issue with fullscreen mode in Chrome and Firefox on macOS was fixed.
  • The issue with drag and drop fields on the flat table with a large number of columns was fixed.
  • The issue with drag and drop fields order was fixed.
  • An extra n when copying selected cells data was removed.
  • Accelerator SSAS The optimization for large data sets was made.

New in Flexmonster Pivot Table & Charts component 2.6.10 (Dec 18, 2018)

  • NEW:
  • Now it is possible to add a new field to the calculated formula by double-clicking it.
  • FIX:
  • The issue with exporting numeric data to Excel was fixed.
  • The issue with merging default and custom number formatting was fixed.
  • The issue with calculated values not added to Format cells drop-down in the Toolbar was fixed.
  • The issue with displaying an unnecessary pop-up warning for calculated measures was fixed.
  • The issue with the context menu for more than 20000 rows in the report was fixed.
  • The issue with filtering date/time members in SSAS was fixed.
  • The issue with undefined d3v3 when using Flexmonster in an Angular application was fixed.
  • FIX PHP DATA COMPRESSOR:
  • The issue with PHP Data Compressor when connecting to Oracle databases was fixed.

New in Flexmonster Pivot Table & Charts component 2.6.9 (Dec 4, 2018)

  • NEW:
  • Now the row height can be set via CSS.
  • New showLegend property was added to chart options. It indicates whether the legend is visible (true) or not (false) for the charts. Default value: true.
  • FIX:
  • clear() API call was improved to cancel OCSV data loading.
  • The possible conflict of the d3.js version used in Flexmonster and another d3.js version used in the project where Flexmonster is embedded was resolved.
  • Y-axis titles positioning was improved on charts.
  • L flag in dateTimePattern, timePattern and datePattern was ed. It is used to format milliseconds as a two digit number (rounded, if needed).
  • The CSV formula injection for the Excel export was disabled.
  • The issue with putting wrong field’s uniqueName in calculated measure formula was ed. Now the component shows the warning message for unexisting uniqueName.
  • The issue with printing many rows was ed.
  • The issue with the calculation of standard deviation aggregation for single value was ed.
  • The issue with showing the context menu in Edge and IE was ed.

New in Flexmonster Pivot Table & Charts component 2.6.8 (Nov 20, 2018)

  • NEW:
  • New filterclose event was added.
  • FIX:
  • The quality of charts export to PDF was improved.
  • The error that occurred when a report contained an expand for a node of an undefined hierarchy was fixed.The exception in the Toolbar was fixed.
  • The issue with the exception in calculated values with invalid formula was fixed.
  • The issue with the inconsistency for the CSV export was fixed.

New in Flexmonster Pivot Table & Charts component 2.6.7 (Nov 6, 2018)

  • NEW The error message from the response is now passed to the dataerror event.
  • NEW New API call openFilter() was added.
  • FIX The issue with printing in classic view was fixed.
  • FIX The issue with PDF export in the drill through was fixed.
  • FIX The issue with the autoCalculationBar on the empty grid was fixed.
  • FIX The TypeScript type definition for Flexmonster was updated.
  • FIX The error messages handling in Connect > To OLAP in the Toolbar was improved.

New in Flexmonster Pivot Table & Charts component 2.6.6 (Oct 23, 2018)

  • New:
  • New event afterchartdraw was added. It is triggered after chart rendering.
  • The new react-flexmonster npm module for integration with React was added. Check out.
  • Case-insensitive filters for SSAS.
  • Fix:
  • The issue with calculations when setting "none" aggregation was fixed.
  • The issue with headers PDF export when the webpage background color is different from white was fixed.
  • The issue with dispatching reportchange event was fixed.
  • The issue when the top X filter (the measure) from the report was not displayed correctly in the filter pop-up was fixed.
  • The issue when the member properties (SSAS, Mondrian) disappear from the grid when the slice is changed from UI using the Field List was fixed.
  • Improve:
  • Performance improvements for the Accelerator for Mondrian.

New in Flexmonster Pivot Table & Charts component 2.6.5 (Oct 9, 2018)

  • New alert() API call was added to show an error message.
  • NEW Report filters export is now available for HTML, CSV, and PDF exports.
  • FIX The issue with exporting to HTML when customizeCell is used was fixed.
  • FIX The issue with dividing by NaN was fixed.
  • FIX The issue with parsing JSON data was fixed.
  • FIX getFilter() and getFilterProperties() API calls now return member properties within member objects.
  • FIX The browser’s memory usage when reading OCSV stream was improved.
  • FIX The issue when the data is not reverting to unsorted in the flat table, when AZ or ZA sorting button is unchecked in the filter, was fixed.
  • FIX The issue when a calculated value created via UI was not added to the slice in the pivot table based on a local CSV file was fixed.
  • FIX The issue with a long loading of data subsets in Mondrian was fixed.
  • FIX The performance when loading JSON or CSV data was improved.

New in Flexmonster Pivot Table & Charts component 2.6.4 (Sep 25, 2018)

  • New:
  • New export option property "pageFormat" was added. It allows setting page format for PDF export. Default value: "a4"
  • The ability to hide entire row/column by setting its size in tableSizes to 0 was added.
  • 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
  • Fixes:
  • The issue with cropped labels in the report filters was fixed.
  • Integrations with Angular, React, TypeScript were updated.
  • The issue with JSON partial updates was fixed.
  • The issue with a calculated value that uses difference or %difference aggregation and is in the first position among measures was fixed.
  • The issue with editing and saving the calculated values was fixed.
  • The issue with sorting in levels was fixed.

New in Flexmonster Pivot Table & Charts component 2.6.3 (Sep 11, 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());
  • Now Accelerator DLL is available as a NuGet package.
  • New export option property "pageFormat" was added. It allows setting page format for PDF export. The default value is "a4".
  • The "fieldSeparator" property is now available for the CSV export.
  • FIX:
  • The issue with exporting customized cells to Excel was fixed.
  • 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.
  • The node expansion and drill-down issues when a measure was selected several times for the report based on OLAP data source were fixed.
  • The display of redundant sorting arrows in columns or in rows of the pivot table was fixed.
  • The display of several sorting arrows in columns of the pivot table, when one measure is selected with different aggregations, was fixed.
  • The incorrect positioning of data labels (chart option showDataLabels: true) for bars with negative values on the bar chart was fixed.
  • The issue with using difference, %difference, runningtotals aggregations in the calculated values was fixed.
  • 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.
  • The issue with the Data Compressor for PHP was fixed.

New in Flexmonster Pivot Table & Charts component 2.6.2 (Aug 28, 2018)

  • NEW Now it’s possible to associate JSON field with another column (set member property).
  • 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.

New in Flexmonster Pivot Table & Charts component 2.6.1 (Aug 14, 2018)

  • NEW:
  • New property "timePattern" was added. It allows formatting of time fields. 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.
  • 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 fields 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 in Flexmonster Pivot Table & Charts component 2.6.0 (Jul 31, 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.

New in Flexmonster Pivot Table & Charts component 2.5.7 (Jul 17, 2018)

  • 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.
  • Now "column" chart type is used instead of "bar".
  • FIX:
  • The issue when incorrect Fields List is shown for charts if Flat form layout option is selected was fixed.
  • The issues with saving/restoring sorting of the flat table were fixed.
  • The issue with exporting time data to Excel was fixed.
  • The issue with line endings in CSV export was fixed.
  • The issue with loading CSV files in IE was fixed.
  • The issue with the slow loading of data from SQL Server was fixed.

New in Flexmonster Pivot Table & Charts component 2.5.6 (Jul 2, 2018)

  • NEW New charts option property showDataLabels was added to enable data labels displaying for column and bar chart types (see live demo 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.

New in Flexmonster Pivot Table & Charts component 2.5.5 (Jun 18, 2018)

  • 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 in Flexmonster Pivot Table & Charts component 2.5.3 (May 21, 2018)

  • NEW Integration with Webpack was improved and simplified. Check out the tutorial.
  • NEW NPM flexmonster package was updated to support importing as an ES6/CommonJS module.
  • FIX Issues with printing charts and exporting charts to HTML in IE were fixed.

New in Flexmonster Pivot Table & Charts component 2.5.2 (May 8, 2018)

  • NEW Flexmonster is now available on NPM.
  • NEW Option to disable dragging fields on the grid was added. Learn more.
  • FIX The issue when preloader is not disappearing was fixed.
  • FIX The issue with setting the title for drill through view was fixed.
  • FIX The issue with empty formula was fixed.
  • FIX The issue with full-screen mode was fixed.
  • FIX The issue with loading localization object in ExtJS framework was fixed.
  • FIX The issue with showing data in wrong cells for some specific data sources was fixed.
  • FIX A few issues with dispatching reportchange event were fixed.

New in Flexmonster Pivot Table & Charts component 2.5.1 (Apr 23, 2018)

  • NEW Now we treat empty values as 0 and calculate formula with them. It works only for calculated values, simple aggregations cells are still empty.
  • FIX The drill through context menu is now available for calculated values cells.
  • FIX The issue when dragging items opens filter was fixed.
  • FIX The issue with setting grid title was fixed.
  • FIX The issue with several calculated values in the drill through was fixed.
  • FIX The issue with calling getMembers() for OLAP was fixed.
  • FIX The inconsistency when showing calculated value aggregation was fixed.
  • FIX The issue with quotes and brackets in the filter search was fixed.

New in Flexmonster Pivot Table & Charts component 2.5.0 (Apr 10, 2018)

  • NEW The browser’s memory usage was reduced by around 50%. Read about memory performance tests results.
  • NEW The memory improvements allow you to pivot even faster. Try One million rows demo.
  • NEW New Dark Theme was created. Check how it looks.
  • NEW Selection of multiple items in the filter is now possible using Shift key.
  • NEW New export customization option for PDF is now available via exportTo API call.
  • NEW Integration with Angular 4+ was improved. Now it is based on Angular CLI. Check out the renewed integration tutorial.
  • FIX The issue with highlighting selected rows/columns in Safari was fixed.
  • FIX The issue when the field is being removed from Values box in the result of the same field dragging between Rows, Columns or Report Filters boxes in Fields List was fixed.
  • FIX The issue with (+) and (-) icons for groups and multilevel fields in the legend on charts was fixed.
  • FIX The issue with the not active pivot table in bootstrap tabs was fixed.
  • FIX The issue when using Flexmonster with MooTools framework was fixed.
  • FIX The issue with the fields names in drill-through was fixed.
  • FIX The issue with showAggregationLabels in MSAS was fixed.
  • FIX The issue with dragging fields in drill-through was fixed.

New in Flexmonster Pivot Table & Charts component 2.417 (Mar 27, 2018)

  • NEW :
  • Drillthrough mode for calculated values was added.
  • New Dark UI theme was added to the themes list.
  • Removing fields from the grid using drag’n’drop was added.
  • The default font size for labels on charts was increased and two new LESS variables were added to control it in themes.
  • FIX:
  • The issue with non-active APPLY button when the search is canceled was fixed.
  • The issue with expandAll() API call before export was fixed.
  • The issue when getData() API call with slice provided modifies the internal state of Flexmonster component was fixed.
  • More accurate positioning of (+) icons in the legend on charts.
  • The exception related to right-clicks was fixed.
  • The issue with showing hierarchies that have 3+ levels was fixed.
  • The issue with component resizing inside the tabs was fixed. Calling refresh() is required after the tab is visible.

New in Flexmonster Pivot Table & Charts component 2.416 (Mar 12, 2018)

  • NEW:
  • Type definitions flexmonster.d.ts for Angular (4+) framework was extended with API for integration with FusionCharts, Google Charts and Highcharts (check on GitHub).
  • FIX:
  • Browser’s memory usage was optimized.
  • The issue when clicking on the search icon in Fields List resulted in a page reload was fixed.
  • The issue with parsing large CSV files was fixed.
  • The issue with showHeaders property for drill through was fixed.
  • The issue with height in created pivot instances when working with tabs was fixed.
  • The issue with exporting numeric data from drill through to Excel was fixed.
  • The issue with not working browseForFile property was fixed.
  • .Net Compressor The issue with compressing empty number values was fixed.

New in Flexmonster Pivot Table & Charts component 2.415 (Feb 26, 2018)

  • NEW Compressor PHP and JAVA Now compressor allows setting the timezone for parsing data (TimeZone. The data is still returned in UTC.
  • NEW Pivot allows setting timezone in datePattern and dateTimePattern, which will affect the time displayed on the grid. For example, set pattern as "GMT+2:dd/MM/yyyy", where your custom timezone can be set by specifying GMT+-N hours. Some common abbreviations, like "CET:dd/MM/yyyy" (Central European Time or "JST:dd/MM/yyyy" (Japan Standard Time can be used as well.
  • FIX The issue with exporting tooltips to image and PDF was fixed.
  • FIX The issue with opening old .xml reports was fixed.
  • FIX The issue with grid zooming was fixed.
  • FIX The exception in IE10 was fixed.
  • FIX Browser’s memory consumption was reduced even more.
  • FIX The issue with blank dates in the export to Excel feature was fixed.
  • FIX Spanish localization file was updated (check on GitHub.

New in Flexmonster Pivot Table & Charts component 2.414 (Feb 13, 2018)

  • FIX Measures’ names are displayed in Format cells and Conditional formatting pop-ups without aggregations.
  • FIX Count and Distinct Count aggregations format values as integer no matter what number format is defined for values.
  • FIX The issue with toolbar when loading key asynchronously with licenseFilePath was fixed.
  • FIX The issue with Drag and Drop after choosing Select All in the flat view fields list was fixed.
  • FIX The issue with the toolbar localization when there is more than one pivot instance on the page was fixed.
  • FIX The issue with infinite resizing of the columns in Chrome with zoom 67% was fixed.
  • FIX COMPRESSOR JAVA/.NET The issue with number type in Oracle 11g was fixed.

New in Flexmonster Pivot Table & Charts component 2.413 (Jan 29, 2018)

  • NEW:
  • Running total was added to list of aggregations. More info about running totals.
  • While connecting to data, if the response contains the error message, this message will be displayed in our error pop-up.
  • FIX:
  • The issue with updateData API call and custom sorting was fixed.
  • More minor fixes for updateData API call.
  • The issue with losing filters for OLAP data source was fixed.
  • The updating of preloader’s messages on progress events was fixed for all data sources.

New in Flexmonster Pivot Table & Charts component 2.412 (Jan 15, 2018)

  • The issue with "Bar" label localization was fixed.
  • Export to Excel from flat view with showFilters:true was fixed.
  • The issue when the field’s name is surrounded with brackets '[' ']' was fixed.
  • The width of flat view fields list was increased.
  • Closing of Drill Through view was optimized.
  • The issue with incorrect selection of cell for drill through (when the grid was displaying thousands of rows) was fixed.
  • The issue of losing "m+" and "w+" prefixes in OCSV saved within report JSON was fixed.
  • An exception when parsing CSV that contains a field with "id+" prewas fixed.
  • Browser’s memory consumption was reduced further.
  • The issue with filtering time-base hierarchies in Mondrian was fixed.
  • Save/restore process was fixed for drilled hierarchies.

New in Flexmonster Pivot Table & Charts component 2.411 (Jan 3, 2018)

  • NEW TOOLBAR The ability to connect to remote JSON via the toolbar UI was added. Also, respective localization labels were added to localization files.
  • FIX Navigation with arrow keys on the keyboard was improved.
  • FIX Context menu for filter cells was fixed.
  • FIX The issue with showing context menu outside of the grid was fixed.
  • FIX The issue with an overlapping Calculated Values view was fixed.
  • FIX The issue with sorting members that contain accented characters was fixed.
  • FIX Localization label for "Report Information" was added (use localization.grid.reportInformation property).
  • FIX ACCELERATOR MSAS Exception Value cannot be null. when loading some measures was fixed.
  • FIX The issue with applying fm-ui-element to body element after printing was fixed.
  • FIX The issue with the captions in the fields list was fixed.
  • FIX The issue with not saving "caption" property in report was fixed.
  • FIX The issue with fullscreen mode in IE and Safari was fixed.
  • FIX The issue with fullscreen mode when zoom > 100% was fixed.
  • FIX Positioning of grid pop-ups was fixed.
  • FIX Minor memory leak of dispose() API call was fixed.
  • FIX Browser’s memory consumption was reduced.

New in Flexmonster Pivot Table & Charts component 2.410 (Dec 19, 2017)

  • NEW API method getSelectedCell() was updated to return an array of cells if multiple cells are selected.
  • FIX .Net Compressor The issue with compressing dates was fixed.
  • FIX Context menu in drill-through was disabled.
  • FIX The issue with TOP10 button was fixed.
  • FIX Cancellation of the previously set number formats by setting a default format using "All values" option in "Format cells" pop-up in Toolbar was fixed.
  • FIX Memory usage was improved.
  • FIX The issue with Content-Type when exporting to the server using exportTo() call was fixed.

New in Flexmonster Pivot Table & Charts component 2.409 (Dec 5, 2017)

  • NEW:
  • Values of "date string" and "datetime" types are exported as dates to Excel and are displayed in the default Excel date format.
  • The support of FusionMaps was improved in flexmonster.fusioncharts.js.
  • GZIP property was added for MSAS (via Accelerator). Allows enabling server’s response compression. The default value is true. To disable compression specify GZIP=false in flexmonster.config file.
  • FIX:
  • The issue with exporting to PDF in flat view was fixed.
  • The issue with drawing unnecessary columns in flat view mode when grandTotalsPosition: "bottom" was fixed.
  • The information about member was added to cells in classic view.
  • The issue with editing in flat view mode was fixed.
  • The timer in "Loading members" pop-up for OLAP cubes was fixed.
  • PDF export was improved by reducing padding around cells.
  • Minor memory leak was fixed.
  • Issue with totals for more than 10 dimensions in rows was fixed.

New in Flexmonster Pivot Table & Charts component 2.408 (Nov 20, 2017)

  • NEW:
  • Non-selected fields are sorted in alphabetical order in the fields list for flat table and drill-through view.
  • FIX:
  • The issue with popping-up “Pivot cannot be drawn” alert message from an inactive tab in a browser was fixed.
  • The issue with the wrong fullscreen icon in fullscreen mode was fixed.
  • The issue with exporting wide columns was fixed.
  • The issue with resetting fields when adding calculated value was fixed.

New in Flexmonster Pivot Table & Charts component 2.407 (Nov 6, 2017)

  • NEW:
  • Flexmonster now supports inline CSV. Check out live example.
  • New property grandTotalsPosition was added. It works in the flat view only. The default value is "top", which puts grand totals on top. If you set "bottom", grand totals will be on the bottom.
  • Texts are aligned left in drill-through view.
  • FIX:
  • The issue when new load() method call interrupts the loading process was ed.
  • The issue with saving report file with special characters but without embedded data to the server was ed.
  • The issue with exporting charts to PDF was ed.
  • The issue with missing parameters when saving reports in XML format was ed.
  • The issue with unnecessary scrolling on the page caused by the color picker in conditional formatting pop-up was ed.
  • The issue with pie chart PDF export was ed.

New in Flexmonster Pivot Table & Charts component 2.406 (Oct 24, 2017)

  • NEW:
  • The checkboxes for each hierarchy in Fields List were added.
  • Ability to drag’n’drop hierarchy with levels was added.
  • Pivot fields view is now resizable.
  • roles property is now available for MSAS via Accelerator.
  • FIX:
  • The Top10 button was removed for Mondrian and icCube.
  • The issue with setOptions API call for OLAP cubes was fixed.
  • The incorrect formatting when the average aggregation is applied to "time" fields was fixed.
  • The issue with saving configuration file with special characters to the server was fixed.
  • The issue with case-sensitive filters was fixed for setReport API call.
  • The issue with localeIndentifier for the MSAS Accelerator was fixed.
  • Calculated measures are working correctly for JSON and CSV data sources.
  • The issue with the sorting of short names of months and weekdays was fixed.
  • The issue with changing default TimeZone for Java Compressor was fixed.

New in Flexmonster Pivot Table & Charts component 2.405 (Oct 10, 2017)

  • NEW:
  • Now the pivot’s width/height can be set with string number like "523".
  • Conditional formatting rule can be applied to fields with string members selected as Values with "Count" or "Distinct Count" aggregation.
  • Added the highlight of toolbar icons to the old theme.
  • FIX:
  • The issue with the checkbox in flat fields list was fixed.
  • The issue when the saved .xml report is not correct was fixed.
  • The issue with saving XML reports was fixed.
  • The issue with drill-through exporting for OLAP data source was fixed.
  • Performance of the excel export was improved.
  • The issue with exporting bar_h chart was fixed.
  • The issue with grid layout when sorting/expanding/collapsing intensively was fixed.
  • The issue with closing dropdowns on the outside click was fixed.
  • The issue with grid drawing size on macOS was fixed.
  • The issue with showing MSAS error messages was fixed.
  • expandAllData method was optimized to prevent "Unresponsive script" error.
  • Auto-switching from classic form to compact in case of data is not visible was restored.
  • The issue with grid flickering was fixed.
  • The issue with setting fm-global in Angular was fixed.
  • The issue with the positioning of grid selection and drag’n’drop fields was fixed.
  • The issue with an error when trying to change the aggregation inside Fields List in Firefox was fixed.
  • The issue with backward compatibility for member unique names was fixed. This fix resolved the following issues:
  • the issue with filter restoration from the report if the member’s unique name contains a capital letter;
  • the issue with sortOrder restoration from the report if the member’s unique name contains a capital letter;
  • the issue with expands restoration from the report if the member’s unique name contains a capital letter.
  • The issue with vertical scrollbar absent on the grid was fixed.
  • The issue with grouping feature when expandAll: true was fixed.
  • Cells highlighting for updateData API call was fixed.
  • Version 2.326
  • The issue with saving XML reports was fixed.
  • The issue with setting fm-global in Angular was fixed.

New in Flexmonster Pivot Table & Charts component 2.404 (Sep 25, 2017)

  • NEW:
  • Dragging and dropping fields on the grid were restored.
  • FIX:
  • The issue with missing localization labels was fixed. Also, localization files were improved.
  • The issues with exporting from charts view when grid.type="classic" was fixed.
  • The issue with export for multiple times was fixed.
  • The issue with expands in classic view when the measures are above other dimensions in columns was fixed.
  • The issue with the positioning of Add Group button was fixed.
  • The issue with random error message "Pivot cannot be drawn" was fixed.
  • The issue with the restoration of conditional formatting from XML report was fixed.
  • The issues with sorting for big OLAP hierarchies was fixed.

New in Flexmonster Pivot Table & Charts component 2.403 (Sep 11, 2017)

  • NEW showTotals option was extended to show subtotal rows ("rows"), subtotal columns ("columns"), all subtotals ("on") or do not show them ("off"). Option subtotal is backward compatible. Please note that Options pop-up in Toolbar was updated respectively to use extended showTotals option. The localization variables were updated as well.
  • NEW updateData API call was extended with ignoreSorting and ignoreScroll properties. Also, for JSON data source added ability to update only some part of the data (check docs and example).
  • FIX Anti-caching mechanism was added for the default flexmonster.css and flexmonster.toolbar.js when they are loaded by the component.
  • FIX The issue when drill-through with greater than 10,000 rows shows incorrect results was fixed.
  • FIX Responsive layout for filter view was improved to support different localization labels better.
  • FIX Responsive layout for alert windows was improved.
  • FIX Responsive layout for charts was improved.
  • FIX Setting max cell width/height using CSS was restored.
  • FIX The issue with charts legend overflow was fixed.
  • FIX The issue with exporting to Excel on macOS was fixed.
  • FIX The issue with grid title alignment was fixed.
  • FIX The issue with clicking on expand/collapse icon with showHeaders:false was fixed.
  • FIX The issue with resizing the component after the change of the parent container was fixed.
  • FIX The issue with infinite columns/rows resize was fixed.
  • FIX The issue with showing charts if pivot container doesn’t have an ID was fixed.
  • FIX Improved performance for CSV and JSON parsing.
  • FIX The issue with expands after switching between different view types was fixed.
  • FIX The issue with expandAllData and collapseAllData methods was fixed.
  • FIX The issue with pre-filtering was fixed.
  • FIX More readable hierarchy captions for drill through from OLAPs.
  • FIX The issue with restoring table sizes from the report was fixed.
  • FIX The issue with toolbar icons when exiting from fullscreen mode was fixed.
  • FIX The issue with adding calculated values in flat view mode was fixed.
  • FIX ACCELERATOR MSAS Concurrent use of the Accelerator was improved.

New in Flexmonster Pivot Table & Charts component 2.402 (Aug 28, 2017)

  • NEW
  • API call fullscreen() was removed. Now fullscreen is available from Toolbar only.
  • FIX:
  • The issue with disappearing right and bottom borders was fixed.
  • The issue with selecting all results after the search was fixed.
  • Add group button in report filters was restored.
  • The issue with showing 300K+ members in the filter was fixed.
  • The issue with boolean values for options.grid.showGrandTotals was fixed.
  • The issue with the subtotals turning off when the measures are above other dimensions in columns or rows was fixed.

New in Flexmonster Pivot Table & Charts component 2.401 (Aug 22, 2017)

  • FIX The issue with showing 150K+ rows in IE/Edge was fixed.
  • FIX UI/CSS issues in IE11 were fixed.
  • FIX The issue when beforetoolbarcreated event was dispatched two times was fixed.
  • FIX The following issues with export to excel were fixed:
  • when showFilters: true is set as an export parameter;
  • when a report has a grid title;
  • when customFields are defined in a report.
  • FIX The issue with adding .false CSS class to each cell that does not meet the condition formatting rule was fixed.
  • FIX The issue with Add Group button was fixed.
  • FIX The issue with measures formatting in drill-through view was fixed.
  • FIX Fix for buggy behavior after canceling on Open CSV File.
  • FIX Toolbar exception was removed for IE11.
  • FIX Charts working correctly in IE11.
  • FIX Cell renderer demo was fixed for IE11 and Edge.

New in Flexmonster Pivot Table & Charts component 2.400 (Aug 14, 2017)

  • NEW:
  • Grid rendering was improved greatly. As the result, the scrolling is smooth and fast. The scrolling issues reported by our customers were fixed.
  • Export from Drill Through was added. When Drill Through popup is opened, Export tab from the toolbar or exportTo() API call get the raw data.
  • Accelerator for Microsoft Analysis Services and Accelerator for Pentaho Mondrian work much faster. The concurrency was improved: Accelerators work better with multiple threads.
  • All fixes from version 2.3 are available in 2.4 as well.
  • New UI for the component was created.
  • Several built-in themes were added. New themes can be added (via Less or CSS). Find how to use it in our documentation.
  • customizeCell API call was extended with new possibilities to visualize the data.
  • jQuery library is no longer required.
  • Now new Flexmonster() should be used to embed the component.
  • Conditional Format Object was updated.
  • Cell Data Object was extended with new properties.
  • getPages API call was renamed to getReportFilters.
  • Property pages from Report Object was renamed to reportFilters (with backward compatibility).
  • Properties configuratorMatchHeight and pagesFilterLayout were removed from Options Object.
  • The default value of configuratorActive property inside Options Object was changed to false.
  • Two new events were added:
  • beforegriddraw – String, triggered before grid rendering.
  • aftergriddraw – String, triggered after grid rendering.

New in Flexmonster Pivot Table & Charts component 2.321 (Jul 31, 2017)

  • FIX The issue with exporting flat table to Excel was fixed.
  • FIX Now when the slice is not set the order of the columns in flat view is the same as in the data source.

New in Flexmonster Pivot Table & Charts component 2.319 (Jul 7, 2017)

  • NEW .NET Core Compressor was added (read more).
  • FIX The issue with loading CSV file with empty column names was fixed.
  • FIX The localization for the "Too many columns for classic form..." message was added.
  • FIX The issue with CSV/Excel export in charts mode was fixed.
  • FIX The issue with cross-site scripting in CSV data was fixed.
  • FIX Sorting issue for prefiltered data was fixed.
  • FIX The issue with loading g-zip files in Firefox was fixed.
  • FIX PHP Compressor The issue with ob_end_flush() error was fixed.
  • FIX ACCELERATOR MONDRIAN Added new parameter JDBC_DELIMITER to resolve an issue with ; delimiter inside JDBC connection string (read more).

New in Flexmonster Pivot Table & Charts component 2.318 (Jul 7, 2017)

  • NEW New property drillthroughMaxRows was added. It allows so set the max number of rows for the MSAS drillthrough. Supported only via XMLA protocol.
  • NEW React + ES6 integration was added to our React examples on GitHub.
  • FIX The issue with unnecessary requests to OLAP cube was fixed.
  • FIX The issue with aggregation labels for grouping feature was fixed.

New in Flexmonster Pivot Table & Charts component 2.317 (Jul 7, 2017)

  • NEW When hovering over a text with ellipses in charts the full name is shown in a tooltip.
  • NEW New tutorial Integration with Angular 4 was added.
  • FIX When the axis title is long and is displayed not in full in charts, the full text is shown on hover.
  • FIX The issue with too dense labels on the axis in charts was fixed.
  • FIX Date sorting in Mondrian and icCube was improved.
  • FIX Occasional exception on expand was fixed.
  • FIX The issue with sorting by name applied after sorting by value was fixed.
  • FIX ACCELERATOR MSAS Freezing while filtering non-existent member was fixed.

New in Flexmonster Pivot Table & Charts component 2.316 (Jul 7, 2017)

  • FIX The issue with negative zero was fixed.
  • FIX Drill through with multiple items in report filter was fixed.
  • FIX The issue when getReport() does not return options.grid.type value if it is "compact" was fixed.
  • FIX The drill-through pop-up opening was disabled for empty table cells.
  • FIX The issue with group disappearing after expandAll() API call was fixed.
  • FIX Compressor .NET The issue with dbNull value was fixed.
  • FIX ACCELERATOR MONDRIAN The issue with parsing specific CONNECTION_STRING formats was fixed.

New in Flexmonster Pivot Table & Charts component 2.315 (Jul 7, 2017)

  • NEW The following new CSS classes were added:
  • .fm-total-r – to cells in subtotal rows
  • .fm-total-c – to cells in subtotal columns
  • .fm-grand-total-r – to cells in grand total row(s)
  • .fm-grand-total-c – to cells in grand total column(s)
  • .fm-total-classic-r – to cells in subtotal rows in the classic view.
  • FIX The issue with the minimum size of the stack element in the bar stack chart was fixed.
  • FIX The issue with parsing dates in Firefox was fixed.
  • FIX The issue with sorting dates in OLAP was fixed.
  • FIX Compressor PHP The issue with compressing dates was fixed.