Hi,
I am currently using ods excelxp to create an excel workbook, but I only want footnotes on the sheets where I actually define footnotes. below is an example of two sheets.
ODS TAGSETS.EXCELXP
OPTIONS ( Orientation = 'portrait'
FitToPage = 'yes'
sheet_interval = 'none'
sheet_name = 'Sheet X'
Embedded_Titles = 'yes' Embedded_Footnotes = 'yes'
autofit_height = 'yes'
Absolute_Column_Width = '12,15,9,9,9,9'
);
ODS TAGSETS.EXCELXP
OPTIONS ( Orientation = 'portrait'
FitToPage = 'yes'
sheet_interval = 'none'
sheet_name = 'Sheet Y'
Embedded_Titles = 'yes'
Embedded_Footnotes = 'off'
autofit_height = 'yes'
Absolute_Column_Width = '10,10,30,5,9,9,9,9,9,9'
);
In Sheet X, I define footnotes 1-7. In Sheet Y, i don't define any footnotes yet they still appear when I try to print may workbook in Excel. I turned off the embedded_footnotes option but it doesn't seem to work.
It doesn't bother me that much, but when I open Excel, it gives me an error "Problems During Load" and when I follow the directory to see the warning, it tells me:
XML Spreadsheet Warning in Worksheet Setting
REASON: String too long
ACTION: Truncating string
FILE: XXX
GROUP: PageSetup
TAG: Footer
ATTRIB: Data
VALUE: YYYYYYYYYYYYY.
Therefore, I think the warning is caused by footnotes and that is why I am trying to remove footnotes when unnecessary.
This code has been working fine for months, only now do I get the "Problem During Load" warning.
Thanks
In SAS titles and footnotes persist until you reassign or clear them explicitly.
You can clear them via:
title;
footnote;
Regarding the embedded_footnotes - check if you have the latest version of the tagsets.
Thank you, I will clear them explicitly.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.