Date: Wed, 29 Sep 2010 14:18:30 -0400
Reply-To: Philip C <SASL.PhilipC@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Philip C <SASL.PhilipC@GMAIL.COM>
Subject: Tagset Excelxp v1.116 or Style sasdocprinter
I'm using a new version of the ExcelXP tagset and I'm finding some issues.
One which I can replicate with an example is a bug(maybe) where all the
verticle borders between the cells in each By-Line rows of the sheet are
not colored white as they are in the other rows of the spreadsheet, and as
they were when I used Excelxp v1.94(the last version I used before v1.116).
Any suggestions or advice of how to instruct v.1.116 to behave like v1.94
with respect to this? Thanks.
(Couldn't find a SAS Problem Note nor any other mention on the web. )
Sample code:
title;footnote;
options nocenter;
ods listing close;
ODS tagsets.excelxp /*testing with on excelxp v1.116 */
body="test.xls"
style=sasdocprinter
options( sheet_interval='none' ) ;
proc print noobs data=sample;
BY letter;
var number j_counter i_counter;
run;
ODS tagsets.excelxp close;