This morning I installed Aspose.Cells 3.7.2. I've changed the namespace on my page (using .NET) and any references to Aspose.Excel. Now anywhere I'm setting the foreground color does not work. It shows as white.
Here is my code:
If Not Excel.IsColorInPalette(Color.LightGray) Then
Excel.ChangePalette(Color.LightGray, 55)
End If
If Not Excel.IsColorInPalette(Color.LightBlue) Then
Excel.ChangePalette(Color.LightBlue, 54)
End If
intStyleIndex = Excel.Styles.Add()
style = Excel.Styles(intStyleIndex)
style.Font.Name = "Arial"
style.Font.Size = 8
style.Number = 3
style.HorizontalAlignment = TextAlignmentType.Right
style.Borders(BorderType.TopBorder).LineStyle = CellBorderType.Thin
style.Borders(BorderType.BottomBorder).LineStyle = CellBorderType.Thin
style.Borders(BorderType.LeftBorder).LineStyle = CellBorderType.Thin
style.Borders(BorderType.RightBorder).LineStyle = CellBorderType.Thin
style.ForegroundColor = Color.LightBlue
style.Name = "DataStyleBlue"
........
SARCells(intRow, CType((intNextCol), Byte)).Style = SARExcel.Styles("DataStyleBlue")