I have a document that is organized in groups of 5 rows. The text in some of these rows is wrapped, so the height changes depending on the content. Is there a way to bind those rows together so if one of the groups of 5 does not fit in one page, the whole group is moved to the next page?
I think this can only be done with a macro.
If there isn’t assured that none of the groups of five can be to high for a single page, no macro can do it. There must be a clearer and always applicable rule where page breaks should be inserted.
Anyway, a design based on grouped rows should be reconsidered. It may be too problematic under more aspects than just the one of page breaks when printing. Calc sheets aren’t paper sheets.
I think we are moving forward if we see an uploaded file illustrating the problem.