Problem printing selected rows from spread only

Posted by: woodie on 8 September 2017, 12:44 pm EST

  • Posted 8 September 2017, 12:44 pm EST


    I am using FarPoint Spread version 2.5.2009.2005.
    Is there an easy way to print only the selected rows from a spread with the    spread.PrintSheet(spread.ActiveSheet); method?

    Thank you,
  • Replied 8 September 2017, 12:44 pm EST

    You need to set the PrintType property on the PrintInfo object for that sheet to CellRange then set the ColStart, ColEnd, RowStart and RowEnd properties on the PrintInfo object to the appropriate values for the selected range.
  • Replied 8 September 2017, 12:44 pm EST

    Thank you for the reply. I have tried what you suggested.
    I set the folowing props:

                spread.ActiveSheet.PrintInfo.RowStart = 0;
                spread.ActiveSheet.PrintInfo.RowEnd = 2;
                spread.ActiveSheet.PrintInfo.PrintType = PrintType.CellRange;
    and it worked great. It printed the first 3 rows from the spread.

    But how about if  I want to print the row with the folowing indexes: 0, 2, 3, 5, 10.
    How can I do that?

    Thanks for your answer.

  • Replied 8 September 2017, 12:44 pm EST

    You would either need to hide the rows in between before printing , do separate print jobs or do a custom print using the OwnerPrintDraw method.
Need extra support?

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

Learn More

Forum Channels