How to insert automatic PageBreak in Excel Template?
We found various notes an treads about Excel template "PageBreak" to split outputs in multiple pages, but our need is to insert a page break in order to control printed excel outputs.
Instead of doing the formatting on the output, we do need to embed it into the template.
In this example, we've this excel template for MinMax Report and where data is displayed for each item (between the 2 red dots).
As you can see there are different parts that display multiple rows (2 blue dots). Then this block might/might not fit in one page before fetching for another item.