Good morning.
I have a simple, but a big problem. We have a project that use the Infragistcs V6.2 and we are using the Excell classes to export a simple GridView to a .xls file.
However, the problem is that we need to mix diferent font colors (black and red) in the same cell.
So, I have no idea about how to do this???
Can you post the code where you are using excel classes
Today we use a simple merged cell and set the value property like this:
Worksheet mySheet; // This is the class where I refer my worksheet WorksheetMergedCellsRegion mergedCell = null;mergedCell = abaPrincipal.MergedCellsRegions.Add(10 , 0 , 10, 10);mergedCell.Value = content;
Worksheet mySheet; // This is the class where I refer my worksheet
I want to make this content a mix between red and black font-color. Thats it
Note: I'm using a old version off Infragistcs (2006 V2)
Thanks a lot
try this,
mergedCell.CellFormat.FillPattern = FillPatternStyle.DiagonalCrosshatch;mergedCell.CellFormat.FillPatternForegroundColor = Color.Lavender;mergedCell.CellFormat.FillPatternBackgroundColor = Color.LightPink;