NReco.PivotData.Extensions 1.7.0

The ID prefix of this package has been reserved for one of the owners of this package by Prefix Reserved
dotnet add package NReco.PivotData.Extensions --version 1.7.0
NuGet\Install-Package NReco.PivotData.Extensions -Version 1.7.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="NReco.PivotData.Extensions" Version="1.7.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add NReco.PivotData.Extensions --version 1.7.0
#r "nuget: NReco.PivotData.Extensions, 1.7.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install NReco.PivotData.Extensions as a Cake Addin
#addin nuget:?package=NReco.PivotData.Extensions&version=1.7.0

// Install NReco.PivotData.Extensions as a Cake Tool
#tool nuget:?package=NReco.PivotData.Extensions&version=1.7.0

PivotData Toolkit components: render pivot tables to HTML, exports to JSON/CSV/Excel/PDF/DataTable, pivot table calculations (percentages, differences, running total, heatmap, top-N/pagination/groups expand-collapse), load data from SQL databases, infrastructure for interactive web-based reports builder.

Note: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some data limitations and trial notices).
ASP.NET pivot table builder online demo:
Examples download:

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 is compatible. 
.NET Framework net45 is compatible.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.7.0 3,832 9/28/2023
1.6.2 2,860 4/17/2023
1.6.1 13,422 7/28/2022
1.5.5 5,464 4/12/2022
1.5.4 16,332 5/29/2021
1.5.3 17,235 5/27/2020
1.5.2 136,867 12/30/2019
1.5.1 993 12/11/2019
1.5.0 14,257 3/17/2019
1.4.2 2,497 8/23/2018
1.4.1 62,591 4/12/2018
1.4.0 1,522 1/9/2018
1.3.8 1,815 9/25/2017
1.3.7 7,129 7/26/2017
1.3.6 1,364 6/26/2017
1.3.5 1,433 3/15/2017
1.3.4 1,807 2/1/2017
1.3.3 4,343 12/2/2016
1.3.2 22,991 10/18/2016
1.3.1 1,805 9/16/2016

v.1.7.0 changes:
- PivotTableHtmlWriter: fixed incorrect "data-value-index" for subtotals (affects 'drill-down' click handler on subtotals)
- PivotTableHtmlWriter: fixed incorrect rowspan value for 'prev'/'next' columns pagination cells (only when report has multiple measures on values)
- PivotTableHtmlWriter/PivotTableExcelWriter: fixed an issue when RepeatKeysInGroups is enabled for columns and number of measures > 1
- PivotTableHtmlWriter/PivotTableExcelWriter: added new SubtotalInsideGroup option (determines where subtotals are rendered)
- PivotTableExcelWriter: now default styles (including borders/labels lightgrey bg) are consistent with HTML output (can be customized)
- PivotTableCsvWriter: added CsvQuoteIfTrimPossible option that controls whether to quote values that may be trimmed
- CubeKeywordFilter: fixed incorrect handling of 'less than'/'greater than' conditions on dimensions
- CubeKeywordFilter: added an extension point to handle custom filters (via ResolveSpecialKeyword override)
- Added CubeGroupTopFilter class to filter pivot table groups by top-N (or last-N) criteria

v.1.6.2 changes:
- PivotTableHtmlWriter and PivotTableExcelWriter: do not render extra "Totals" header row if no columns and number of measures > 1
- PivotTableFactory.SortByValue is now 'protected' to allow inheritors to implement custom behaviour
- DifferencePivotTable: added SameGroupOnly to calculate difference only between values that belong to the same group
- PivotTableHtmlWriter: now it is possible to apply CollapsePivotTable wrapper for interactive HTML rendering. This unlocks possibility to use PaginatePivotTable or TopPivotTable with collapsed pivot tables. Old way (when CollapsePivotTableConfiguration is handled inside PivotTableHtmlWriter) is preserved so this is backward-compatible change.

v.1.6.1 changes:
- fixed incorrect assembly version in 1.6.0 that can cause project's build error
- PivotTableExcelWriter: now it is possible to override AutoFitColumns to implement custom cells width adjustment logic

v.1.6.0 changes:
- FixedPivotData: now it is a thread-safe
- Added netstandard2.1 build (all new async API methods are available only in this build)
- Added IPivotDataSource.ReadDataAsync method with a default implementation (fallbacks to sync ReadData)
- DbCommandSource, DerivedSource implement ReadDataAsync
- Added SourceReader.ReadAsync method
- Added GroupedSourceReader.ReadAsync and ReadStateAsync methods

v.1.5.5 changes:
- PivotTableExcelWriter: fixed issue with incorrect colspans for subtotals/collapsed rows
- PivotTableExcelWriter: added ApplyDimensionKeyStyles protected method (used to customize 'headers' cells)
- PaginatePivotTable: fixed an exception when CompositeAggregator has only one nested aggregator
- CubeKeywordFilter: added Filter overload that returns actually applied filter (reconstructed conditions, all with 'hints')
- CsvSource: added an ability to handle CSVs with duplicate headers (column's index is added to the name to make it unique)

v.1.5.4 changes:
- RunningValuePivotTable: fixed issue with slow computations in case of multiple measures
- PivotTableJsonWriter: now it is possible to include sub-totals (this is controlled by SubtotalRows/SubtotalColumns properties)
- PivotTableFactory: fixed issue with incorrect grouping in expand/collapse mode (the same group may duplicate many times when axis is ordered by values)

v.1.5.3 changes:
- FixedPivotData: more efficient GetEnumerator implementation
- PivotTableHtmlWriter: fixed issue with incorrect colspan for disabled totals row when grand-total is enabled
- PivotTableFactory: added protected CreatePivotTableInstance method
- CubeKeywordFilter: added ResolveDimensionKey property (used for matching formatted values)

v.1.5.2 changes:
- hotfix for DifferencePivotTable: when underlying PivotData is configured with CompositeAggregatorFactory incorrect aggregator type is returned (which causes 'invalid cast' exception)

v.1.5.1 changes:
- HTML/Excel/CSV/DataTable writers: added ability to render totals at the beginning of the group (TotalsRowPosition and TotalsColumnPosition properties)
- TopPivotTable: added 'last N items' mode
- DifferencePivotTable: now differences are calculated for sub-totals if possible

v.1.5.0 changes:
- Expand/collapse (new feature): implemented as CollapsePivotTable class (used in exports) + PivotTableHtmlWriter.CollapseConfiguration property (used for interactive expand/collapse).
- Added PivotTableConfiguration.SortGroupsBySubtotals option that determines how group labels are ordered if PreserveGroupOrder is enabled
- Fixed issue when row-headers are not rendered when no columns and column with totals is disabled
- PivotDataDataTableWriter: added ability to include sub-totals
- Fixed incorrect handling of FormulaAggregator (when this is only aggregator)

Change log for all versions: