We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to copy conditional formatting using xlsio?

Thread ID:





63163 Jun 28,2007 06:42 PM Sep 29,2017 06:38 AM ASP.NET Web Forms (Classic) 5
Tags: XlsIO
Asked On June 28, 2007 06:42 PM

Is it possible to copy Conditional Formatting when inserting a row?

I have tried both InsertRow and CopyTo (with the various ExcelCopyRangeOptions). These functions do not seem to copy the conditional formatting.

I have also tried going through the ConditionalFormats collection in the previous row, and for each conditional format in the old row creating a new conditional format in the new row, copying each conditional format property individually. However the problem with this approach is that the formulas will not be updated automatically.


Melba Winshia [Syncfusion]
Replied On June 29, 2007 08:10 AM

Hi SH,

Could you please open a new direct – trac incident with subject line as Forum 63163 - How to copy conditional formatting using XlsIO? So that it would be possible for us to provide more details regarding this issue.


Russell Baker
Replied On May 2, 2012 02:58 PM

Have there been any updates on this issue? I can't find this anywhere else.

Mahajothi R [Syncfusion]
Replied On May 4, 2012 12:25 AM

Hi Vikas,

Thank you for creating a new incident in Direct Trac for the above reported issue. We request you to follow the incident 93954 to know more details about the reported issue.

Please let us know if you need any further assistance.

Mahajothi R.

Paul Meems
Replied On September 28, 2017 08:16 AM

I know this is an old post. But I'm facing the same problem.
I can't find the mentioned issue number.

I add rows to an existing Excel file and I want to copy the conditional formatting as it is defined in the Excel file.

Please advice.

Abirami Varadharajan [Syncfusion]
Replied On September 29, 2017 06:38 AM

Hi Paul, 
We request you to make use of `ExcelInsertOptions` enumeration while inserting new row to specify the formatting option as before or after the newly inserted row. Please refer the below documentation to know more about this. 
If you wish to copy conditional formats to newly inserted row then make use of `ExcelCopyRangeOptions` enumeration. Please refer the below documentation link for further details regarding this. 
We have also shared simple sample for your reference which can be downloaded from the following link. 
If your requirement differs from this scenario then kindly share your requirement in detail which will be helpful for us to provide prompt solution at the earliest. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.