The SAS Output Delivery System and reporting techniques

ODS Excel (xlsx) Issue with borders in title (bug?)

Reply
New Contributor
Posts: 2

ODS Excel (xlsx) Issue with borders in title (bug?)

[ Edited ]

Hello,

In ODS Excel the borders of the title are not displayed properly across the entire merged cells:

ods_excel.PNG

 

In ODS Tagset.ExcelXP it works without problems:ods_tagset.PNG


Sample Code:

proc template;
	define style title_test;
		parent=styles.HTMLBlue;
		class SystemTitle /
			background=pink 
			bordercolor = black
			borderstyle = solid 
			borderbottomcolor=aquamarine 
			borderbottomwidth=4
		;
	end;
run;

ods tagsets.excelxp(i) file="test_tagset_excelxp.xls" 
	style=title_test
options(
		sheet_interval = 'none'
		sheet_name='test'
		sheet_label = ' '
		embedded_titles = 'yes'
		suppress_bylines = 'yes'
		Merge_Titles_Footnotes='yes'
	);

title "Title in ODS Tagset ExcelXP Output";

proc print data=sashelp.cars(obs= 20); run;

ods _all_ close;

ods excel file='test_ods_excel.xlsx'
	style=title_test
	options(
		sheet_interval = 'none'
		sheet_name='test'
		sheet_label = ' '
		embedded_titles = 'yes'
		suppress_bylines = 'yes'
	);
ods escapechar='^';

title1 "Title in ODS Excel Output";

proc print data=sashelp.cars(obs= 20); run;

ods _all_ close;

 

Why? Is this a known issue? Any solutions?


Many thanks!

Grand Advisor
Posts: 16,267

Re: ODS Excel (xlsx) Issue with borders in title (bug?)

What is your SAS version?

New Contributor
Posts: 2

Re: ODS Excel (xlsx) Issue with borders in title (bug?)

SAS Enterprise Guide: 7.11 HF5 (7.100.1.2856) (32-Bit)

 

SAS Server: 9.04.01  / Linux

SAS Super FREQ
Posts: 8,641

Re: ODS Excel (xlsx) Issue with borders in title (bug?)

Since you have code that produces different results for each destination, this is the kind of issue you should report to Tech Support -- they can tell you whether this is a known issue or refer the question to the developers.

cynthia
SAS Super FREQ
Posts: 8,641

Re: ODS Excel (xlsx) Issue with borders in title (bug?)

Hi:

  Posting an updated example. From SAS Tech Support, there is a known defect about this behavior. The workaround is shown below, in a STYLE template change.

cynthia

workaround_title_border_ods_excel.png

Post a Question
Discussion Stats
  • 4 replies
  • 197 views
  • 0 likes
  • 3 in conversation