GrapeCity.Documents.Excel.IWorksheet.FixedPageBreaks

FixedPageBreaks Property

FixedPageBreaks

Gets or sets whether the horizontal and vertical page breaks are fixed when rows or columns are inserted or deleted.

When this property is true, existing page break positions remain fixed during row or column insertion and deletion operations.

Declaration

bool FixedPageBreaks { get; set; }

Property FixedPageBreaks As Boolean

Examples

worksheet.Range["A1:T32"].Value = 1;
IHPageBreak pageBreak = worksheet.HPageBreaks.Add(worksheet.Rows[7]);
worksheet.FixedPageBreaks = true;
bool fixedPageBreaks = worksheet.FixedPageBreaks;
worksheet.Rows[6].Insert();
IRange location = pageBreak.Location;