Scale to Fit

Scale to Fit

Posted by: tony.leatham on 12 August 2019, 9:56 pm EST

• 

  tony.leatham

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 August 2019, 9:56 pm EST

  Hi

  I need to be able to set a page area within a worksheet, and then output that to a single page PDF.

  This works fine if the print area results in a single page. But if the print area results in a multipage PDF, I cannot find any way to say “scale to fit”

  I’ve tried many things including setting FitToPagesTall/FitToPagesWide (completely ignored), various ways with the new printmanager class.

  But nothing works. Ideally, there should be a Scale to Fit option when saving the PDF

  Is there something I’ve missed?

  Thanks

  Tony

• 

  tony.leatham

  • Post Options:
  • Link
    Copy

  Posted 12 August 2019, 11:25 pm EST

  Actually, I figured it out. Consider this a case of bad documentation. Turns out that to use FitToPagesWide you have to make IsPercentScale false.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 13 August 2019, 11:04 pm EST

  Hi Tom,
  
  That’s correct. If IsPercentScale property is false, FitToPagesWide and FitToPagesTall work. This has already been documented here: https://help.grapecity.com/gcdocs/gcexcel/onlinehelp/webframe.html#GrapeCity.Documents.Excel~GrapeCity.Documents.Excel.IPageSetup~IsPercentScale.html

  Best wishes,
  
  Ruchir