NReco.PivotData.Extensions 1.6.2

Prefix Reserved
.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.5 This package targets .NET Framework 4.5. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package NReco.PivotData.Extensions --version 1.6.2                

                    
                

            
NuGet\Install-Package NReco.PivotData.Extensions -Version 1.6.2
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.6.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add NReco.PivotData.Extensions --version 1.6.2                

                    
                

            
#r "nuget: NReco.PivotData.Extensions, 1.6.2"
#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.6.2

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

PivotData Toolkit (extends NReco.PivotData OLAP library): advanced components for pivot table reports generation (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentages, differences, running total, heatmap, topN/pagination/groups expand-collapse), CSV/JSON/SQL input data loaders, web-based reports builder for end-users.

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: http://pivottable.nrecosite.com/
Examples download: https://www.nrecosite.com/pivot_data_library_net.aspx

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.1 242 11/13/2024
1.7.0 15,644 9/28/2023
1.6.2 3,740 4/17/2023
1.6.1 15,565 7/28/2022
1.5.5 5,868 4/12/2022
1.5.4 21,047 5/29/2021
1.5.3 19,189 5/27/2020
1.5.2 190,239 12/30/2019
1.5.1 1,023 12/11/2019
1.5.0 14,888 3/17/2019
1.4.2 2,737 8/23/2018
1.4.1 76,693 4/12/2018
1.4.0 1,560 1/9/2018
1.3.8 1,854 9/25/2017
1.3.7 7,170 7/26/2017
1.3.6 1,388 6/26/2017
1.3.5 1,471 3/15/2017
1.3.4 1,890 2/1/2017
1.3.3 4,402 12/2/2016
1.3.2 28,243 10/18/2016
1.3.1 1,862 9/16/2016

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: https://www.nrecosite.com/pivotdata/bi-toolkit-release-notes.aspx