ClearHeaderFooter does not clear FirstPage or Even Headers & Footers

Aspose.Cells Product Family
1

Hello,

I’m assuming this is by design that the PageSetup method ClearHeaderFooter only clears the base header and footer, and not FIrstPageHeader, FirstPageFooter, EvenPageHeader and EvenPageFooter?

It’s easy enough to write the extra code, but a ClearAllHeaderAndFooters would be awesome.
Thanks,

Sheri

2

@sheri_steeves,

I think you may cope with it by adding the line(s) of code before calling ClearHeaderFooter method:
e.g
Sample code:

.........
    worksheet.PageSetup.IsHFDiffFirst = false;
    worksheet.PageSetup.IsHFDiffOddEven = false;

Hope, this helps a bit.

3

@Amjad_Sahi,

Thanks, I did find that changing those settings to false gave me the output I was looking for.

4

@sheri_steeves,

Good to know that your issue is sorted out by the suggested lines of code. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.