Align with page margins

[p.meertens]

Hi,

In Excel 2016 there is a feature on the header/footer section to Allign the header/foother with the page margins. This is default active (checked) if you create a new excel. However when i create a xls with Spire, then it is not active.

My question: How can i activate the "Align with parge margins" option"?

Kind regards,
Perry

[Nina.Tang]

Dear Perry,

Thanks for your inquiry.
I did notice the behavior while testing your case with our free version, sorry that we have no plan to maintain free version at present. I have confirmd the issue doesn't exist in our commercial version (Spire.XLS Pack(Hotfix) Version:8.8.1), please upgrade to the commercial one to have a try. And to help you better evaluate our commercial version, we could offer 1-month free license to you. If interested, please contact our sales team (sales@e-iceblue.com) to get it.

Sincerely,
Nina
E-iceblue support team

[Nina.Tang]

Dear Perry,

Greetings from E-iceblue.
Has your issue been resolved?
Thanks in advance for your valuable feedback and time.

Sincerely,
Nina
E-iceblue support team

[p.meertens]

Hi Nina,

Thanx for your reply. However you did not answere my question completely: How can i activate the "Align with page margins" option"? I now have a new version but still don't know what code to use to activate or deactivate this option.

Hope to hear from you.
Perry

[Nina.Tang]

Dear Perry,

Thanks for your feedback.
Please use below code to deactivate the option.

Code: Select all

Worksheet sheet = wb.Worksheets[0];
//Deactivate the "Align With Page Margins" option. Please note its default value is 1.
sheet.PageSetup.AlignWithMargins = 0;

Sincerely,
Nina
E-iceblue support team

[Nina.Tang]

Hi,

Greetings from E-iceblue.
Has your issue been fixed?
Thanks in advance for your valuable feedback and time.

Sincerely,
Nina
E-iceblue support team