02-21-2015 02:27 PM
I am creating a multi sheet report using 4 macros and proc tabulate. each time a macro is called, i define my options, for example
ods tagsets.excelxp options
center_horizontal = 'yes'
center_vertical = 'yes'
merge_titles_footnotes = 'yes'
absolute_column_width = '80,125,50,50,50,50,50,30,30,30,30,30,30,30,30,30'
row_heights = '50,17,20,15,12,10'
title1 justify=center bold color=grey font=arial height=10pt &title1;
title2 justify=center bold color=grey font=arial height=10pt &title2;
title3 justify=center bold color=grey font=arial height=10pt &title3;
footnote justify=left bold color=grey font=arial height=8pt &source;
this creates my first sheet, summary. it goes to column F.
every sheet after that has the titles and footnotes also set to only go to column F, not however wide that particular table is. Is there a way to have the titles and footnotes be defined for the particular table on the sheet, not just whatever the first sheets width was?
02-21-2015 07:55 PM
This is really a question for Tech Support. Normally, titles and footnotes go in the header/footer of the sheet, where they are bound to margins and orientation of the printed sheet. When you embed the titles and footnotes, they have to be tied to something, so making them fit the width of the table seems to be the decision. But to get hellp to figure out whether you can change the behavior is really a question for Tech Support.
02-22-2015 08:44 AM
when you define next macro , clear titles and footnotes an then give titles an footnotes.
i didnt test it....
02-22-2015 11:18 AM
To make this potentially even more confusing, when results are output to browser (firefox in this instance), the alignment is as coded, only in excel is one particular title aligned left.