We are facing a issue with Aspose.cells. When we set the cell color to a cell, the number format is getting lost. Can you please suggest how we can resolve this. We are using the below code.
eg: suppose the cell had a value 123.000 before applying color, after the color is applied it will become 123 (decinmal part is getting lost)
Dim cellStyle As Aspose.Cells.Style
Dim cellStyleFlag As New Aspose.Cells.StyleFlag
cellStyle = cell.Worksheet.Workbook.Styles(cell.Worksheet.Workbook.Styles.Add())
cellStyle.ForegroundColor = System.Drawing.ColorTranslator.FromHtml(colorCode)
cellStyle.Pattern = BackgroundType.Solid
cellStyleFlag.CellShading = True