NReco.PivotData.Extensions 1.4.2

PivotData Toolkit (extends NReco.PivotData library): advanced components for pivot table reports generation (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentage, difference, running total, heatmap, topN/pagination), CSV/TSV/JSON/SQL data sources, extract-transform-load (ETL) handlers, keyword-based filter etc.

Install-Package NReco.PivotData.Extensions -Version 1.4.2
dotnet add package NReco.PivotData.Extensions --version 1.4.2
paket add NReco.PivotData.Extensions --version 1.4.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Note: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some data size limitations and trial notices).
ASP.NET pivot table online demo: http://pivottable.nrecosite.com/
Examples download: https://www.nrecosite.com/pivot_data_library_net.aspx

Release notes https://www.nrecosite.com/pivotdata/bi-toolkit-release-notes.aspx

v.1.4.2 changes:
- fixed issue with FixedPivotData.Count (returns zero until first indexer access)
- CubeKeywordFilter: do not lowercase keywords
- CubeKeywordFilter: fixed issue with AND filter by measures
- CubeKeywordFilter: enable conditions (>, <, =) for dimensions if hint is provided
- CubeKeywordFilter: fixed issue with index-out-of-range for filters like "aaa, +"
- HeatmapPivotTable: 2 new options for HeatmapMode "RowTotal" and "ColumnTotal"

v.1.4.1 changes:
- PivotTableHtmlWriter: fixed incorrect groups rendering if more than 3 dimensions are selected for rows or columns.
- PivotTableDataTableWriter: infer column type if possible to avoid object-type columns.
- CubeKeywordFilter: added ability to filter by measure value with syntax like "sum>20".
- CubeKeywordFilter: correct filtering by empty keyword or when started/ended with space char
- CubeKeywordFilter: now it is possible to resolve dimensions/measures by hints with custom handlers.
- PivotDataFactory: new 'Quantile' and 'Mode' aggregators are registered by default.
- PivotDataFactory: new 'Quantile' and 'Mode' aggregators are registered by default.
- Fixed issue with HeatmapPivotTable in TRIAL mode (without a license key).
- Updated NReco.PivotData.Extensions dependencies:
    netstandard2.0 build now uses official EPPlus v.4.5.1 nuget package)
    netstandard1.5 build uses EPPlus.Core v.1.5.4 nuget package (as official EPPlus doesn't support netstandard1.5)

Version History

Version Downloads Last updated
1.4.2 93 8/23/2018
1.4.1 1,052 4/12/2018
1.4.0 432 1/9/2018
1.3.8 554 9/25/2017
1.3.7 2,273 7/26/2017
1.3.6 253 6/26/2017
1.3.5 407 3/15/2017
1.3.4 679 2/1/2017
1.3.3 2,132 12/2/2016
1.3.2 288 10/18/2016
1.3.1 402 9/16/2016