Search code examples
excelfontsspreadsheetgembox-spreadsheet

GemBox Spreadsheet : Multiple font colors in one cell


I'm exporting data using GemBox Spreadsheet and I need to format the text in a cell to have multiple colors.

This is possible in Excel like this (found on StackOverflow):

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

However, all I can find in the GemBox class is to set the Style.Font.Color property and this affects the entire cell.
Example:

for (int i = 0; i < 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++;
}

Is this possible with GemBox?

GemBox Spreadsheet Professional 3.5 for .NET 4.0
v4.0.30319
v35.3.40.1000


Solution

  • I know this question is old, but I asked the developers via email a few years ago. They said this was not available.

    If you email them directly, they usually respond within one business day. I think they are in the Czech Republic.

    You can open a support ticket to them here.

    There is also a feedback tab on that same page where you can suggest they add this as a feature and other devs can vote on features to add.