Date:         Wed, 9 Jan 2008 19:21:45 -0800
Reply-To:     JH <jenharper52@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         JH <jenharper52@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Tagsets.ExcelXP - bold PART of a cell?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

In Excel it is possible to bold part of the text in a cell.  How can
we do that using SAS?

Below is some code I've been playing with.  I've inserted <B> and </B>
and it doesn't work - They just disappear.

(Notes: the compress fxn is so that I can write spaces in for
readability, but they aren't passed out; &#10 forces a line break
within a cell when I have protectspecialchars=off)

Help?!  Thanks, Jen



proc template;
        define style styles.test;
        parent=styles.egdefault;
        replace Document from Container /
                protectspecialchars = off;
        end;
run;

data testdata; set sashelp.class;
        thiswraps=compress("boldtext &#10 normtext");
        isthisbold=compress("<B> boldtext </B> &#10 normtext");
run;

ods tagsets.excelxp file='filename.xls' style=styles.test
        options( autofit_height='yes');
        proc print noobs;  var thiswraps isthisbold; run;
ods tagsets.excelxp close;