Bottom page break position after CopySheet

[JunTakaba]

At first, I use attached sheet ("Before.png").

The point is that string "Test" in line 13 and out of printing area.
(Last row break position is in line 11.)

Next, I copy it by using "CopySheet" and result is "AfterCopy.png".
so Last row break position change from line 11 to 13.

Similarly Print Title is not working properly after CopySheet.
After CopySheet, print title disappear.

Before CopySheet

After CopySheet

I dont't want to change row break position and print title.
Could you please teach me if you have any idea to resolve this issue.

• The NPOI version is 2.4.1

Best Regards,
Jun

[tonyqus]

Can you upgrade to the latest version of NPOI and test if there is a difference? I remember a few bugs are fixed for CopySheet.

[JunTakaba]

I checked this issue by using NPOI 2.5.6 and result are same as before (I could reproduce these issues with NPOI 2.5.6).

[tonyqus]

And if possible, please upload your Excel file.

[JunTakaba]

I attached excel file for debugging.

Test.xlsx