I am wondering if you could please help me - I am going crazy over this... I am using Aspose.Cells, and I want to set 3 different CUSTOM background colours in my Excel spreadsheet.
excel.Styles.ForegroundColor = ColorTranslator.FromHtml("#CCCC99");
Something strange seems to be happening (prehaps I do not fully understand how to use the ChangePalette). As far as I am aware the Palette needs to be reset every time you change the colour. Can you set multiple custom background colours on one Excel spreadsheet and how do u reset the palette each time? I seem to always get one or more of the colours overriding the other colours.