ChangePalette problem - black cells


Using version of Aspose.Excel.

I'm using the ChangePalette call to add my own colours - and am then applying the colours using

mysheet.Cells(row, col).Style.Pattern = BackgroundType.Solid
mysheet.Cells(row, col).Style.ForegroundColor = myColour

I've put debug into my code to double check the colours I'm adding to the palette are the colours I'm using

Adding Color : Color [A=255, R=255, G=242, B=242]
Using Color : Color [A=255, R=255, G=242, B=242]

but when I download the cells are black! I'm building my palette before creating any sheets - though the ordering doesn't seem to make any difference.

Any ideas?



Have you tried our latest hotfix? I haven’t found the problem in my machine.

If the problem still exists in your place, please zip your code and send to me by email. Thank you.