Set the BackgroundColor-Value of a cell to null

[mawagi7]

Hi,

the initial "BackgroundColor"-value of a cell is null.

How can I reset a (red colored) cell?

Currently I'm able to set the background color to white ("#FFFFFF"). But in this case there is no border at the right and bottom.

Following call leaves the cell in red color:

Sheet.SetFormat(Sheet.Selection.Regions, new CellFormat() { BackgroundColor = null });

Is there any solution for this problem?

[anmcgrath]

Hi @mawagi7 this is an oversight by me, and it isn't currently possible.

For now, you could do:

Sheet.SetFormat(Sheet.Selection.Regions, new CellFormat() { BackgroundColor = " "});

and it won't show a bg color.

I'll work on a fix for this, thanks for the feedback.

[mawagi7]

Thanks for the fast reply and your great work.