Page breaks

Posted by: yianeco on 17 June 2018, 3:18 am EST

  • Posted 17 June 2018, 3:18 am EST

    Some questions about page breaks.
    1. Is there a way to remove all page breaks from a sheet in an easy way?
    I have tried
    but I think it does not work.

    2. I have the impression that Clearrange removes page breaks also or after that PrintNextPagebreakRow does not work correctly ?

    Please advise


  • Replied 18 June 2018, 11:31 pm EST

    Hi Yiannis,

    You can set the PrintScalingmethod to bestfit to get rid of pagebreaks.
    fpSpread1.PrintScalingMethod = PrintScalingMethodBestFit

    Deepak Sharma
  • Replied 19 June 2018, 2:30 am EST

    But I want to specify where a page break occurs.
    Otherwise I will not get the results I want.

    Pagebreaks and PrintScaleMethod=3 (best fit) do they work together?.
    What supersedes?


  • Marked as Answer

    Replied 19 June 2018, 4:55 pm EST

    HI Yiannis,

    Page breaks and best fit do not work together. Best fit will override the pagebreaks and set the page break as per the best fit.

    Deepak Sharma

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels