We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Foreground Color Not Working Anymore (Breaking change)

We were using version 8.1.2 of Aspose and when inserting a Range of cells based on a templateRow it was maintaining the Foreground color.

cells.InsertRange(CellArea.CreateCellArea(templateRow, column, templateRow, column), 10, ShiftType.Down, true);

Now when using 17.9 of Aspose.Cells it keeps the color, but sets the alpha at 255, thus erasing the color.

I have studio solutions showing both as I have done in the past.

GoodForecolorBehavior.zip (18.2 KB)
BadForecolorBehavior.zip (18.5 KB)


Please modify your code like the following if you want to apply color to A2:A12.


//Modify your line to this line
cells.InsertRange(CellArea.CreateCellArea(templateRow, column, templateRow + 10, column), ShiftType.Down);`

It should fix your issue. Let us know your feedback.

Thanks, that worked. It is still doing something different with the Alpha component, but visually the users can’t tell.


Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is sorted out now. Let us know if you encounter any other issue, we will be glad to look into it and help you further.