feat(TreeData): add optional Aggregators to Tree Data grids

[ghiscoding]

• add the possibility to use the same Aggregators that are used in Grouping, however all Aggregators had to be modified to support tree data which has a few differences
• also note that when Aggregators are used with Grouping then the aggregation are under a separate row with __groupTotals details... however on Tree Data it will have its totals under __treeTotals and also directly on the parent item
• currently only 5 Aggregators are supported with Tree Data: Avg, Sum, Min, Max and Count
• also note that AvgAggregator will automatically give you "avg", "count" and "sum", so if the user needs all 3 then it is a lot better to use Avg for better perf. The other reason why calling Avg+Sum will give you worst perf is that each aggregation is separate and will redo the item count and sum work for each aggregators, so it is better to simply use Avg instead of Avg+Sum
• also added Formatters.treeParseTotals that can be used to parse and auto-detect when to use GroupTotalFormatters or regular Formatter, user must also provide a treeTotalsFormatter or groupTotalsFormatter
  • this formatter will work with both regular Formatters and GroupTotalFormatters, it will auto-detect if it has __treeTotals then it will use the GroupTotalFormatters or else it will try to use regular Formatters.

TODOs

• fix and add Jest unit tests
• fix and add Cypress E2E tests
  • make sure to test that adding new files automatically updates the Aggregators totals
• add Formatter to parse & show Tree Totals (similar to GroupTotalsFormatters)
• might also need adjustments for Excel/CSV/Text exports
  • created a separate PR feat(export): add autoDetectCellFormat flag to Excel Export Options #1083 to add a new flag in order to disable auto-detection of cell format
• does not currently update aggregation when applying filter(s)
  • WILL DO IN SEPARATE PR
  • Ag-Grid has a grid option flag for this suppressAggFilteredOnly or column flag groupAggFiltering
    • true will show full total, while false will only show filtered data total
• adding new item to hierarchical Tree Data always flicker (only Example 6) because it always go back to top then we scroll back to the new item, it's caused by a reset of the data which we might not need and would require more thorough inspection
  • should be done in separate PR though, created new PR fix: adding dataset hierarchical item shouldn't cause scroll flickering #1076 to handle this
    

    slickgrid-universal/packages/vanilla-bundle/src/components/slick-vanilla-grid-bundle.ts

    Line 196 in 07efeb6

    this.dataView.setItems([], this._gridOptions?.datasetIdPropertyName ?? 'id');

below is an example with both Avg and Sum Aggregators displayed

[codecov]

Codecov Report

Merging #1074 (7ec3d84) into master (07efeb6) will not change coverage.
Report is 8 commits behind head on master.
The diff coverage is 100.00%.

@@            Coverage Diff             @@
##            master     #1074    +/-   ##
==========================================
  Coverage   100.00%   100.00%            
==========================================
  Files          244       245     +1     
  Lines        16564     16798   +234     
  Branches      5933      6030    +97     
==========================================
+ Hits         16564     16798   +234     

Files Changed	Coverage Δ
packages/common/src/aggregators/avgAggregator.ts	100.00% <100.00%> (ø)
packages/common/src/aggregators/cloneAggregator.ts	100.00% <100.00%> (ø)
packages/common/src/aggregators/countAggregator.ts	100.00% <100.00%> (ø)
...kages/common/src/aggregators/distinctAggregator.ts	100.00% <100.00%> (ø)
packages/common/src/aggregators/maxAggregator.ts	100.00% <100.00%> (ø)
packages/common/src/aggregators/minAggregator.ts	100.00% <100.00%> (ø)
packages/common/src/aggregators/sumAggregator.ts	100.00% <100.00%> (ø)
packages/common/src/formatters/formatters.index.ts	100.00% <100.00%> (ø)
packages/common/src/formatters/index.ts	100.00% <100.00%> (ø)
...ackages/common/src/formatters/multipleFormatter.ts	100.00% <100.00%> (ø)
... and 4 more

... and 4 files with indirect coverage changes