Please enable JavaScript to view this site.

Written November 2019

//XL, AddFootnote, {text=} text {,title=text}

AddFootnote provides a convenient way to create footnotes in your spreadsheet. Footnotes are useful for providing explanatory details about how the data in the spreadsheet was compiled.

AddFootnote can appear multiple times anywhere in the file. Each instance of adds a footnote to the bottom of the current sheet. If no title is specified, the default title "Footnotes:" will be used. For example,

//XL,AddFootnote,1) This is footnote #1

//XL,AddFootnote,"2) Data source: Manny, Moe and Jack"

The above pair of directives would cause the following to be added to the bottom of the current sheet, below any totals:

+ Footnotes:

The actual footnotes are collapsed within the group; clicking the "+" will expand them to show:

Footnotes:

1) This is footnote #1

2) Data source: Manny, Moe and Jack

 

Notes

Footnotes will appear in the order the corresponding directives appear.
There is no automatic formatting or numbering; you will need to supply your own.
Make sure to quote the footnote in the directive if it contains commas.

History

2019 November, CSV2XL.SBX edit 241, first included with A-Shell 6.5.1671:  Function added to A-Shell.

Created with Help+Manual 9 and styled with Premium Pack Version 5 © by EC Software