On the "Headers and Footers Tab" page of the Documentation, it says this:
There is no option to turn on/off the "Different odd and even pages" or "Different first page". This is because ClosedXML always uses all headers even if it leaves them blank.
Is there a reason it was designed this way? The Excel default is to have headers/footers the same on all pages (i.e. "Different odd and even pages" and "Different first page" are unchecked).
Unfortunately, my users are getting confused because they expect to change the header/footer on the first page, and have those changes apply to the rest of the document, but the changes only apply to the first page. Instead, I have to tell them to:
a) uncheck those two boxes, or b) make the same changes to the first three pages of the document.
I'll soon be trying to fix this myself with OpenXML, but first I wanted to ask if it could be included in ClosedXML.
Thanks for all your hard work,