Deleting s conditional format

[Ben]

Hi

The interface IConditionalFormat does only allow adding new conditional formats. How do I remove a conditional format from a cell?

Thanks, Ben

[Melba Winshia]

Hi Ben,

Thank you for your interest in Syncfusion Products.

Deleting Conditional Format:
-------------------------

I regret to let you know that currently we do not provide support for this feature in our code library. We have notified our development team on this regard and will get back to you once we hear back from them.

Thank you for your patience.

Regards,
Melba

[Ben]

thanks for you info

As I was not able to remove the conditional format from the cell I tried to modify it in that way that it does not affect the format of the cell anymore (by tring to change the conditional format formula in that way that it always returns false).

Unfortunately I when I saved the file the conditional format still contained the original formula, not the modified one. Is it possible that this is a bug?
It mees to me that I can modify the conditional format but it is just not sroted to the file.

I also found that when I added a conditional format to the already existing one in anoterh cell then it somtimes stored the modifications I made to the original formula on the first cell and sometimes not. I also sometiems had the effect that the conditional format was lost on certain cells on which I have not done any modifications on. Is there any known bug when modifiying an already existing conditional format in a excel?

Thanks for your help.

[Melba Winshia]

Hi Ben,

Thank you for the update.

I am afraid that I was not able to reproduce the issue. Also I have created a simple sample and it is available in the below link:

http://websamples.syncfusion.com/samples/XlsIO.Windows/69361/main.htm

In the above sample I have read conditional format from existing template and modified the formula using XlsIO and the formula in the cell A1 is modified.

Please have a look at the above sample and if still the issue exists, could you please try reproducing it in the above sample and send us the modified sample so that we could sort out the cause of the issue and provide you a solution?

Thanks,
Melba