Page 1 of 1

Changes in ExcelColorPalette has no behaviour

Posted: Wed Dec 07, 2011 12:25 pm
by vabene
In Delphi 2007 i tried to change colors in BIFFRecsII4.ExcelColorPalette, but it has no behavour in Using the Cell Colors. They are alwas the default values. Is there a bug, or what i'm doing wrong?

Example:
1)
ExcelColorPalette[24] := $FF0000;
Sheets[0].AsString[0,0] := 'X';
Sheets[0].Cell[0,0].FillPatternForeColor := TExcelColor(24); //-- no change behavour
2)
ExcelColorPalette[24] := $FF0000;
Sheets[0].AsString[0,0] := 'X';
Sheets[0].Cell[0,0].FillPatternForeColor := xc24; //-- no change behavour
3)
Palette[24] := $FF0000; //-- of TXLSReadWriteII4-Instance
Sheets[0].AsString[0,0] := 'X';
Sheets[0].Cell[0,0].FillPatternForeColor := xc24; //-- no change behavour

There are alwas shown the standard colours and not the red one i want to have.
By the way: I know that there is a standard value xcRed, but i want to have a special RGB-Value($95B7C7).

Re: Changes in ExcelColorPalette has no behaviour

Posted: Mon Jun 11, 2012 7:20 am
by Xin Ruan
How do you resolve it, I come to the same problem?

Re: Changes in ExcelColorPalette has no behaviour

Posted: Mon Jun 11, 2012 1:42 pm
by larsa
Hello

Changing the color palette has no effect in excel 2007 files. This will be fixed in the next version.