Double data type for Subtotal seems not working

Aspose.Cells Product Family
1

Dear All,

can I use double for Subtotal? like codes below?

cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new double[] { 1,2,3 });

need advise

Thanks
2

Hi,

Thanks for your posting and using Aspose.Cells.

You cannot use double array. Because Subtotal() method is expecting int array. So kindly change your code like the following.

cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 1,2,3 });

It should fix your issue. Let us know if you still encounter any issue, we will look into it and help you asap.
3

I was misunderstood there :)…

thank you for your clarification
4

Hi,


Good to know that your issue is figured out now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.