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.

Page break

Thread ID:

Created:

Updated:

Platform:

Replies:

40280 Jan 30,2006 11:02 AM Jan 31,2006 02:06 PM Windows Forms 5
loading
Tags: XlsIO
Francis Ouellet
Asked On January 30, 2006 11:02 AM

Hi, I want to insert a page break at a line to print on 2 pages. But my code seem to not working: objOutputWS.HPageBreaks.Add(objOutputWS.Range(ligneEnCours, 1))

Ramu [Syncfusion]
Replied On January 31, 2006 04:21 AM

Hi Francis, I am afraid. I was unable to see your problem. Here I have created test sample to see the problem. Please take a look at attached sample and modify the sample to reproduce your problem. I have created the sample in version 4.1.0.50. Could you let me know the version you are using? PageBreak Please let me know if you have any questions. Thanks, Ramu.k

Francis Ouellet
Replied On January 31, 2006 09:42 AM

Hi Ramu, I''m using Syncfusion.ExcelRW.Base, runtime version v1.1.4322, version 3.301.0.0. The code execute without error but I can''t see pagebreak in me excel sheet. Dim objOutputWS As Syncfusion.ExcelRW.IWorksheet objOutputWS = myWorkBook.Worksheets("Approbation") objOutputWS.HPageBreaks.Add(objOutputWS.Range(10, 1)) ''Page break objOutputWS.VPageBreaks.Add(objOutputWS.Range(10, 10)) Any suggestion? >Hi Francis, > >I am afraid. I was unable to see your problem. Here I have created test sample to see the problem. Please take a look at attached sample and modify the sample to reproduce your problem. I have created the sample in version 4.1.0.50. Could you let me know the version you are using? > >PageBreak > >Please let me know if you have any questions. > >Thanks, >Ramu.k >

Ramu [Syncfusion]
Replied On January 31, 2006 12:55 PM

Hi Francis, Sorry for the inconvenience caused. Still, I was not able to reproduce the problem. Could you please send me the generated excel sheet so that I could reproduce the problem at home. Thanks for your patience. Thanks, Ramu

Francis Ouellet
Replied On January 31, 2006 01:08 PM

Hi Ramu, No problem, see attachment. This excel file was generated with a template .xlt. Thanks

sample12.zip

Ramu [Syncfusion]
Replied On January 31, 2006 02:06 PM

Hi Francis, Thanks for sending the excel sheet. Please change the Scaling option in the page setup dialog to AdjustTo 100% for your excel sheet. Now you could insert the page break in any row or column. I hope this resolves your problem. Please let me know if need any further assistance. Thanks, Ramu

CONFIRMATION

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.

;