Desktop productivity for business analysts and programmers

Hiding footnote using ods tagsets.excelxp

Accepted Solution Solved
Reply
Contributor
Posts: 30
Accepted Solution

Hiding footnote using ods tagsets.excelxp

how do i hide footnote from showing up in excel attachment.  


Accepted Solutions
Solution
‎02-20-2018 01:43 PM
Super User
Posts: 22,843

Re: Hiding footnote using ods tagsets.excelxp

So you want a footer but not displayed?

If you don't want it, use the following to clear the footnote entirely.

 

footnote;

Otherwise, you can try the following in your ODS TAGSETS.EXCELXP option which will place it in the footer, so not visible when you open the file, but will be included on prints. This should be the default. 

 

embedded_footnotes='No'

Or you can use Hidden_Columns by specifying the range to hide, or set row_heights to a really low value so it appears hidden. Both of those last options require you to know where the footer will end up in the final report. 

 

I can't think of another approach at the moment.

 

View solution in original post


All Replies
Super User
Posts: 22,843

Re: Hiding footnote using ods tagsets.excelxp

Are you trying to hide the cell, or have it embedded in the footer?

Contributor
Posts: 30

Re: Hiding footnote using ods tagsets.excelxp

Im trying to hide it so it  doesn't show in the excel file 

Solution
‎02-20-2018 01:43 PM
Super User
Posts: 22,843

Re: Hiding footnote using ods tagsets.excelxp

So you want a footer but not displayed?

If you don't want it, use the following to clear the footnote entirely.

 

footnote;

Otherwise, you can try the following in your ODS TAGSETS.EXCELXP option which will place it in the footer, so not visible when you open the file, but will be included on prints. This should be the default. 

 

embedded_footnotes='No'

Or you can use Hidden_Columns by specifying the range to hide, or set row_heights to a really low value so it appears hidden. Both of those last options require you to know where the footer will end up in the final report. 

 

I can't think of another approach at the moment.

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 105 views
  • 0 likes
  • 2 in conversation