How to copy conditional formatting using xlsio?

[SH]

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.

Thanks

[Melba Winshia]

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.

Thanks,
Melba

[Russell Baker]

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

[Mahajothi R]

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.


Regards,
Mahajothi R.

[Paul Meems]

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]

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. 

 

https://help.syncfusion.com/cr/cref_files/file-formats/xlsio/Syncfusion.XlsIO.Base~Syncfusion.XlsIO.ExcelInsertOptions.html  

 

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. 

 

https://help.syncfusion.com/cr/cref_files/file-formats/xlsio/Syncfusion.XlsIO.Base~Syncfusion.XlsIO.ExcelCopyRangeOptions.html  

 

We have also shared simple sample for your reference which can be downloaded from the following link. 

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample1159125195.zip  

 

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. 

 

Regards, 

Abirami.