How to do a subtotal on Aspose.Cells.ExcelDesigner

Aspose.Cells Product Family
1

I am trying to find samples on how to do a subtotal using the Exceldesigner. I saw examples of doing a formula on thesame row but I cannot find anything which does a subtotal for all rows inserted. Is this possible using the exceldesigner? and do you have a sample?

Thanks in advance!!!

2

Hi,

Thanks for considering Aspose.

Are you talking about Aspose.Cells.WorkbookDesigner. Well, you have to manually do the subtotals for each row. In Pivot Tables it can be applied for all the rows only.

Thank you.

3

Here's a sample of what I'm trying to accomplish

Header1 Header2 Header3

ItemA AmtA1 AmtA2

ItemB AmtB1 AmtB2

Item C AmtC1 AmtC2

------------------------------------

TOTAL Total1 Total2

Basically, I'm trying to subtotal all the rows. Do you have any examples on how to accomplish this?

Thanks a lot!

4

Hi,

Kindly check how to use and set formulas:

Thank you.