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

Free Support Forum - aspose.com

Looking for a way to get sum at the end of a column that has subtotal implemented

Hi,

(1)

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 ').

(2)

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.

Please Advice!

Thanks

Hi,


1) Aspose.Cells’ Subtotal feature is same as MS Excel, you may confirm/compare it performing the Subtotal feature in MS Excel manually. If you find any difference let us know. You may perform the task in MS Excel using its Subtotal feature and give us the steps involved, you may give us template file(s) and some screen shots for it. And, if you do some manual updation or adjustments after using the Subtotal feature (in Ms Excel), I am afraid, you have to do the same updation and adjustments by Aspose.Cells APIs as there would be no logic in it.

Also, see the topic for your reference:
http://www.aspose.com/docs/display/cellsjava/Creating+Subtotals


2) Well, I think you may Find your desired cells in the Subtotal cells range, and format the cells according to your needs. See the topic on how to find / replace cells data/values:
http://www.aspose.com/docs/display/cellsjava/Find+or+Search+Data

Thank you.