SubTotals Formatting

[Tim Larson]

Hi,

I am using the range subtotals and I am trying to figure out how to apply a style to the subtotal row and the grand total row.  I want to change the back ground and make the font bold for the entire line of each so it sticks out better.

Please advise the best way to achieve this.

Thanks,

Tim

[Meikanda Nayanar]

Hi Tim, 

 

Thank you for contacting Syncfusion support. 

 

We have prepared a sample to achieve your requirement which can be downloaded from the following link. 

 

Sample Link: http://www.syncfusion.com/downloads/support/forum/143748/ze/CreateSpreadsheet1434964092  

 

Code snippet: 

string startCell = worksheet[worksheet.UsedRange.Row, worksheet.UsedRange.Column].AddressLocal; 

IConditionalFormat format = worksheet[worksheet.UsedRange.Row, worksheet.UsedRange.Column, worksheet.UsedRange.LastRow, worksheet.UsedRange.LastColumn].ConditionalFormats.AddCondition(); 

format.FormatType = ExcelCFType.Formula; 

format.FirstFormula = string.Format("=LEFT(FORMULATEXT({0}),9)=\"=SUBTOTAL\"", startCell); 

format.BackColor = ExcelKnownColors.Bright_green; 

format.IsBold = true; 

 

Kindly try this and let us know whether it helps. 

Thanks, 

Meikandan