Cannot Set Header FontColor Of Table To Black

[ClemensGerstung]

Do you want to request a feature or report a bug?

• Bug

Version of ClosedXML

0.91.0

What is the current behavior?

I have some data which are displayed as a standard table. If I want to set the FontColor of the Table's Header to Black the FontColor is still white. If I set the color to almost black (#FF010101 ) or some other color (e.g. XLColor.Red) it works as expected.

What is the expected behavior or new feature?

The FontColor of the Table's Header should be black.

Did this work in previous versions of our tool? Which versions?

No

Reproducibility

Code to reproduce problem:

class Data
{
  public int Property1 { get; set; }
  public int Property2 { get; set; }
  public int Property3 { get; set; }
  public int Property4 { get; set; }
  public int Property5 { get; set; }
}

class Program
{
  static List<Data> GenerateData()
  {
    List<Data> list = new List<Data>();
    Random r = new Random();
    for (int i = 0; i < 15; i++)
    {
      list.Add(new Data { Property1 = r.Next(0, 100), Property2 = r.Next(0, 100), Property3 = r.Next(0, 100), Property4 = r.Next(0, 100), Property5 = r.Next(0, 100) });
    }
    return list;
  }

  static void Main(string[] args)
  {
    var data = GenerateData();
    var typeAccessor = TypeAccessor.Create(typeof(Data));
    var path = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "test.xlsx");

    using (var workbook = new XLWorkbook(XLEventTracking.Disabled))
    {
      using (var sheet = workbook.AddWorksheet("test"))
      {
        int row = 1;
        int column = 1;

        foreach (var member in typeAccessor.GetMembers())
        {
          sheet.Cell(row, column++).Value = member.Name;
        }
        row++;

        foreach (var item in data)
        {
          column = 1;
          foreach (var member in typeAccessor.GetMembers())
          {
            sheet.Cell(row, column++).Value = typeAccessor[item, member.Name];
          }
          row++;
        }

        using (var table = sheet.Range(1, 1, row - 1, column - 1).CreateTable())
        {
          using (var rangeRow = table.HeadersRow())
          {
            rangeRow.Style.Font.FontColor = XLColor.Black;  // doesn't work
            rangeRow.Style.Font.FontColor = XLColor.FromHtml("#FF010101");  // works
            rangeRow.Style.Fill.BackgroundColor = XLColor.NoColor;
          }
        }
      }
      workbook.SaveAs(path);
    }
  }
}

[igitur]

I can't reproduce this problem. Can you try with the latest CI build at https://ci.appveyor.com/project/Pyropace/ClosedXML/branch/develop/artifacts ?

[igitur]

Sidenote: you can significantly reduce your code by using the InsertTable method:

internal class Data
{
    public int Property1 { get; set; }
    public int Property2 { get; set; }
    public int Property3 { get; set; }
    public int Property4 { get; set; }
    public int Property5 { get; set; }
}

internal class Program
{
    private static List<Data> GenerateData()
    {
        List<Data> list = new List<Data>();
        Random r = new Random();
        for (int i = 0; i < 15; i++)
        {
            list.Add(new Data { Property1 = r.Next(0, 100), Property2 = r.Next(0, 100), Property3 = r.Next(0, 100), Property4 = r.Next(0, 100), Property5 = r.Next(0, 100) });
        }
        return list;
    }

    private static void Main(string[] args)
    {
        var data = GenerateData();
        var path = "test.xlsx";

        using (var workbook = new XLWorkbook(XLEventTracking.Disabled))
        {
            var table = workbook.AddWorksheet("Sheet1").FirstCell().InsertTable(data);

            using (var rangeRow = table.HeadersRow())
            {
                rangeRow.Style.Font.FontColor = XLColor.Blue;  
                rangeRow.Style.Fill.BackgroundColor = XLColor.NoColor;
            }

            workbook.SaveAs(path);
        }
    }
}

[ClemensGerstung]

I still have the same problem, even with the latest CI build (see attached files).
Also tested this with Office 2010, 2013 and 2016 (mainly 2016) on different PCs, always the same behavior.

I'm using the "long" way because in the actual application the properties have to be exported in a special order and some may get concatenated with others (this structure is defined in an XML file). So I can't use InsertTable(...) function.

EDIT: I might use InsertTable(...) and requery the data with LINQ into a anonymous class (as you did in your sample) but this wouldn't make much difference to the actual code.

test_FF010101.xlsx
test_Black.xlsx

[igitur]

Ok, can you run my code sample as is and attach the output file that it generates?

[igitur]

PS: Thanks for the good code sample. It makes it a lot easier, even though I can't replicate the problem... yet.

[ClemensGerstung]

Your sample (looks good): test.xlsx

[ClemensGerstung]

also tested with setting the FontColor = XLColor.Black. Still same problem
test_black.xlsx

[igitur]

If I open test.xlsx I see this:

[igitur]

Ah, but if I change it to XLColor.Black, I see this. This is obviously wrong. I'll look into it.

[igitur]

Hmm, I think this is an Excel bug! Open one of those files and try setting the colour manually to black. Don't use theme colours. Use actual RGB:

If I do that, the text becomes transparent. What happens for you?

[ClemensGerstung]

I have the exact same behaviour.
Text is getting transparent if I set the color to black via RGB

[igitur]

You could try rangeRow.Style.Font.FontColor = XLColor.FromTheme(XLThemeColor.Text1);.

[ClemensGerstung]

This works, it sets the FontColor to Black (as expected).

[igitur]

Can this be closed?

[ClemensGerstung]

Yes, it's not a bug in ClosedXML.