We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Set print page width using page break

Thread ID:





99730 Jun 8,2011 02:46 AM Jun 8,2011 03:40 AM ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Marcus Olsson
Asked On June 8, 2011 02:46 AM

I'm trying to set page breaks using XlsIO so all my columns are included when printing the page.

I am trying the following, as I have seen in previous posts, but it has no effect.


The vertical page break is ignored and set after the column 'D'.
Am I missing something?

John Bowlin Bosco K [Syncfusion]
Replied On June 8, 2011 03:40 AM

Hi Marcus,

Thank you very much for your interest in Syncfusion Products.

We were unable to reproduce the issue from our end. We have created a sample and tested with dlls of version in 3.5 framework. Setting horizontal page break using ws.HPageBreaks.Add(ws.Range["A51"]); will insert the page break at row 50 and setting vertical page break using ws.HPageBreaks.Add(ws.Range["A51"]); will insert the page break at column F. For your reference, we have attached the sample below. Could you please find the sample and let us know if this helps you?

Sample Link:

If you still encounter any issue, it would be great if you could revert back with a simplified issue reproducing sample or the input template, which will help us to investigate further.

Please let us know if you need any further assistance.

Pauline Bosco


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.