I’m trying to print a filtered sheet over a number of pages but it’s always on one page, with most of the cells disappearing off below the print area. I’ve tried manual page breaks, which make no difference. I’ve tried changing the zoom to width of 1 page, which makes no difference, except the columns are spread across two pages. Last time I opened the spreadsheet I had no problem at all.
Tell me I don’t have to copy and paste the filtered data to a new sheet…
Take a look in Menu/Tools/Options/LibreOffice calc/Print/Always apply manual breaks.
edited 20190801
Then in the Menu/Format/Page - [Sheet], verify the scale option.
I tried that, it had no effect.
Following your edit also made no difference.
So please attach a sample file with the issue.