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

Free Support Forum - aspose.com

Dynamic Sub-total - Change Subtotal Line format

I am using dynamic sub-totaling- is there a way to format the subtotal rows - such as change border, font, background cell color, etc.

cells.Subtotal(ca, 0, ConsolidationFunction.Sum, new int[] { 13, 14, 15 });

Hi,

Please provide us your complete code and source xls/xlsx file if you are using any. Please also provide us your desired xls/xlsx file which you can create manually using Ms-Excel.

Also, if you want to style any cell, then you can style it using the Style object. You will get access to all the properties of the style object.

e.g


Style st = cell.GetStyle();

st.Font.IsBold = true;

cell.SetStyle(st);

Please see the subsections for further reference:
Working with Data Formatting

Hi,


Well, Aspose.Cells provides the Subtotal feature same as MS Excel. In MS Excel, you cannot format directly the Subtotal rows, the Subtotal feature does not provide formatting options. But for your need after performing Subtotals, you may format and apply your desired formattings (e.g set borders around cells, apply font attributes, cells shading/background colors etc.) to your desired rows/cells, see the documents for your reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/dealing-with-font-settings.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/colors-background-patterns.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/adding-borders-to-cells.html

Thank you.