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

Free Support Forum - aspose.com

Ow to set number format to Subtotal?

Dear All,


Could any body please help… how to set number format to Subtotal? … (see enclosed xls)

thanks a lot in advance

cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17 });

Hi,


Well, once you have applied Subtotals, you have to specify your desired Numbers formatting to the relevant cells in the Subtotal row, see the document for your reference on how to apply numbers formattings:
http://www.aspose.com/docs/display/cellsnet/Setting+Display+Formats+of+Numbers+and+Dates

Thank you.