Find subtotalling applied to a range

Aspose.Cells Product Family
1

Hi,

I've been searching the forums but not been able to find anything on this at all.

Is it possible with Aspose to find what subtotalling has been applied to a range of cells

2

Hi,

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

Please elaborate your issue in more detail. We will look into it and let you know if it is possible. Please also provide the sample input xls/xlsx file and expected output xls/xlsx file if applicable.

Please also see the following article relating to subtotal and see if it is helpful in your case.

http://www.aspose.com/docs/display/cellsnet/Creating+Subtotals

3

We have a template spreadsheet with a range of data in it that's been subtotalled.

We want to be able to refresh the range of data and apply the same subtotalling to the new data.

We don't know what subtotalling has been applied to the original data other than to derive it from the template spreadsheet itself.

So the question is how can we find out what subtotalling has been applied to the template in order that we can reapply it after refreshing the data?

4

Hi,

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

We have looked into your requested feature and we are afraid, this feature is not available. You cannot find out what subtotalling has been applied to the template in order that you can reapply it after refreshing the data.