Foreground Color Not Working Anymore (Breaking change)

Aspose.Cells Product Family
1

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)

2

@billrob

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

C#

//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.

3

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

4

@billrob

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.