We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Double data type for Subtotal seems not working

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

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.

I was misunderstood there :)…

thank you for your clarification

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.