Merging or adding style

Hi,
I have a problem with the styles.
We create our excel report from a xls template.
The template already has some general formatting.

When I add some style to a range in the report (color…), it clear the original style (border, type…). It’s not what I want : I just want to add something to the style.

How to do this, did I miss something ?

Currently Range.Style will clear previous setting for individual cells and apply the new style.

I will add a new method for Range object to apply new style without removing individual cells formattings.

What’s the delay to have this update ?
How can I do it for the moment ?
Is it working when we add the style to each cell ?

Currently you have to set formattings cell by cell.

For example:

cell["A1"].Style.Font.IsBold = true;

cell["A2"].Style.Font.IsBold = true;

This action won't clear previous settings.

I will add a new method for Range object to apply new style without removing individual cells formattings.

Did you plan the update yet ?

I will release a new version before the start of next week which will include this method.

Thanks
I’ll try it