I wanted to thank you for that link to the excel colors. It was exactly what
I was looking for - just the basics are good enough for me.

Ruth

"sto" wrote:

Hi to all,

I have a very strange problems with colors.

I have a program that does some database reports and brings those report to
the user. Then the user can print and export to excel /using 3rd party
components/. Everything is going ok, except when using custom colors for the
grid background.
Then some odd colors are used when the report is opened with Excel, not the
colors I defined.

I searched the newsgroups and found out that there is a DefaultColorPalete
thing.
Then I found:
http://www.mvps.org/dmcritchie/excel/colors.htm

I tested with this color list, it seems only the first 8 colors are ok,
while the next 8 are not.
Here is the list I used (from the link above):
$000000,$FFFFFF ,$FF0000 ,$00FF00,$0000FF, $FFFF00, $FF00FF,$00FFFF,
$800000,$008000,$000080,$808000,$800080,$008080,$C 0C0C0,$808080);

I used Excel97 and 2003 for testing - same strange results for both.

Any suggestion? Please!