Performing Subtotal Calculation on Group Column

Aspose.Cells Product Family
1

Attempting to perform a ConsolidationFunction on the same column used in GroupBy causes the subtotal to be overwritten by the aggregation label. Sample code:

sheet.Cells.Subtotal(ca, colNum, ConsolidationFunction.CountNums, new int[] { colNum }, true, false, true);

Essentially I'm trying to count the number of items in each group, but I can't use other columns because they might not necessarily contain values, or I might be using them for additional counts.

What I would like to see is shown in the expected results, which is how Excel 2010 creates the summary lines when using the Excel subtotal function.

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have logged your issue in our database. Development team will look into your issue and fix the problems.

Once, there is some fix available or we have some update for you, we will let you know.

This issue has been logged as CELLSNET-40623.

3

Hi,

Please download and try this fix: Aspose.Cells for .NET v7.2.0.4

4

The issues you have found earlier (filed as CELLSNET-40623) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.