Asked on February 10, 2011 11:28 AM
I'm trying to clear the color from a cell in an existing Excel file, and I can't find a way to do it without setting the cell background to white, which isn't the same as selecting no fill from the Excel fill color menu. I've tried the following:
sheet[rowIndex, colIndex].CellStyle.Interior.Color = Color.Empty;
sheet[rowIndex, colIndex].CellStyle.Interior.ColorIndex = ExcelKnownColors.None;
Both result in the cell appearing black, but, if I select the cell, No fill seems to be selected in the fill menu (see attached). Reselecting No fill clears the color from the cell.
Is there something I'm missing?cell color sample_b31f6f4a.zip