Page breaks

Page breaks

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

• 

  yianeco

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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
     
     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

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 18 June 2018, 11:31 pm EST

  Hi Yiannis,

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

  Thanks,
  
  Deepak Sharma

• 

  yianeco

  • Post Options:
  • Link
    Copy

  Posted 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?

  Regards

  Yiannis

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 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.

  Thanks,
  
  Deepak Sharma