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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.