I want this EXL2K to display the '+' in GREEN
and the '-' in RED colors.

I also would like the symbols to be centered in the column.
-*
DEFINE FILE CP_INDCMB
XPOL/A1 = DECODE INDICATOR ('ANECOMPUH' '-' 'ANECOMPUHP' '-' 'ANECOMPUI' '-' 'ANECOMPUNV' '-' 'ANECOMPUT' '-'
'READMITS' '-' 'CLAIMSSUIT' '-'
'HANDWSHING' '+' 'PRCUSTCOMP' '+' 'PTSATFTION' '+'
ELSE ' ');
CHF-RPT/A1 = ' ';
-*POLARITY/A1 = ' ';
STDDEV/A1 = ' ';
COLOR/A1 = ' ';
END
-*
TABLE FILE CP_INDCMB
ON TABLE SUBHEAD
"Doctor Measurement Indicators"
" "
PRINT
-*INDICATOR
IDESCRIPTION
ISHORT
ISOURCE
-*
CHF-RPT
XPOL AS POLARITY
STDDEV
COLOR
-*
-*IALTDESC1 AS 'IAD1'
-*IALTDESC2 AS 'IAD2'
-*IALTDESC3 AS 'IAD3'
-*IALTDESC4 AS 'IAD4'
-*IGROUP
BY GROUP SKIP-LINE
BY INDICATOR
-*
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE,$
TYPE=TITLE, COLUMN=GROUP, JUSTIFY=LEFT, style=BOLD, COLOR=BLUE, $
TYPE=TITLE, JUSTIFY=LEFT, STYLE=BOLD, COLOR=RED, $
TYPE=REPORT,
GRID=ON,
FONT='ARIAL',
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N1,
FONT='TIMES NEW ROMAN',
SIZE=10,
STYLE=BOLD+ITALIC,
JUSTIFY=CENTER,
COLOR=RGB(51 51 153),
$
TYPE=DATA,
COLOR=RED,
COLUMN=XPOL,
WHEN=XPOL EQ '-',
FONT='TIMES NEW ROMAN',
SIZE=10,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLOR=GREEN,
COLUMN=XPOL,
WHEN=POL EQ '+',
FONT='TIMES NEW ROMAN',
SIZE=10,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N1,
COLOR=RGB(51 51 153),
STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
COLUMN=N6,
COLOR=RGB(153 51 102),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N7,
FONT='TIMES NEW ROMAN',
SIZE=10,
JUSTIFY=CENTER,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N7,
COLOR=RGB(153 51 102),
JUSTIFY=CENTER,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N8,
COLOR=RGB(153 51 102),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N9,
COLOR=RGB(153 51 102),
STYLE=BOLD,
$
TYPE=TABHEADING,
FONT='TIMES NEW ROMAN',
SIZE=11,
STYLE=BOLD+ITALIC,
$
TYPE=TABHEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 0 0),
$
ENDSTYLE
END
-RUN
-OUTT
-EXIT

THANKS!

This message has been edited. Last edited by: Kerry,

Can you rewrite using CAR file?

Thanks,
Sayed

Thanks Sayed,

I should have posted that without using CAR FILE
in the 1st place. And, I just fussed with it in the CAR FILE and I figured it out.

Thanks!

I don't believe EXL2K recognises RGB colors. Try just using COCLOR=RED AND COLOR=GREEN.

I use RGB colors in EXL2K lots of times.

Anatess,

You might use RGB values in Excel but Excel only supports certain RGBs but will not necessarily display the true RGB representation.

For instance, run this fex for both HTML and EXL2K output and see the difference.

TABLE FILE CAR
BY COUNTRY AS 'Using RGB'
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
GRID=OFF, SIZE=9, $
TYPE=DATA, COLUMN=COUNTRY, COLOR=RGB(92 149 150), BACKCOLOR=RGB(191 201 211), $
ENDSTYLE
END

This is nothing to do with the actual colours that I've used here, but occurs with many colours. Check out Susannah's article - What is Indian Red? - that gives a break down on named colours, their RGB and Hex representations and whether Excel can show them.

T

Tony is right, you can use RGB, but Excel only supports a subset and will translate your request to the closest color. Furthermore, colors that are defined in Excel may not be the same as when passed in your stylesheet.
Try this:

DEFINE FILE CAR
HEADER1A/A16 = 'FORM: CMS-21E';
HEADER1B/A24 = 'RUN DATE:'|'&DATE';
END
 
TABLE FILE CAR
SUM 
SALES
BY COUNTRY
BY CAR
BY MODEL
BY SEATS

HEADING
"<HEADER1A<HEADER1B"

ON TABLE SET STYLE *
TYPE=HEADING, HEADALIGN=BODY, $
TYPE=HEADING,
ITEM=1,
COLSPAN=2,
$
TYPE=HEADING,
ITEM=2,
COLSPAN=3,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N1,
BACKCOLOR=GOLD,$
TYPE=DATA,
COLUMN=N2,
BACKCOLOR=TAN,
$
ENDSTYLE

ON TABLE PCHOLD FORMAT EXL2K
END

Tony, Pat, I've had the same issues.

Tried to set a shade of gray, only to find no background color at all.

It's been about a year since this thread opened and we are having similar issues with certain backcolors not coming through correctly in Excel.

Has anybody seen any differences with an upgrade to either WebFocus 7.6.9 or Excel 2007?

As information, HTML and Active Reports bring through designated back colors correctly.

Sandy,

That's because the RGB values available in HTML are only restricted by the colour settings for your system. However, Excel 2003 and earlier only supports about 32 colours, this is expanded in 2007 though.

T

yep, EXCEL 2k7 has all 16 million rgb values, but prior versions would accept whatever value you provided and then guess at the closest color it had available. Ewww its choices were sometimes quite uuuuuuugly, but funny

quote:

Ewww its choices were sometimes quite uuuuuuugly, but funny

Susannah,

You can say that again. I had a boss that like "GOLD" and "TAN" . They looked fine when he created the spreadsheet by hand. He couldn't understand why I kept changing them to various shades of blue, until I left them GOLD and TAN.

quote:

"GOLD" and "TAN"

More like Tangerine and Barbie Pink!

Note how IB only use AQUA, YELLOW, SILVER and NONE in the section on "Styling" EXCEL output!

T

"Sherbert" and "Primrose", oh stylish T

quote:

"Sherbert" and "Primrose"

I met them at the Mall in Nashville

T