The PageBreak Tag

During transformation, Page Breaks may created using the "pageBreak" tag. This tag must be bodiless. Excel page breaks may be created horizontally below the tag cell or vertically to the right of the tag cell. It is possible to create both or neither on the same cell.

Use the optional "display" attribute to display the contents of the cell, if any.

Attributes

• The "pageBreak" tag supports all base tag attributes.
• type: String Required. Create an Excel Page Break on the row below or the column to the right of the cell. Here are the possible values:
• rows Create a horizontal Excel Page Break below this cell.
• cols Create a vertical Excel Page Break to the right of this cell.
• both Create a horizontal Excel Page Break below this cell and a vertical Excel Page Break to the right of this cell.
• none Do not create any Excel Page Break here.
• display: RichTextString Optional. This determines the contents of the cell. The default is blank.

Example

In this example, horizontal and vertical Excel Page Breaks are created. One tag creates both on one cell.

After transformation, horizontal and vertical Excel Page Breaks have been created. Notice that on cell C3, both a horizontal and a vertical break are created. Also notice that on cell I9, no page breaks are created. The break between columns H and I was created by the tag on H4, and the break between rows 8 and 9 was created by the tag at D8.

When opening a JETT-created spreadsheet with page breaks created, the page breaks may not be visible until after viewing a Print Preview in Excel.