excelxp title width defining

Reply
Occasional Contributor
Posts: 14

excelxp title width defining

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'

        embedded_titles='yes'

        embedded_footnotes='yes'

        merge_titles_footnotes = 'yes'

        sheet_name= &sheet

        width_points='1'

        width_fudge='1'

        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?

SAS Super FREQ
Posts: 8,743

Re: excelxp title width defining

Hi:

  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.

cynthia

Frequent Contributor
Posts: 117

Re: excelxp title width defining

when you define next macro , clear titles and footnotes an then give titles an footnotes.

title;

footnote;

title1 "...........";

footnote1 "............";

i didnt test it....

Occasional Contributor
Posts: 14

Re: excelxp title width defining

Tried this but did make a difference, thank you for the idea though.

Occasional Contributor
Posts: 14

Re: excelxp title width defining

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.

Occasional Contributor
Posts: 14

Re: excelxp title width defining

After updating to newest tagsets this was not an issue anymore.

Ask a Question
Discussion stats
  • 5 replies
  • 286 views
  • 0 likes
  • 3 in conversation