Search Results for

    Show / Hide Table of Contents

    TExcelFile.InsertHPageBreak Method

    Overloads

    • TExcelFile.InsertHPageBreak(Integer)
    • TExcelFile.InsertHPageBreak(Integer, Boolean)

    TExcelFile.InsertHPageBreak(Integer)

    Inserts a Horizontal Page Break at the specified row. If there is one already, it will do nothing. If the number of pagebreaks is bigger than the maximum Excel can admit, it will add it anyway, but you might get an exception when saving the file as xls. Exporting as images or PDF will use those additional page breaks. To control what to do when there are too many page breaks, see ErrorActions

    Syntax

    Unit: FlexCel.Core

    procedure TExcelFile.InsertHPageBreak(const row: Integer); overload;

    Parameters

    <-> Parameter Type Description
    const row Integer Row where to insert the page break. All row numbers are 1-based, and the breaks occur after the row.
    Note that row can be 0, and this would mean a page break before row 1. (which Excel will ignore)

    See also

    • TExcelFile

    TExcelFile.InsertHPageBreak(Integer, Boolean)

    Inserts a Horizontal Page Break at the specified row. If there is one already, it will do nothing. If the number of pagebreaks is bigger than the maximum Excel can admit, it will add it anyway, but you might get an exception when saving the file as xls. Exporting as images or PDF will use those additional page breaks. To control what to do when there are too many page breaks, see ErrorActions

    Syntax

    Unit: FlexCel.Core

    procedure TExcelFile.InsertHPageBreak(const row: Integer; const aGoesAfter: Boolean); overload; virtual; abstract;

    Parameters

    <-> Parameter Type Description
    const row Integer Row where to insert the page break. All row numbers are 1-based, and the breaks occur after the row.
    Note that row can be 0, and this would mean a page break before row 1. (which Excel will ignore)
    const aGoesAfter Boolean This is used by FlexCelReport to add page breaks that behave as if they affected the next row, not the row at the top.

    See also

    • TExcelFile
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com