title: OpenXML having trouble coloring cells
body: <p>I am attempting to style cells and I cant get the colors to work correctly, I am using the following Fill:</p>
  
  <pre><code>// &lt;Fills&gt;
  Fill fill0 = new Fill();        // Default fill
  Fill fill1 = new Fill(
      new PatternFill(
          new ForegroundColor() { Rgb = new HexBinaryValue() { Value = "DCDCDC" } }
      )
      { PatternType = PatternValues.Solid });
  
  Fills fills = new Fills();      // appending fills
  fills.Append(fill0);
  fills.Append(fill1);
  
  CellFormat _0_default = new CellFormat() { FontId = 0, FillId = 0, BorderId = 0 }; // Default style : Mandatory | Style ID =0
  CellFormat _1_header = new CellFormat() { FontId = 1, FillId = 1, ApplyFill = true }; //HEADER
  
  CellFormats cellformats = new CellFormats();
  cellformats.Append(_0_default);
  cellformats.Append(_1_header);
  </code></pre>
  
  <p>These are my only styles, and that is my only fill - I set the first row to <strong>StyleIndex = 1</strong></p>
  
  <p>Also, it doesn't seem to matter what I make the BackgroundColor or if I omit it completely.</p>
  
  <p>From this link: <a href="https://blogs.msdn.microsoft.com/chrisquon/2009/11/30/stylizing-your-excel-worksheets-with-open-xml-2-0/" rel="noreferrer">https://blogs.msdn.microsoft.com/chrisquon/2009/11/30/stylizing-your-excel-worksheets-with-open-xml-2-0/</a></p>
  
  <p>But the problem is that my cells now look like this: </p>
  
  <p><a href="https://i.stack.imgur.com/AnrHt.png" rel="noreferrer"><img src="https://i.stack.imgur.com/AnrHt.png" alt="bad pattern"></a></p>
  
  <p>Which you can see is not the gray that it should be - any idea what I am missing?  Thank you.</p>