I have some columns, with subtotal implemented using below formula
public void subtotal(com.aspose.cells.CellArea cellArea, int i, int i1, int ints).
In this case requirement is to use SUM() function for at the bottom cells of all those columns to get total (I CANT use 'show grand Total at bottom' so i search for it and delete it manually )
SUM() yields me wrong values for columns where subtotal implemented(obviously).
please suggest me a way so that i can get correct total for those columns (other than 'Show grand total ').
Also I want to provide styles to SUBTOTAL implemented cells
I'm aware of Style class and its methods but not able to recognize cells where SUBTOTAL is implemented.