Page breaking at different point as compared to excel

Hi team,



For the attached file as per excel the last word treatment should print in the same file. However, when ever we print it to pdf using aspose half of the last word prints to the next page.



Regards,

Hi Nicole,


Thank you for contacting Aspose support.

We have evaluated your presented scenario on our end, and we believe the behavior is correct for rendering your spreadsheet in PDF format. Reason being, half of the word “treatment.” is beyond the printing scope of first PDF page. Please check the attached snapshot of MS Excel showing the vertical page break splitting the aforesaid word between column K & L. If you wish to print the line completely on one page of the PDF, you may use the PdfSaveOptions.OnePagePerSheet property to forcefully print all contents of the worksheet on one page of the PDF. Alternatively, you can tweak the PageSetup properties to minimize the right & left margins to get more printing space. You can also set the text to wrap using Style class without changing any other configurations in your code.

Please feel free to write back in case you have any concerns or questions.