Posted by: tosch on 8 September 2017, 2:52 pm EST

  • Posted 8 September 2017, 2:52 pm EST

    I have a large spread with 2 columns for each day in a year.

    Now I want to print the spread on a banner size paper (297x1200mm). I can fit about 3 1/2 months on one page. The font is rather small on the screen and also on paper.

    Is it possible to have a scalerule to increase the printing size so that 3 months fit on one page and fill the whole width of the page not only about 80%?

    I tried adding a scalerule with a startfactor of 2, an endfactor of 0.1 and an interval of 0.1. This didn't help.

    BTW: I'm still using version 3.0.2010.2005
  • Replied 8 September 2017, 2:52 pm EST

    I know about SmartPrintRules and ScaleRule class.

    My question is: can I make the output larger so that it fits the whole width of a page? I have a ScaleRule that has 2 as the start parameter. Does this mean the output is scaled by factor 2 and then checked if it fits? And then decreased until it fits or reaches the end factor.



  • Replied 8 September 2017, 2:52 pm EST

    You can set the margins in PrintInfo to zero if you like but there will still be a hard margin your printer will not print beyond, thats a hardware limitation. Also if you use SmartPrintRules, you can use our ScaleRule class. This is all discussed in the help file installed on your pc with sample code snippets.
  • Replied 8 September 2017, 2:52 pm EST


    Yes you are right, Spread tries to optimize the printing using the ScaleRule defined by you, and fit the contents on the page as per your printing rules, and in case it could not print with those rules it gets to normal printing and prints accordingly. As, per my understanding of the description provided by you the Spread, is getting 3 1/2 months printed on one page, and you want 3 months on one page, so you can even try using the PageBreak property of column to fix the number of columns printed on one page, or I should say that printing moves onto next page before the Column for which the property is set. This link would provide the details of the property:


    Hope it will help you. Please let me know if you have any queries further.


    Manpreet Kaur.

  • Replied 8 September 2017, 2:52 pm EST

    I already have defined a page break after 3 months. Spread prints the 3 months on about 80% of the page.

    All I want is spread to increase the 'zoom'-factor of printing so the 3 months print on 100% of the page.


  • Replied 8 September 2017, 2:52 pm EST

    When the smart print feature is turned on (see UseSmartPrint property in PrintInfo class), the spreadsheet attempts to fit the printed output to a specified number of pages (see SmartPrintPagesTall and SmartPrintPagesWide properties in PrintInfo class). If the output fits with normal print settings then the normal print settings are used. Otherwise, the smart print feature attempts to find an combination of alternate print settings (e.g. landscape mode, reduced print scale, reduced column widths) that will allow the output to fit. If no combination of alternate print settings can be found that makes the printed output fit then the normal print settings are used. The ScaleRule descibes which print scales to consider when attempting to fit the printed output to the specified number of pages.

    In summary, the ScaleRule can be used to reduce the size of the printed output to fit in a specified number of pages. The ScaleRule can not be used to increase the size of the printed output to completely fill the page.

  • Replied 8 September 2017, 2:52 pm EST

    ok, thanks for the clarification
Need extra support?

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

Learn More

Forum Channels