Focal Point
Styling data rows in exl2k using alternate colors
July 03, 2007, 11:19 AM
Lou DeTotaStyling data rows in exl2k using alternate colors
I am trying to produce an excel spreadsheet with alternating white and silver rows for the data. The following works fine in WebFOCUS DevStudio but not in FOCUS for OS 390. No error, just gets ignored.
BACKCOLOR=( 'WHITE' 'SILVER' ),
I cannot seem to specify more than one color. Does anyone know if there a workaround for this ?
Thanks,
Lou
WF 7.6.11 PDF deployment, z/OS, WAS, Excel, PDF, HTML. FOCUS 7.6.11, same outputs.
July 03, 2007, 11:33 AM
Tony ALou,
What versions are you using on the different platforms? Depending upon the version on OS390 that styling might be avaiable?
Also, please update your signature so that we can clearly identify them when you ask questions.
T
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | | |
WebFOCUS App Studio 8.2.06 standalone on Windows 10 | |
July 03, 2007, 11:39 AM
Francis MarianiDoesn't work on Windows, AIX and DevStudio WebFOCUS 5.3.2.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 03, 2007, 02:54 PM
Lou DeTotaI am using Win2K / DevStudio 7.1.7 where it works as posted. To get it to work on OS 390 the following was needed:
DEFINE FILE INFILE
CNTR/I2 =IF LAST CNT EQ 1 THEN 0 ELSE 1;
END
TABLE FILE INFILE
PRINT ... ... ... CNTR NOPRINT
...
...
TYPE=DATA,
JUSTIFY=CENTER,
BACKCOLOR=SILVER, WHEN=CNTR EQ 0,
$
TYPE=DATA,
JUSTIFY=CENTER,
BACKCOLOR=WHITE, WHEN=CNTR EQ 1,
$
WF 7.6.11 PDF deployment, z/OS, WAS, Excel, PDF, HTML. FOCUS 7.6.11, same outputs.