LO Calc 4.1.4.2
May be related to Bug 64703

The problem occurs when a ROW BREAK is inside hidden rows. Whether the rows are hidden manually or by a filter doesn't matter.

Steps to reproduce.
New Spreadsheet
Fill A1:A100 with any printable value, enough to make 2 printable pages.
Select Row 10, Insert, Page Break, Row Break
Hit print preview to see expected result: Multi page print with pages correctly formatted between bottom and top margin. The first page is short.
Hide rows 2-12. The ROW BREAK is now hidden.
Hit print preview

Unexpected result: One page print which goes past the bottom margin off the page.

Expected result: Multi page print with pages correctly formatted between top and bottom margin.

Note: Print Preview, Print Dialog Preview, Print, and Export to PDF are affected.

Note: When the bug is activated the print preview screen takes noticeably longer to produce a complete preview. This slow painting can be seen on an i3 based Celeron G530 when the page is set to Landscape and a many column spreadsheet fills the entire preview with text.

****
Another bug:

Show all rows. Hide rows 2-9. Now the row break is at the top of the visible rows.
Format, Print Ranges, Edit, User Defined, Rows to Repeat: $1

Unexpected result: The first page prints a single line of text consisting of the header row with a blank page underneath.

Expected result: The first page should have printed text below the header row. The header row should only print when there is printable data following it.

Note: Microsoft Excel XP also does not handle this correctly so maybe it's best to just leave it.