topic Re: ODS Excel (xlsx) Issue with borders in title (bug?) in ODS and Base Reporting

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

optimus — Thu, 01 Dec 2016 13:19:34 GMT

Hello,

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

In ODS Tagset.ExcelXP it works without problems:

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!

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

Reeza — Thu, 01 Dec 2016 13:37:22 GMT

What is your SAS version?

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

optimus — Thu, 01 Dec 2016 14:16:52 GMT

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

SAS Server: 9.04.01 / Linux

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

Cynthia_sas — Thu, 01 Dec 2016 18:14:06 GMT

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

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

Cynthia_sas — Mon, 05 Dec 2016 18:24:22 GMT

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