I am using ODS EXCEL to create two tabs on a single Excel file. I have the exact same options for both tabs, but on the first one, the TITLE_FOOTNOTE_NOBREAK doesn't seem to work. That is, my Title statements are wrapping and can only be revealed in total when I go into the Excel file and click Wrap Text to disable it. Here is the code I'm using for the Options: ODS EXCEL FILE = "TITLE_FOOTNOTE_NOBREAK sample.xlsx" OPTIONS (EMBEDDED_TITLES='YES' EMBED_TITLES_ONCE= 'YES' EMBEDDED_FOOTNOTES = 'YES' START_AT='A1' GRIDLINES='ON' TITLE_FOOTNOTE_NOBREAK='YES' SHEET_NAME = 'DED' SHEET_INTERVAL='NONE' ABSOLUTE_COLUMN_WIDTH = '15,50,15,15,15,25,10,15.2,15.2,15' ); TITLE J=L 'Customer Segment Number: ' &FIRST_POLICY_GALAXY.; TITLE2 J=L 'Customer Name: ' &CUST_NAME.; TITLE3 J=L 'Service Date: ' &FIRSTSERV. ' - ' &LASTSERV.; TITLE4 J=L 'Process Date: ' &FIRSTSERV. ' - ' &LASTPROC.; TITLE5 J=L ' '; This is the one where the Titles wrap. Here is the Options statement for the second tab: ODS EXCEL OPTIONS (EMBEDDED_TITLES='YES' EMBED_TITLES_ONCE= 'YES' EMBEDDED_FOOTNOTES = 'YES' START_AT='A1' GRIDLINES='ON' TITLE_FOOTNOTE_NOBREAK='YES' SHEET_NAME = 'OOP' SHEET_INTERVAL='NONE' ABSOLUTE_COLUMN_WIDTH = '15,50,15,15,15,25,10,15.2,15.2,15' ); TITLE J=L 'Customer Segment Number: ' &FIRST_POLICY_GALAXY.; TITLE2 J=L 'Customer Name: ' &CUST_NAME.; TITLE3 J=L 'Service Date: ' &FIRSTSERV. ' - ' &LASTSERV.; TITLE4 J=L 'Process Date: ' &FIRSTSERV. ' - ' &LASTPROC.; TITLE5 J=L ' '; I've attached the Excel file without any data. Any suggestions?
... View more
