[CASE-OPENED] SMTP EXL2K File - Missing Stylesheet Effects.

SET COMPOUND=BYTOC
-RUN
TABLE FILE CAR
"Car Report"
"Country: <COUNTRY"
PRINT SALES
BY    COUNTRY
BY    CAR
ON TABLE HOLD AS CAROUT FORMAT EXL2K
ON TABLE SET STYLE *
 TYPE=HEADING, STYLE=BOLD, COLOR=RED, BACKCOLOR=RGB(255 255 204),$
 TYPE=TITLE,   STYLE=BOLD, COLOR=RED, BACKCOLOR=RGB(255 255 204),$
ENDSTYLE
END

When I FTP the file down to the LAN, and then open it in Excel, I see the content and formatting A-OK.

When I email the file as an attachment, open the attachment in Excel, I see the content, but I do not see the formatting. That is, I do not see the results of the stylesheet commands.

Upon review of the EXL2K file I see CSS code like the following:

.xl102
        {mso-style-parent:style0;
        color:#FF0000;
        font-size:10.0pt;
        font-weight:700;
        font-family:"ARIAL";
        background:#FFFFCC;
        mso-pattern:auto none;
        white-space:normal;
        mso-font-charset:0;}

In SMTP, the '.' at a beginning of a line is a way to terminate a command.

I MANUALLY EDITED the EXL2K mainframe file and added a period, for every class:

..xl102
        {mso-style-parent:style0;
        color:#FF0000;
        font-size:10.0pt;
        font-weight:700;
        font-family:"ARIAL";
        background:#FFFFCC;
        mso-pattern:auto none;
        white-space:normal;
        mso-font-charset:0;}

The second '.' acts as an escape for the first one.

I then sent the edited file, through SMTP.

When I opened the EXL2K attachment, I saw the stylesheet results A-OK.

Does anyone know of a workaround for this scenario, or perhaps I am missing something?

I imagine I could post-process the file, but I would prefer not to, if possible.

I have a case open with IB on this scenario, but I thought I would try the Forum as well.

Thanks,
Dave

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

Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster