title: GemBox Spreadsheet : Multiple font colors in one cell
body: <p>I'm exporting data using GemBox Spreadsheet and I need to format the text in a cell to have multiple colors.</p>
  
  <p>This is possible in Excel like this (found on StackOverflow):</p>
  
  <pre class="lang-vb prettyprint-override"><code>Dim fixedLength As Long
  fixedLength = Len("Employee")
  ActiveCell.FormulaR1C1 = "Employee Some Employee"
  With ActiveCell.Characters(Start:=fixedLength + 2, Length:=Len(ActiveCell) - FixedLength - 1).Font
      .Color = vbRed
  End With
  </code></pre>
  
  <p>However, all I can find in the GemBox class is to set the Style.Font.Color property and this affects the entire cell.<br>
  Example:</p>
  
  <pre class="lang-cs prettyprint-override"><code>for (int i = 0; i &lt; tempArray.GetUpperBound(0); i++)
  {
      Color backColour = ColorTranslator.FromHtml(tempArray[i+1]);
      ws.Cells[row, col].Value += tempArray[i] + Environment.NewLine;
      ws.Cells[row, col].Style.Font.Color = backColour;
      i++;
  }
  </code></pre>
  
  <p>Is this possible with GemBox?</p>
  
  <p>GemBox Spreadsheet Professional 3.5 for .NET 4.0<br>
  v4.0.30319<br>
  v35.3.40.1000</p>