Page breaks

Posted by: yianeco on 17 June 2018, 12:18 pm EST

  • Posted 17 June 2018, 12:18 pm 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
    book1.row=-1
    book1.pagebreak=false
    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

    Regards

    Yiannis
  • Replied 19 June 2018, 8:31 am EST

    Hi Yiannis,

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

    Thanks,
    Deepak Sharma
  • Replied 19 June 2018, 11: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?

    Regards

    Yiannis
  • Marked as Answer

    Replied 20 June 2018, 1:55 am 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.

    Thanks,
    Deepak Sharma

Need extra support?

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

Learn More

Forum Channels